如何确定哪个表空间读写频繁?
星期天, 十一月 4th, 2007select name,phyrds,phywrts,readtim,writetim
from v$filestat a,v$dbfile b
where a.file# = b.file#
order by readtim desc
Archive for the ‘oracle’ Category
如何清除session 状态为sniped的会话
星期天, 十一月 4th, 2007Problem 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.
(全文…)
常用SQL
星期天, 十一月 4th, 20071 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
(全文…)
10g EM乱码解决方案–转自 www.eygle.com
星期六, 十一月 3rd, 2007一直没怎么用10g的EM工具,今天打开来看看,发现也有相传已久的乱码问题.网上也流传着N种解决方案,仔细看一下,其实这个问题很好解决.
如果安装时,我们系统环境变量设置的是中文环境,那么就不会有这个问题.这个问题根本原因在于安装时,JDK/JRE字符集的自动选择.
OEM的创建–修复–删除
星期六, 十一月 3rd, 2007当你没有OEM时,你可以通过以下几个命令来创建一个,当你出问题时,你也可以通过以下命令重新配置.
创建一个EM资料库
emca -repos create
重建一个EM资料库
emca -repos recreate
删除一个EM资料库
