Parameter session value instance value description
_sqlmon_binds_xml_format default default format of column binds_xml in [G]V$SQL_MONITOR
_sqlmon_max_plan 80 80 Maximum number of plans entry that can be monitored. Defaults to 20 per CPU
_sqlmon_max_planlines 300 300 Number of plan lines beyond which a plan cannot be monitored
_sqlmon_recycle_time 60 60 Minimum time (in s) to wait before a plan entry can be recycled
_sqlmon_threshold 5 5 CPU/IO time threshold before a statement is monitored. 0 is disabled