?
快捷搜索:  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;

免責聲明:以上內容源自網絡,版權歸原作者所有,如有侵犯您的原創版權請告知,我們將盡快刪除相關內容。

您可能還會對下面的文章感興趣:

快三平台开户