| Trace PMON recovery [message #300497] |
Fri, 15 February 2008 12:29  |
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 #300505 is a reply to message #300500] |
Fri, 15 February 2008 12:46  |
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 #300507 is a reply to message #300505] |
Fri, 15 February 2008 12:50 |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
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 |
|
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 #300515 is a reply to message #300497] |
Fri, 15 February 2008 13:35 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
