I am not too familiar with how to audit sessions running my DB. Should I be concerned about OLD sessions? Or sessions that I do not know what they are doing? Any advice is appreciated. The following is an example. It's been running thru sqlplus on the server side since 11/03/2000 (sorry for how it looks on this forum):
SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND OWNERID TADDR LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME OSUSER PROCESS MACHINE TERMINAL PROGRAM TYPE SQL_ADDR SQL_HASH_VALUE PREV_SQL PREV_HASH_VALUE MODULE MODULE_HASH ACTION ACTION_HASH CLIENT_INFO FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI
-------- --------- --------- --------- -------- --------- ------------------------------ --------- --------- -------- -------- -------- --------- --------- ------------------------------ --------------- --------- ---------------------------------------------------------------- ---------- ------------------------------------------------ ---------- -------- -------------- -------- --------------- ------------------------------------------------ ----------- -------------------------------- ----------- ---------------------------------------------------------------- -------------------- ------------- -------------- --------------- ------------- --------- ------------ --- ------------- ---------- ---
82599C78 19 653 167668 8258284C 5 SYSTEM 0 2.147E+09 INACTIVE DEDICATED 5 SYSTEM oracle 10584 shamrock pts/15 sqlplus@shamrock (TNS V1-V3) USER 8348B404 3.760E+09 8348B404 3.760E+09 SQL*Plus 3.670E+09 4.030E+09 32295 -1 0 0 0 03-NOV-00 3704674 NO NONE NONE NO
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks