|
# 42681
Chi
来自: Mexico
|
|
|
 To: Eygle
About the occurrence of log 2 sequence# 1012 cannot be archived, because I run 2 import pump continuously, therefore I forgot to check the alert log file.However I never expected that the import pump with the table_exists_action would create so much archivelog.If I just use regular fresh import pump, drop/recreate the schemas, then I did not got that (maybe that soon)
Now another question about the RMAN backup slowness on my AIX 5.3L system.I think it is because of the wrong filesytem setup with the jfs type.I just read this paper-http://www-1.ibm.com/servers/aix/whitepapers/db_perf_aix.pdf, because on my test linux machine, there is no slowness of rman backup. while on this AIX box with jfs filesystem, I have to diable the disk_asynch_io of oracle to speed up the backup.WHat do U thin?
From: Chi
2007.02.06 00:29
|
|
|
|
|
# 42679
rocket_zhao
|
|
|
To: eygle
您好：
我自学ORACLE已经快4年了，但进步总是很小。我现在又出现了一个停滞。
请教盖老师如何才能取得更大的进步。另外，除了掌握ORACLE的知识外还需要涉猎那些方面的知识，以便支持oracle的学习。
From: rocket_zhao
2007.02.05 14:49
|
|
|
|
|
# 42677
yang_shuo
|
|
|
To: eygle
我用alter session set events 'immediate trace name controlf level 10';dump出来的/u01/app/oracle/admin/testdb/udump/testdb2_ora_21059.trc是这样的
/u01/app/oracle/admin/testdb/udump/testdb2_ora_21059.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name:Linux
Node name:node2
Release:2.6.9-5.EL
Version:#1 Wed Jan 5 19:22:18 EST 2005
Machine:i686
Instance name: testdb2
Redo thread mounted by this instance: 2
Oracle process number: 23
Unix process pid: 21059, image: oracle@node2 (TNS V1-V3)
是我哪搞错了，请指教。。。。。
From: yang_shuo
2007.02.05 12:13
|
|
|
|
|
# 42676
janson
|
|
|
To: eygle
非常感激,将试验一下
From: janson
2007.02.04 15:03
|
|
|
|
|
# 42674
janson
|
|
|
To: eygle
eygle 大侠,我是VCS 新手,请教一个问题:
因ORACLE 数据空间不够,需加新的VOLUME/FILE SYSTEM 到ORACLE RESOURCE GROUP 中.
在修改main.cf 之前,是否需要 stop 或freeze VCS?
方法1:
# hastop -all -force
(现在,改main.cf)
#hastart
方法2:
# haconf -makerw
# hagrp -freeze <service group>
# haconf -dump -makero
(现在,改main.cf)
# hares -clear <resource name>
# hagrp -online <sevice group> -sys <system>
# haconf -makerw
# hagrp -unfreeze <service group>
# haconf -dump -makero
请问那个方法对? 若都不对,万望指点正确步骤.多谢!
From: janson
2007.02.02 18:37
|
|
|
|
|
To: janson
stop肯定是不需要的，否则生产系统不是Down掉了?
先临时freeze，然后添加，再unfreeze就好了
不过注意import dg的时候要加-t参数，否则会引起切换。
建议最好用gui界面作这些
From: eygle
2007.02.04 11:20
|
|
|
|
|
# 42673
yang_shuo
|
|
|
To: eygle
《深入浅出》p13，应该是alter session set events 'immediate trace name file_hdrs level 10'如果是alter session set events 'immediate trace name controlf level 10'，找不到p14，p15的信息。
From: yang_shuo
2007.02.02 17:08
|
|
|
|
|
To: yang_shuo
没错的，你dump出来看看
From: eygle
2007.02.02 22:23
|
|
|
|
|
# 42670
桂林
|
|
|
To:
开始以为是我的表jj被缩或者其他问题，但使用下面的ｓｑｌ仍然很慢，几个小时都没有执行完成。
Create Table aaa As
Select FXFLID,SPXXID,XSSL,PM,SPBH,DJ,CSM,CBNY,'1' xsflid,YWLX
From(
Select sp.SPBH,sp.DJ,sp.CSM,sp.cbny,sp.ywlx, xs.spxxid,xs.xssl,sp.PM,sp.FXFLID From
(Select x.SPXXID ,Sum(x.xssl) xssl
From jt_webk_xsdmx x Left Join jt_j_spxx s On s.spxxid=x.spxxid
Where s.fxflid In (Select fxflid From jt_webk_phfldz Where phflid=1)
And XSRQ Between to_date('2006-10-01','yyyy-mm-dd') And to_date('2007-01-01','yyyy-mm-dd')
Group By x.SPXXID) xs
Left Join jt_j_spxx sp On sp.spxxid=xs.spxxid
Order By xs.xssl Desc) aa
老大帮忙分析下好吗
谢谢了
From: 桂林
2007.02.01 18:57
|
|
|
|
|
To: 桂林
慢的时候，你查看v$sesion_wait，看等待事件，看数据库再等什么啊。
From: eygle
2007.02.02 10:31
|
|
|
|
|
# 42669
桂林
|
|
|
To:
但如果我使用这个语句把查出来的数据插入到一个表中的时候则奇慢无比，根本没有执行下去的勇气，CUP占用30%以上。
Insert Into jj( fxflid, spxxid, xssl, pm, spbh, dj, csm, cbny, xsflid, ywlx)
Select FXFLID,SPXXID,XSSL,PM,SPBH,DJ,CSM,CBNY,'1' xsflid,YWLX
From(
Select sp.SPBH,sp.DJ,sp.CSM,sp.cbny,sp.ywlx, xs.spxxid,xs.xssl,sp.PM,sp.FXFLID From
(Select x.SPXXID ,Sum(x.xssl) xssl
From jt_webk_xsdmx x Left Join jt_j_spxx s On s.spxxid=x.spxxid
Where s.fxflid In (Select fxflid From jt_webk_phfldz Where phflid=1)
And XSRQ Between to_date('2006-10-01','yyyy-mm-dd') And to_date('2007-01-01','yyyy-mm-dd')
Group By x.SPXXID) xs
Left Join jt_j_spxx sp On sp.spxxid=xs.spxxid
Order By xs.xssl Desc)
From: 桂林
2007.02.01 18:57
|
|
|
|
|
eygle.com
我要留言
回复
编辑
SYS$USERS) 2007-02-06 06:10:35.453
