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
dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad
Junior Member
Hi..,
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: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not my experience.
Works fine for me.
Maybe something in your environment.

Regards
Michel
Previous Topic: Incorrect results with LogMiner??
Next Topic: "GRANT CONNECT" only possible as SYSDBA
Goto Forum:
  


Current Time: Sun Dec 04 04:53:03 CST 2016

Total time taken to generate the page: 0.05054 seconds