Home » RDBMS Server » Server Administration » Trace PMON recovery
Trace PMON recovery [message #300497] Fri, 15 February 2008 12:29 Go to next message
kazdba
Messages: 10
Registered: February 2008
Junior Member
Can we set an event to trace pmon for,

1)dump last activity when ever a client/user closes abnormally and pmon have to do cleanup.

2)Dump rollback/undo information when ever pmon has to rollback transactions as the client/user lost connect with out issuing a commit or rollback.

I tried the following events but none of them give the information I am looking for....
#Event 10246 to Trace PMON Process
#Event 10012 to Monitor Abort Transaction
#Event 10013 to Monitor Transaction Recovery
#Event 10015 to Dump Undo Segment Headers

regards,
Kaz
Re: Trace PMON recovery [message #300500 is a reply to message #300497] Fri, 15 February 2008 12:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
none of them give the information I am looking for....

What are you looking for?

Regards
Michel
Re: Trace PMON recovery [message #300505 is a reply to message #300500] Fri, 15 February 2008 12:46 Go to previous messageGo to next message
kazdba
Messages: 10
Registered: February 2008
Junior Member
I am looking for the last statement executed (or transaction recovery by pmon if any) by a user when the client application (not the server session) crashed.

thx.
Re: Trace PMON recovery [message #300506 is a reply to message #300497] Fri, 15 February 2008 12:49 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Wouldn't alert log give you what last activity was performed on the server?
Re: Trace PMON recovery [message #300507 is a reply to message #300505] Fri, 15 February 2008 12:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The statement/transaction is nowhere. You can't have this information.
PMON does not need to know the statement to rollback it.
By the way, PMON does not rollback a statement but a transaction.

Regards
Michel

[Updated on: Fri, 15 February 2008 12:51]

Report message to a moderator

Re: Trace PMON recovery [message #300510 is a reply to message #300507] Fri, 15 February 2008 12:59 Go to previous messageGo to next message
kazdba
Messages: 10
Registered: February 2008
Junior Member
Michel,

I understand PMON does not rollback a statement but a transaction. I might not have put it the right way.

So its not possible to dump the last activity of a user when the client application crashes or the connection closes abnormally.

thx.
Re: Trace PMON recovery [message #300511 is a reply to message #300510] Fri, 15 February 2008 13:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
So its not possible to dump the last activity of a user when the client application crashes or the connection closes abnormally.

You can know it mining the logs but not with PMON activity.
Of course you can know nothing about select statements.

Regards
Michel

[Updated on: Fri, 15 February 2008 13:03]

Report message to a moderator

Re: Trace PMON recovery [message #300512 is a reply to message #300511] Fri, 15 February 2008 13:07 Go to previous messageGo to next message
kazdba
Messages: 10
Registered: February 2008
Junior Member
I don't think mining the logs indicate whether rollback was done due to a client crash?
Re: Trace PMON recovery [message #300513 is a reply to message #300512] Fri, 15 February 2008 13:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, but it gives the last statement/transaction of your sessions.

Regards
Michel
Re: Trace PMON recovery [message #300515 is a reply to message #300497] Fri, 15 February 2008 13:35 Go to previous messageGo to next message
kazdba
Messages: 10
Registered: February 2008
Junior Member
Sometimes we have app server crashes, and I just wanted to know what was the last activity by that session, so it seems we can't get that information.

thx.



Re: Trace PMON recovery [message #300516 is a reply to message #300515] Fri, 15 February 2008 13:40 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you know session id or transaction id, you can mine the logs.

Regards
Michel
Previous Topic: Installing oracle automatic
Next Topic: Dynamic service registration
Goto Forum:
  


Current Time: Sun Dec 04 00:26:17 CST 2016

Total time taken to generate the page: 0.04006 seconds