Monthly Archives: June 2014

unaccounted time in v$sql elapsed_time >> cpu_time + user_io_wait_time + concurrency_wait_time + etc

Regarding unaccounted time in v$sql, when elapsed_time is much bigger than cpu_time + user_io_wait_time + concurrency_wait_time + etc. One reason: Log writer waits are not included into user_io_wait_time – it is truly a USER io time. Test it: Stop log … Continue reading

Posted in Uncategorized | Leave a comment

Recovery, incomplete, consistency, datafile headers, checking, minimum SCN

x$kcvfh is a good one: How to quickly check that Database is consistent after incomplete recovery (Point in Time Recovery) before OPEN RESETLOGS (Doc ID 1354256.1) select hxfil file#, substr(hxfnm, 1, 50) name, fhscn checkpoint_change#, fhafs Absolute_Fuzzy_SCN, max(fhafs) over () … Continue reading

Posted in Uncategorized | Leave a comment