快捷搜索:  as  2018  FtCWSyGV  С˵  test  xxx  Ψһ  w3viyKQx

和记娱专业h88285:清内存对象及转储的常用命令



一些清内存工具及转储的和记娱专业h88285实用敕令:

Oracle 9i清buffer cache

alter session set events和记娱专业h88285 '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 level 2';

转储library cache

ALTER SESSION SET EVENTS 'im和记娱专业h88285mediate

trace name LIBRARY_CACHE level n';

Level =1 ,转储Library cac和记娱专业h88285he统计信息

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 level 10';

alter session set events和记娱专业h88285 '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;

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