-
2008-08-22 09:19:10
/ Oracle数据库管理
为什么是redo切换时间差负值? 请指教SQL> conn system/oracle123@zgdb1Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.3.0Connected as systemSQL>SQL> select start_recid, start_time, end_recid, end_time, minutes2from (select test.*, rownum as rn3from (select b.recid start_recid,4to_char(b.first_time, 'yyyy-mm-dd hh24:mi:ss') start_time,5a.recid end_recid,6to_
查看(98)
评论(3)
-
2008-08-20 09:26:33
/ Oracle数据库管理
SELECT d.segment_name,extents,optsize,shrinks,aveshrink,aveactive,d.statusFROM v$rollname n, v$rollstat s, dba_rollback_segs dWHERE d.segment_id = n.usn(+)and d.segment_id = s.usn(+);SEGMENT_NAME EXTENTS OPTSIZE SHRINKS AVESHRINK AVEACTIVE STATUSSYSTEM 60 0 6553 ONLINE_SYSSMU1$ONLINE_SYSSMU2$ONLINE_SYSSMU3$ONLINE_SYSSMU4$ONLINE_SYSSMU5$ONLINE
查看(128)
评论(8)
-
2008-04-23 10:15:55
/ Oracle数据库管理
偶在网上找了好久没有没有找到处理方法,请教各位如何处理,谢谢:OS:aix 5.3 hacmp5.3 rac:10.2.0.3create or replace directory backup as '/u01/backup';grant read, write on directory backup to system;$ expdp system/oracle@cdrac1 schemas=aoyun_2008 directory=backup dumpfile=expdp3.dmp logfile=expdp3.logExport: Release 10.2.0.3.0 - 64bit Production on Saturday, 19 April, 2008 21:02:20Copyright (c) 2003, 2005, Oracle.All rights reserved.Connected to: Oracle Database 10
查看(421)
评论(5)
-
2008-01-02 14:09:54
/ Oracle数据库管理
查看(422)
评论(2)