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
Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: