Usual select generates a lot of wait events. In Enterprise Manager it looks like:
System I/O control file sequential read file# 0 block# 18 blocks 1 0
System I/O control file sequential read file# 0 block# 16 blocks 1 0
System I/O control file sequential read file# 3 block# 1 blocks 1 0
System I/O control file sequential read file# 2 block# 1 blocks 1 0
System I/O control file sequential read file# 1 block# 1 blocks 1 0
System I/O control file sequential read file# 0 block# 1 blocks 1 0
System I/O control file sequential read file# 0 block# 18 blocks 1 10
System I/O control file sequential read file# 0 block# 16 blocks 1 0
System I/O control file sequential read file# 3 block# 1 blocks 1 0
System I/O control file sequential read file# 2 block# 1 blocks 1 0
Following Metalink:
Showing posts with label bug. Show all posts
Showing posts with label bug. Show all posts
Wednesday, September 29, 2010
Tuesday, September 28, 2010
It takes a long time to query v$log_history in rman session
In rman session hangs for a long time while executing:
SELECT recid, stamp, thread#, sequence#, first_change# low_scn,
first_time low_time, next_change# next_scn, resetlogs_change#,
resetlogs_time
FROM v$log_history
WHERE recid BETWEEN :b1 AND :b2
AND resetlogs_time IS NOT NULL
AND stamp >= :b3
ORDER BY recid
It occurred at full resync time. It suppose to be another appearance of BUG:5620640 - LONG WAIT ON OPEN DB RESETLOGS WHEN USING FLASHBACK DB GUARANTEED RECOVERY POINT
SELECT recid, stamp, thread#, sequence#, first_change# low_scn,
first_time low_time, next_change# next_scn, resetlogs_change#,
resetlogs_time
FROM v$log_history
WHERE recid BETWEEN :b1 AND :b2
AND resetlogs_time IS NOT NULL
AND stamp >= :b3
ORDER BY recid
It occurred at full resync time. It suppose to be another appearance of BUG:5620640 - LONG WAIT ON OPEN DB RESETLOGS WHEN USING FLASHBACK DB GUARANTEED RECOVERY POINT
Subscribe to:
Posts (Atom)