OraFAQ Forum: Server Administration » How To Know If Oracle Is RollBacking

Home » RDBMS Server » Server Administration » How To Know If Oracle Is RollBacking

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

How To Know If Oracle Is RollBacking [message #136141]

Tue, 06 September 2005 06:27

felipevinturini
Messages: 10
Registered: August 2005
Location: Brazil

Junior Member

Hi All,

Do I have to know in the database, in a select in some table, if oracle is rollbacking?

Thanks for your help.

Felipe.

Report message to a moderator

Re: How To Know If Oracle Is RollBacking [message #136153 is a reply to message #136141]

Tue, 06 September 2005 07:23

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

You can query v$session_longops.
Check for the following.

OPNAME
SOFAR
TOTALWORK
START_TIME
LAST_UPDATE_TIME
TIME_REMAINING
ELAPSED_SECONDS

This might help.

Regds
Girish

Report message to a moderator

Re: How To Know If Oracle Is RollBacking [message #136158 is a reply to message #136153]

Tue, 06 September 2005 07:49

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

For obtaining sid,serial# for sessions carrying out rollback

query v$session & check for command=45.

Regds
Girish

Report message to a moderator

Previous Topic:	Maybe it's not an oracle question.
Next Topic:	DBMS_JOB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 10:42:04 CST 2025