"ENQUEUE_TIME AND START_TIME AHEAD OF SYSDATE" -- Bug 3060261

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 13 Mar 2004 11:36:10 +0800


I just came across this bug in a reference from Note 252686.1
OSS's Note 3060261.8 "Bug 3060261 <Queue_table>.ENQ_TIME and V$ view TIME columns may be ahead of SYSDATE"
isn't clear whether it impacts only AQ and UNDO and whether it impacts 9.2.0.2 / 9.2.0.2 RAC.


Has anyone come across this bug or the requirement to patch for this bug in 9.2.0.2 ?

I also have a few 9.2.0.4 instances. What components in 9.2.0.4 would require the patch,
other then the ORA-01555 impact ?


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 24-Jan-04}
"If you wish to leave your footprints on the sand, do not drag your feet"

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts:

  • » "ENQUEUE_TIME AND START_TIME AHEAD OF SYSDATE" -- Bug 3060261