• redo切换问题

    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_
  • 请教segment的使用情况

    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
  • 请教expdp问题

    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
  • ora-0600错误

    2008-01-02 14:09:54   /   Oracle数据库管理

我的存档

数据统计

  • 访问量: 10
  • 建立时间: 2008-01-10
  • 更新时间: 2008-01-10

RSS订阅

Open Toolbar