Oracle 10g에서 사용하는 기타 monitoring SQL들
– 10g의 statistics_level=typical이상이면 gathering됨.(but this view does not include undo block or undo header transfers)
|
1 2 3 4 5 6 7 8 |
SELECT object_name, statistic_name, SUM(value) waits FROM v$segment_statistics WHERE statistic_name = 'buffer busy waits' GROUP BY object_name, statistic_name ORDER BY waits DESC; |
– 10g, transaction에 대한 rollback하고 있는 정보 보기
|
1 2 3 4 5 6 7 8 9 |
SELECT * FROM v$fast_start_servers; SELECT message FROM v$session_longops; SELECT state, undoblocksdone, undoblockstotal, cputime FROM v$fast_start_transactions; |
– 10g, global cache activity를 class별로 볼수 있음.
|
1 2 3 4 5 |
SELECT * FROM v$instance_cache_transfer WHERE cr_busy > 0 ORDER BY INSTANCE, cr_busy DESC; |
– 10g, cluster wait 보기(현재 수행중인 … Continue reading