Send them doggies home, KD, it's a done deal.
;-)
-Original Message-
You may turn the trace on or off that way, but how do you interrogate it to
find its event settings?
- Kirti
-Original Message-
Sent: Monday, January 28, 2002 6:42 PM
To: 'Deshpande, Kirti'; [EMAIL
Here you go...
1) Find the OSPID for the suspected user (other than pmon, smon and their
famiy)
select s.username, p.spid
from v$session s, v$process p
where s.paddr = p.addr;
2) Use oradebug to connect to that spid (here I have 26073, and the session
was tracing event 10046)
SVRMGR
Nice Sleuthing, KD.
-Original Message-
Here you go...
snip.
alter session set events '10046 trace name context off'
END OF STMT
PARSE #1:c=0,e=2,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=2447763926
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=2447763927
-- Oops! The the
iteratively loop thru ORADEBUG asking sid/serial# if they
have events set, as i recall.
- Ross too lazy to rtfm to remember trick Mohan
-Original Message-
Sent: Monday, January 28, 2002 5:40 PM
To: Multiple recipients of list ORACLE-L
Hi all,
How do I find out if someone is running
From what I know, there is no way to find if a session has turned on the
tracing unless it is your own session. DBMS_SYSTEM.read_ev can you tell you
if the current session is tracing or not, but it can not interrogate other
sessions.
The only way I know is to check the trace files generated in
ORADEBUG SETORAPID, would make current session whatever you like, no?
-Original Message-
From what I know, there is no way to find if a session has turned on the
tracing unless it is your own session. DBMS_SYSTEM.read_ev can you tell you
if the current session is tracing or not, but it
You may turn the trace on or off that way, but how do you interrogate it to
find its event settings?
- Kirti
-Original Message-
Sent: Monday, January 28, 2002 6:42 PM
To: 'Deshpande, Kirti'; [EMAIL PROTECTED]
ORADEBUG SETORAPID, would make current session whatever you like, no?
Dump the session events at group
level #1 ( session level ) and parse
the second column (Evt3).
I didn't say it was elegant. :-)
Use this power only for Good, not for Evil, Luke.
- Old Bent Wand
-Original Message-
Sent: Monday, January 28, 2002 7:57 PM
To: Mohan, Ross; [EMAIL
Thanks you, Darth !!
- Luke
-Original Message-
Sent: Monday, January 28, 2002 7:35 PM
To: 'Deshpande, Kirti'; [EMAIL PROTECTED]
Dump the session events at group
level #1 ( session level ) and parse
the second column (Evt3).
I didn't say it was elegant. :-)
Use this power
LoL...yea, not a problem...happy event'ing to you!
-Original Message-
To: Mohan, Ross; [EMAIL PROTECTED]
Sent: 1/28/2002 8:55 PM
Thanks you, Darth !!
- Luke
-Original Message-
Sent: Monday, January 28, 2002 7:35 PM
To: 'Deshpande, Kirti'; [EMAIL PROTECTED]
Dump the
10 matches
Mail list logo
