eygle.com   eygle.com
eygle.com  
 
留言簿 - Powered by eYgLe.Com
eygle.com 我要留言
DBA警世录:备份重于一切
昵称
内容 页: < 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 > >> - 302
# 43786
StepIn




To: eygle
  请问一下eygle,能否推荐一两本书可以跟《循序渐进Oracle》配合读的,我是初学者,想通过学习,参加认证考试。
From: StepIn
2007.12.11 16:07

版主选项: 回复 编辑
# 43785
oralnx




To: Eygle
  盖老师:
这几个东东,分别起什么作用?
谢谢...
Adalnctl.shadcmctl.sh adfmsctl.shadrepctl.shgsmstart.sh
Adapcctl.shaddisctl.shadfrmctl.shadstpall.shjtffmctl..sh
Adaprstctl.shadexecsql.pl adncnv.log adstrtal.sh
Adautocfg.sh adfmcctl.shadpreclone.pladtcfctl.sh


From: oralnx
2007.12.11 13:12

版主选项: 回复 编辑
# 43784
jjxlcsw




To: eygle
  大师:
lock.type = 'TS''Temporary segment enqueue lock,
  'New block allocation enqueue lock
这个lock。产生的原因是什么。找了半天也没看到
From: jjxlcsw
2007.12.10 10:23
To: jjxlcsw
  要看等待事件,找出id1,id2,就能定位了
对于临时段,id1代表ts#,id2代表Relative DBA


From: eygle
2007.12.10 16:30

版主选项: 回复 编辑
# 43781





To: eygle
  hi,eygle
有个问题,一台HP的小型机,跑有DP备份软件,但最近两天用top命令发现

rman进程一直占用99%的cpu,还好系统cpu平均占用率还不高,不知道是怎么

回事?rman备份会占用很多的资源吗?该从那方面查证?
From:
2007.12.08 23:40
To:
  
同样的,看等待事件,如果占用资源过高,从等待事件应该能找到原因。

From: eygle
2007.12.10 16: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.07 12:15
To: weihua
  
4193通常就是回滚段出了问题,参考:
http://www.eygle.com/archives/2005/12/oracle_howto_deal_with_ora600_4137_error.html

From: eygle
2007.12.10 16:20

版主选项: 回复 编辑
# 43778
oralnx




To: Eygle
  Eygle:
怎样把ERP Database 上的文件Delete?

用什么命令
谢谢


From: oralnx
2007.12.07 10:20
To: oralnx
  什么文件?
From: eygle
2007.12.07 15:05

版主选项: 回复 编辑
# 43777
oralnx




To: eygle
  eygle
能不能把打Patch 所用到的命令,每个命令的功能,意思说明
给整理出来,供我们这些初学者参考一下呢?

谢谢盖老师先
From: oralnx
2007.12.06 22:11
To: oralnx
  这是Oracle公司的活啊!
From: eygle
2007.12.07 15:05

版主选项: 回复 编辑
# 43776
盘为




To:
  大师 你太久没更新了把
From: 盘为
2007.12.06 17:09
To: 盘为
  每天更新啊,看不到么?
From: eygle
2007.12.06 21:35

版主选项: 回复 编辑
# 43775
WEIHUA


来自: 衡阳


To: EYGLE
  ORACLE8I
ORA-600 [4193]
ORA-600 [525]
错误如何解决
From: WEIHUA
2007.12.06 15:39
To: WEIHUA
  信息不足,无法判断!
From: eygle
2007.12.06 21:35

版主选项: 回复 编辑
# 43774
oralnx




To: eygle
  eygle
问个比较弱智的问题,adpatch 中,ad 是什么意思

From: oralnx
2007.12.05 20:57
To: oralnx
  AD is an abbreviation for
Applications DBA

From: eygle
2007.12.06 10:13

版主选项: 回复 编辑

页: < 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 > >> - 302
我要留言
Copyright © 2003-2008 eygle.com All Rights Reserved.
Powered by: www.eYgLe.com