Home » RDBMS Server » Server Administration » Is my database still rolling back?
Is my database still rolling back? [message #187174] Fri, 11 August 2006 03:54 Go to next message
hansgruijs
Messages: 10
Registered: March 2006
Location: The Netherlands (Amsterda...
Junior Member
Hello,

I killed a session which was running for hours, and now I don't know if the rollback action has finished. How can I monitor if the database is still performing rollback action?

In general: Is there a usefull query which shows me the activity of the database?

Regards, Hans
Re: Is my database still rolling back? [message #187215 is a reply to message #187174] Fri, 11 August 2006 06:00 Go to previous messageGo to next message
chandanbhamra
Messages: 84
Registered: April 2005
Location: India
Member
use this query to see how many blocks are rolled back

select used_ublk from v$transaction

Hope this helps you.
Re: Is my database still rolling back? [message #187218 is a reply to message #187215] Fri, 11 August 2006 06:11 Go to previous message
hansgruijs
Messages: 10
Registered: March 2006
Location: The Netherlands (Amsterda...
Junior Member
Thanks for your reply. It helps.
regards, Hans
Previous Topic: Issue with m_bReaderStarted upgrading 8.1.7.4.1 to Oracle 10g R2 version on Windows 2003
Next Topic: ORA-02042: too many distributed transactions
Goto Forum:
  


Current Time: Mon Dec 05 13:08:06 CST 2016

Total time taken to generate the page: 0.14456 seconds