Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to find the killed session and machine name

606331May 10 2011 — edited Mar 26 2013
Hi,

At the time of batch job running .somebody killed that session .let me know how to find out the particular user name db level or oslevel .from which machine they killed how to find out at OS level . but when i have set the audit_trail=os only SYSDBA user activities are audited not the other user activities.

The server is AIX and db version 11i .provide the query for finding or os level .

thanks,
DBC.

Edited by: dbc001 on Mar 26, 2013 9:48 PM
This post has been answered by KR10822864 on Mar 26 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2013
Added on May 10 2011
9 comments
7,916 views