我的论坛主题

• 根据SPID查找正在执行的SQL, 竟然需要1分多钟,大家给看看

  2008-12-01 14:23:39   /   Oracle数据库管理

  RHEL4.5, 10.2.0.2,4颗四核CPU, 16G内存, 现在系统的压力很小, IDLE超过90%语句, 执行时间, 执行计划如下:大家帮忙给看看问题吧... 太奇怪了1SELECT2SQL_TEXT,HASH_VALUE,ADDRESS3FROM V$SQLTEXT A4WHERE (A.HASH_VALUE, A.ADDRESS) IN5(SELECT DECODE(SQL_HASH_VALUE, 0, PREV_HASH_VALUE, SQL_HASH_VALUE),6DECODE(SQL_HASH_VALUE, 0, PREV_SQL_ADDR, SQL_ADDRESS)7FROM V$SESSION B8WHERE B.PADDR = (SELECT ADDR FRO

  查看(116) 评论(4)

• order by sys_guid() 不生效

  2008-08-29 11:45:11   /   Oracle数据库管理

  RHEL4.5 + 10.2.0.2select * from (select * from user_objects order by sys_guid()) where rownum

  查看(2080) 评论(17)

• RMAN每天备份都出现报错, 大家帮忙看看

  2008-01-17 11:20:27   /   Oracle数据库管理

  RHEL4.410.2.0.1单机 本地磁盘每天在ALERT里都有如下报错:Thu Jan 17 01:08:45 2008Starting control autobackupThu Jan 17 01:08:46 2008Errors in file /opt/app/oracle/admin/testdb/udump/testdb_ora_22445.trc:Thu Jan 17 01:08:46 2008Errors in file /opt/app/oracle/admin/testdb/udump/testdb_ora_22445.trc:Thu Jan 17 01:08:46 2008Errors in file /opt/app/oracle/admin/testdb/udump/testdb_ora_22445.trc:Control autobackup written to DISK devicehandle '/data/rman/control_c

  查看(358) 评论(6)