SQL_HISTORY_ENABLED

Use SQL_HISTORY_ENABLED to enable or disable SQL history monitoring.

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB	Yes
Range of values	true | false
Basic	No
Oracle RAC	Different instances can use different values.

To enable SQL history monitoring, set this parameter to true. This feature monitors user-issued SQL statements in each user session on a best effort, depending on memory capacity. DDL, DML, and query statements are monitored; SQL statements issued in the background and recursive SQL statements are excluded. The monitored information is exposed by the V$SQL_HISTORY dynamic performance view.

To disable SQL history monitoring, set this parameter to false.

Note: This parameter is available starting with Oracle AI Database 26ai.

See Also: “V$SQL_HISTORY”