1.257 OPTIMIZER_REAL_TIME_STATISTICS
OPTIMIZER_REAL_TIME_STATISTICS controls whether the database automatically gathers real-time statistics during conventional DML operations.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
Different values can be set on different instances. |
When this parameter is set to true, the database automatically gathers real-time statistics during conventional DML operations. The default setting is false, which means real-time statistics are disabled.
Note:
This parameter is available starting with Oracle Database 19c, Release Update 19.10.