2.370 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 23c.

See Also:

"V$SQL_HISTORY"