# 43784
jjxlcsw
|
|
To: eygle
大师:
lock.type = 'TS''Temporary segment enqueue lock,
'New block allocation enqueue lock
这个lock。产生的原因是什么。找了半天也没看到
From: jjxlcsw 2007.12.09 18:23
|
|
|
|
To: jjxlcsw
[COLOR=blue]要看等待事件,找出id1,id2,就能定位了
对于临时段,id1代表ts#,id2代表Relative DBA
[/COLOR]
From: eygle 2007.12.10 00:30
|
|
|
|
# 43781
迷
|
|
To: eygle
hi,eygle
有个问题,一台HP的小型机,跑有DP备份软件,但最近两天用top命令发现
rman进程一直占用99%的cpu,还好系统cpu平均占用率还不高,不知道是怎么
回事?rman备份会占用很多的资源吗?该从那方面查证?
From: 迷 2007.12.08 07:40
|
|
|
|
To: 迷
[COLOR=blue]
同样的,看等待事件,如果占用资源过高,从等待事件应该能找到原因。
[/COLOR]
From: eygle 2007.12.10 00:21
|
|
|
|
# 43779
weihua
来自: hy
|
|
To:
oracle8i win2000 mcqtalrt.log
ump file E:\MCQT\DUMP\mcqtALRT.LOG
Fri Dec 07 10:18:57 2007
ORACLE V8.1.7.0.0 - Production vsnsta=0
Fri Dec 07 10:19:10 2007
Errors in file E:\MCQT\DUMP\mcqtSNP1.TRC:
ORA-00600: internal error code, arguments: [4193], [4362], [4463], [], [], [], [], []
Fri Dec 07 10:19:12 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 12657 Reading mem 0
Mem# 0 errs 0: E:\MCQT\LOG\LOGMCQT1.ORA
Fri Dec 07 10:19:12 2007
Restarting dead background process SNP2
SNP2 started with pid=9
Fri Dec 07 10:19:13 2007
Errors in file E:\MCQT\DUMP\mcqtSNP0.TRC:
ORA-00600: internal error code, arguments: [4193], [4850], [4953], [], [], [], [], []
From: weihua 2007.12.06 20:15
|
|
|
|
To: weihua
[COLOR=blue]
4193通常就是回滚段出了问题,参考:
http://www.eygle.com/archives/2005/12/oracle_howto_deal_with_ora600_4137_error.html
[/COLOR]
From: eygle 2007.12.10 00:20
|
|
|
|
# 43778
oralnx
|
|
To: Eygle
Eygle:
怎样把ERP Database 上的文件Delete?
用什么命令
谢谢
From: oralnx 2007.12.06 18:20
|
|
|
|
To: oralnx
什么文件?
From: eygle 2007.12.06 23:05
|
|
|
|
# 43777
oralnx
|
|
To: eygle
eygle
能不能把打Patch 所用到的命令,每个命令的功能,意思说明
给整理出来,供我们这些初学者参考一下呢?
谢谢盖老师先
From: oralnx 2007.12.06 06:11
|
|
|
|
To: oralnx
这是Oracle公司的活啊!
From: eygle 2007.12.06 23:05
|
|
|
|
# 43774
oralnx
|
|
To: eygle
eygle
问个比较弱智的问题,adpatch 中,ad 是什么意思
From: oralnx 2007.12.05 04:57
|
|
|
|
To: oralnx
[COLOR=blue]AD is an abbreviation for
Applications DBA[/COLOR]
From: eygle 2007.12.05 18:13
|
|
|
|
# 43773
oralnx
|
|
To: eygle
eygle:
请问你能不能给提供一个详细的打Patch的中文文档
谢谢
From: oralnx 2007.12.05 04:49
|
|
|
|
|