James's Blog
Monday, February 13, 2006
Oracle: Oradebug - view bind value
1) get sid
select username,sid,serial#
from v$session
where audsid = userenv('sessionid');
2) oradebug setorapid 15
oradebug EVENT 10046 trace name context forever,level 12
posted by James Pei @
3:42 PM
0 Comments:
Post a Comment
<< Home
Previous Posts
Java: GC tunning
Oracle: Runtime Row Source Statistics
Oracle: 9i segment level statistics
Perl: references of array/hash/scalar
Oracle: Hit Radio
Oracle: DBWn or DB Slaves
UNIX: Sendmail
Oracle: merge tables
Oracle: fetch across commit
Oracle: Histogram-2
0 Comments:
Post a Comment
<< Home