|
# 42929
Chi
来自: Mexico
|
|
|
 To: Eygle
Can you explain specifically what do u mean the “锁定的问题”? in the discussion of the “alter system archive log current”.From your display, it seems to me that when you switch the archive current log, the previous log sequence is still running under the same thread, so there is a competition for the same spid.While you issue a
SQL> archive log stop;
then
SQL> archive log start;
you generated “ARC0: Unable to archive log 5 thread 1 sequence 324” because OS has give priority to next sequence log; but when you just issue “archive log stop”, you force to stop the previous sequence log.Then with “alter system archive log current”, you requests OS to allocate a new process, which is the same one.Am I right?
p.s. Nice picture.
From: Chi
2007.06.11 22:34
|
|
|
|
|
# 43366
SNOW
|
|
|
To: eygle
盖老师：
我的数据库报出错误ora-04030
我的内存设置为
sga=1.59G
data buffer=1350M
shared_pool_size=200M
pga=800M
我们的软件供应商数据库技术支持分析ora-04030 是因为我内存参数设置不合理导致的
他的意思是说SGA+PGA和 应该小于 1.7G
然后在biti老大的一篇文章《关于SGA设置的一点总结》中提到32bit 通常 SGA有 1.7G 的限制
我的理解是SGA小于1.7G,而不是 SGA+PGA<1.7G
From: SNOW
2007.06.11 21:43
|
|
|
|
|
# 42928
杨硕
|
|
|
To: 杨硕
所有者不再提供了。
From: eygle
2007.06.12 15:02
|
|
|
|
|
# 43364
杨硕
|
|
|
# 42926
lala
|
|
|
To:
有架9.2.0.3，6个instance
我在每个instance里grant create session,exp_full_database to bkupoper identified by secret;
挨个exp，有一个报错
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_RGT_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.schema_info_exp
. exporting cluster definitions
From: lala
2007.06.08 20:31
|
|
|
|
|
eygle.com
我要留言
,发现redolog还没有轮换完（还有好多inactive的log），程序就无法对目标表执行插入了（每次总是插入1500万条左右就挂了），看ADDM “数据库写入进程 (DBWR) 无法满足对空闲缓冲区的需要”是影响最大的因素，是否我们的这种配置（2 Xeon CPU，2G 内存，146G SCSI硬盘）压根达不到这种需求（10000条纪录/秒）呢？
回复
编辑
