快捷搜索:  as  test  1111  test aNd 8=8  test++aNd+8=8  as++aNd+8=8  as aNd 8=8

新蒲京澳门赌场网站:清内存对象及转储的常用命令



一些清内存工具及转储的实用敕令:

Oracle 9i清buffer cache

alter session set events 'immediate trace name flush_cache level 1';

alter session set events = 'immediate trace name flush_cache';

Oracle 10g中清buffer cache

alter system flush buffer_cache

清shared pool

alter system flush shared_pool;

转储sga

alter session set events 'immediate trace name heapdump le新蒲京澳门赌场网站vel 2';

转储library ca新蒲京澳门赌场网站che

ALTER SESSION SET EVENTS 'immediate

trace name LIB新蒲京澳门赌场网站RARY_CACHE level n';

Level =1 ,转储Library cache统计信息

Level =2 ,转储hash table概要

Level =4 ,转储Library cache工具,只包孕基础信息

Level =8 ,转储Library cache工具,包孕具体信息(包括child references,pin waiters等)

Level =16,增添heap sizes信息

Level =32,新蒲京澳门赌场网站增添heap信息

转储节制文件、日志文件、数据文件:

alter session set events 'immediate trace name controlf le新蒲京澳门赌场网站vel 10';

alter session set events 'immediate trace name redohdr level 3';

ALTER SYSTEM DUMP LOGFILE '/opt/oracle9/oradata/testora9/redo01.log';

alter system dump datafile 3 block max 2 block min 4;

免责声明:以上内容源自网络,版权归原作者所有,如有侵犯您的原创版权请告知,我们将尽快删除相关内容。

您可能还会对下面的文章感兴趣: