Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)

mercredi 1 juillet 2020

Real-Time SQL Monitoring : settings

 The Real-Time SQL Monitoring feature of Oracle Database enables monitoring the performance of SQL statements while they are executing. By default, SQL monitoring is automatically started when a SQL statement either runs in parallel or has consumed at least 5 seconds of combined CPU and I/O time in a single execution. 

select ksppinm, ksppstvl, ksppdesc   from sys.x$ksppi a, sys.x$ksppsv b where a.indx=b.indx and lower(ksppinm) like lower('%sqlmon%')  order by ksppinm;


KSPPINM                   KSPPSTVL  KSPPDESC

------------------------- --------- --------------------------------------------------------------------------------

_sqlmon_binds_xml_format  default   format of column binds_xml in [G]V$SQL_MONITOR

_sqlmon_max_plan          640       Maximum number of plans entry that can be monitored. Defaults to 20 per CPU

_sqlmon_max_planlines     300       Number of plan lines beyond which a plan cannot be monitored

_sqlmon_recycle_time      60        Minimum time (in s) to wait before a plan entry can be recycled

_sqlmon_threshold         5         CPU/IO time threshold before a statement is monitored. 0 is disabled

Aucun commentaire:

Enregistrer un commentaire