shared pool:library cache, data dictionary cache, (user global area for shared server)
para:shared_pool_size,shared_pool_resved_size,open_cursors,cursor_space_for_time,session_cached_cursors,cursor_sharing
lib cache: sql statements and pl/sql block, LRU algorithm,prevent statements reparsing, ORA-04031
sql sharing criteria:compare, hash ,text(space,case,comments)
v$sysstat parse count(hard) -> cursor_sharing=similar
use bind variables :bind variable name
v$librarycache
v$sql v$sqlarea v$sqltext v$sql_plan v$db_object_cache
statistics: reload,invalidation, free memory,hit ratio (sum(reloads)/sum(pins) <1%)
sizing library cache:v$shared_pool_advice
package: dbms_shared_pool
keep large object: execute dbms_shared_pool.keep('pkg name');
dd cache:v$rowcache
large pool para:large_pool_size
Oracle tuning the shared pool
最新推荐文章于 2024-03-15 08:00:00 发布