Sundaramurthy Blog

February 2, 2010

Underscore parameter

Filed under: Oracle internals,Parameters — sundar5 @ 3:40 pm
LMD process checks every 60 seconds fron any resource dead lock.
1  select m.ksppinm , y.ksppstvl from   x$ksppi  m , x$ksppcv y where  m.indx = y.indx and    m.ksppinm like '%lm_dd%'
2* order  by m.ksppinm
SQL> /
KSPPINM                        KSPPSTVL
------------------------------ ----------------------------------------
_lm_dd_interval                60
_lm_dd_scan_interval           5

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Blog at

%d bloggers like this: