OraFAQ Forum: Server Administration » Is my database still rolling back?

Home » RDBMS Server » Server Administration » Is my database still rolling back?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is my database still rolling back? [message #187174]

Fri, 11 August 2006 03:54

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

Report message to a moderator

Re: Is my database still rolling back? [message #187215 is a reply to message #187174]

Fri, 11 August 2006 06:00

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.

Report message to a moderator

Re: Is my database still rolling back? [message #187218 is a reply to message #187215]

Fri, 11 August 2006 06:11

hansgruijs
Messages: 10
Registered: March 2006
Location: The Netherlands (Amsterda...

Junior Member

Thanks for your reply. It helps.
regards, Hans

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:40:36 CDT 2024