Home » RDBMS Server » Server Administration » Undo management "Flashback Version Query"
Undo management "Flashback Version Query" [message #256200] Fri, 03 August 2007 07:15 Go to next message
Messages: 26
Registered: July 2007
Location: Hyderabad
Junior Member
I 've deleted a row in the demo1 table, later committed it. Later I 've executed the following SQL Statement through Toad 8.6
Select versions_starttime,versions_endtime,versions_xid,versions_operation,sno
from demo1 versions between timestamp minvalue and maxvalue order by versions_starttime;

I've got a XID value that for that Delete transaction as 040007000C020000, immediately I've executed the following SQL statement:
Select undo_sql from flashback_transaction_query where xid='040007000C020000'

my DB default undo_retention is 900

But the responce time of the above SQL Statement is too slow(I've got the response for this after 15 minutes), the system is utilising more than 90% of CPU resources(I've seen it through my WINDOWS Task Manager, Oracle is installed on my machine on Windows OS
and no other applications are running on this machine,
this machine configuration is 1GB RAM,P IV AMD athelon(tm) 64 Processor 3200+
No body are accessing this Database & system..
Problem might be what can u please explain ..?
Re: Undo management "Flashback Version Query" [message #256213 is a reply to message #256200] Fri, 03 August 2007 07:42 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not my experience.
Works fine for me.
Maybe something in your environment.

Previous Topic: Grant Role/Grant Privilege
Next Topic: ORA-00305
Goto Forum:

Current Time: Mon Aug 21 01:33:22 CDT 2017

Total time taken to generate the page: 0.01035 seconds