SQL_HISTORY_ENABLED

2.378 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 Database 23ai.