| Undo management "Flashback Version Query" [message #256200] |
Fri, 03 August 2007 07:15  |
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 ..?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
