ORACLE 系统特权
2007.11.04 4:47 下午 »Author: bosonmaster »授予系统特权：
数据库： alter database ,alter system, audit system, audit any,
调试：debug connect session,debug any procedure
索引：create any index,alter any index,drop any index,
作业调度：create job,create any job,execute any program,execute any class,manage scheduler
过程： create procedure ,create any procedure,alter any procedure,drop any procedure execute any procedure
如何确定哪个表空间读写频繁?
2007.11.04 4:44 下午 »Author: bosonmaster »select name,phyrds,phywrts,readtim,writetim
from v$filestat a,v$dbfile b
where a.file# = b.file#
order by readtim desc
如何清除session 状态为sniped的会话
2007.11.04 4:43 下午 »Author: bosonmaster »Problem Description
——————-If “init.ora” resource_limit = true, and idle_time set in profile.
When idle_time exceeds, the session status becomes ’sniped’ in v$session,
but sniped sessions never get cleaned up.
Using ‘alter system kill session’ to kill the session, session status becomes
‘killed’ in v$session, but still is never cleaned up.
Read More »
常用SQL
2007.11.04 4:41 下午 »Author: bosonmaster »1 Library Cache Pin/Lock Pile Up
SELECT s.sid, kglpnmod “Mode”, kglpnreq “Req”, SPID “OS Process”
FROM v$session_wait w, x$kglpn p, v$session s ,v$process o
WHERE p.kglpnuse=s.saddr
AND kglpnhdl=w.p1raw
and w.event like ‘%library cache pin%’
and s.paddr=o.addr
Read More »
