#查看共享池命中率,小于99%,就需要增加大小
SELECT SUM(PINS) "EXECUTIONS", SUM(RELOADS) "CACHE MISSES WHILE EXECUTING" FROM V$LIBRARYCACHE;
#Oracle里的BUG,miscellaneous会不断增长,最终导致ora-04031错误,解决、规避方法:
statistics_level TYPICAL(默认) => basic
或者
_object_statistics TRUE(默认) => false
db_cache_advice ON(默认) => false
查看:
SELECT statistics_name,
session_status,
system_status,
activation_level,
session_settable
FROM v$statistics_level
ORDER BY statistics_name;
87. 如何測試SQL語句執行所用的時間?
SQL>set timing on ;
SQL>select * from tablename;
#crontrl 文件在创建时,必须使用字符文件设备,
如ls -l
brw-rw---- 1 oracle dba 47, 13 Jul 23 01:21 /dev/lv_ctl92_1
crw-rw---- 1 oracle dba 47, 13 Jul 23 01:55 /dev/rlv_ctl92_1
只能使用/dev/rlv_ctl92_1创建
SELECT SUM(PINS) "EXECUTIONS", SUM(RELOADS) "CACHE MISSES WHILE EXECUTING" FROM V$LIBRARYCACHE;
#Oracle里的BUG,miscellaneous会不断增长,最终导致ora-04031错误,解决、规避方法:
statistics_level TYPICAL(默认) => basic
或者
_object_statistics TRUE(默认) => false
db_cache_advice ON(默认) => false
查看:
SELECT statistics_name,
session_status,
system_status,
activation_level,
session_settable
FROM v$statistics_level
ORDER BY statistics_name;
87. 如何測試SQL語句執行所用的時間?
SQL>set timing on ;
SQL>select * from tablename;
#crontrl 文件在创建时,必须使用字符文件设备,
如ls -l
brw-rw---- 1 oracle dba 47, 13 Jul 23 01:21 /dev/lv_ctl92_1
crw-rw---- 1 oracle dba 47, 13 Jul 23 01:55 /dev/rlv_ctl92_1
只能使用/dev/rlv_ctl92_1创建