ITPub博客

TKPROF stands for transient kernel profiler[@more@]Oracle's TKPROFTKPROF stands for transient kernel profiler. Enabling SQL TRACETo be able to use TKPROF, you must first enable sql trace. This can be done for either the instance or the session. If you want to change it for the entire instance, set sql_trace=true into the init.ora file and restart the instance. However, usually, you'll want to turn on sql trace for a particular session only. This can be done like so: alter session set sql_trace=t

早就开了这个博客了,一直没有使用,今天心血来潮,我写一回博客吧,[@more@]早就开了这个博客了,一直没有使用,今天心血来潮,我写一回博客吧,其实最主要的我的一个日记软件不能用了,我一想,得,还是用一下博客吧.所以就开始我今天的写作.第篇是由于我的使用EXPDP时,由于我的机器shared_pool太小,无法转储数据导致出现故障,所以查了一下资料,看到别人的博客上有这方面的清buffer_cache的方法,所以摘抄了一下.

关于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/786309i清buffer cachealter session set events 'immediat