清内存对象及转储命令

关于ORACLE10及9i的清除buffer_cache及shared_pool的命令!

[@more@]

清内存对象及转储命令(zt)

===========================================================

作者: xsb(http://xsb.itpub.net)
发表于:2006.05.12 14:01
分类: Oracle
出处：http://xsb.itpub.net/post/419/90129
---------------------------------------------------------------

清buffer cache
清shared pool
转储sga
转储library cache
转储控制文件、日志文件、数据文件

Ref: http://haochunpeng.itpub.net/post/385/78630

9i清buffer cache
alter session set events 'immediate trace name flush_cache level 1';

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

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 'immediate trace name LIBRARY_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 level 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;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/330796/viewspace-867540/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/330796/viewspace-867540/