| NAME | ORDINAL | VALUE | ISDEFAULT |
| audit_trail | 1 | DB | |
| 2 | OS | ||
| 3 | NONE | ||
| 4 | TRUE | ||
| 5 | FALSE | ||
| 6 | DB_EXTENDED | ||
| 7 | XML | ||
| 8 | EXTENDED | ||
| background_core_dump | 1 | FULL | |
| 2 | PARTIAL | ||
| cell_offload_compaction | 1 | LOW | |
| 2 | MEDIUM | ||
| 3 | HIGH | ||
| 4 | ADAPTIVE | TRUE | |
| cell_offload_plan_display | 1 | NEVER | |
| 2 | ALWAYS | ||
| 3 | AUTO | TRUE | |
| cell_partition_large_extents | 1 | DEFAULT | TRUE |
| 2 | TRUE | ||
| 3 | ALWAYS | ||
| control_management_pack_access | 1 | NONE | |
| 2 | DIAGNOSTIC | ||
| 3 | DIAGNOSTIC+TUNING | TRUE | |
| cursor_sharing | 1 | FORCE | |
| 2 | EXACT | TRUE | |
| 3 | SIMILAR | ||
| db_block_checking | 1 | FALSE | TRUE |
| 2 | OFF | ||
| 3 | LOW | ||
| 4 | MEDIUM | ||
| 5 | TRUE | ||
| 6 | FULL | ||
| db_block_checksum | 1 | OFF | |
| 2 | FALSE | ||
| 3 | TYPICAL | TRUE | |
| 4 | TRUE | ||
| 5 | FULL | ||
| db_cache_advice | 1 | OFF | TRUE |
| 2 | READY | ||
| 3 | ON | ||
| db_lost_write_protect | 1 | NONE | TRUE |
| 2 | TYPICAL | ||
| 3 | FULL | ||
| db_securefile | 1 | NEVER | |
| 2 | PERMITTED | TRUE | |
| 3 | ALWAYS | ||
| 4 | IGNORE | ||
| 5 | FORCE | ||
| db_ultra_safe | 1 | OFF | TRUE |
| 2 | DATA_ONLY | ||
| 3 | DATA_AND_INDEX | ||
| fast_start_parallel_rollback | 1 | FALSE | |
| 2 | LOW | TRUE | |
| 3 | HIGH | ||
| filesystemio_options | 1 | ASYNCH | |
| 2 | DIRECTIO | ||
| 3 | SETALL | ||
| 4 | NONE | ||
| instance_type | 1 | RDBMS | TRUE |
| 2 | ASM | ||
| ldap_directory_access | 1 | NONE | TRUE |
| 2 | PASSWORD | ||
| 3 | SSL | ||
| ldap_directory_sysauth | 1 | YES | |
| 2 | NO | ||
| log_archive_dest_state_x | 1 | ENABLE | |
| 2 | DEFER | ||
| 3 | RESET | ||
| 4 | ALTERNATE | ||
| nls_comp | 1 | BINARY | TRUE |
| 2 | LINGUISTIC | ||
| 3 | ANSI | ||
| nls_length_semantics | 1 | BYTE | TRUE |
| 2 | CHAR | ||
| nls_nchar_conv_excp | 1 | FALSE | TRUE |
| 2 | TRUE | ||
| optimizer_features_enable | 1 | 8.0.0 | |
| 2 | 8.0.3 | ||
| 3 | 8.0.4 | ||
| 4 | 8.0.5 | ||
| 5 | 8.0.6 | ||
| 6 | 8.0.7 | ||
| 7 | 8.1.0 | ||
| 8 | 8.1.3 | ||
| 9 | 8.1.4 | ||
| 10 | 8.1.5 | ||
| 11 | 8.1.6 | ||
| 12 | 8.1.7 | ||
| 13 | 9.0.0 | ||
| 14 | 9.0.1 | ||
| 15 | 9.2.0 | ||
| 16 | 9.2.0.8 | ||
| 17 | 10.1.0 | ||
| 18 | 10.1.0.3 | ||
| 19 | 10.1.0.4 | ||
| 20 | 10.1.0.5 | ||
| 21 | 10.2.0.1 | ||
| 22 | 10.2.0.2 | ||
| 23 | 10.2.0.3 | ||
| 24 | 10.2.0.4 | ||
| 25 | 10.2.0.5 | ||
| 26 | 11.1.0.6 | ||
| 27 | 11.1.0.7 | ||
| 28 | 11.2.0.1 | TRUE | |
| 29 | 11.2.0.1.1 | ||
| optimizer_mode | 1 | RULE | |
| 2 | CHOOSE | ||
| 3 | ALL_ROWS | ||
| 4 | FIRST_ROWS | ||
| 5 | FIRST_ROWS_1 | ||
| 6 | FIRST_ROWS_10 | ||
| 7 | FIRST_ROWS_100 | ||
| 8 | FIRST_ROWS_1000 | ||
| parallel_degree_policy | 1 | MANUAL | TRUE |
| 2 | LIMITED | ||
| 3 | AUTO | ||
| plscope_settings | 1 | IDENTIFIERS:NONE | TRUE |
| 2 | IDENTIFIERS:ALL | ||
| plsql_code_type | 1 | INTERPRETED | TRUE |
| 2 | NATIVE | ||
| query_rewrite_enabled | 1 | FALSE | |
| 2 | TRUE | ||
| 3 | FORCE | ||
| query_rewrite_integrity | 1 | ENFORCED | |
| 2 | TRUSTED | ||
| 3 | STALE_TOLERATED | ||
| recyclebin | 1 | ON | |
| 2 | OFF | ||
| remote_dependencies_mode | 1 | TIMESTAMP | |
| 2 | SIGNATURE | ||
| remote_login_passwordfile | 1 | SHARED | |
| 2 | EXCLUSIVE | ||
| 3 | NONE | ||
| result_cache_mode | 1 | AUTO | |
| 2 | MANUAL | TRUE | |
| 3 | FORCE | ||
| sec_protocol_error_trace_action | 1 | NONE | |
| 2 | TRACE | TRUE | |
| 3 | LOG | ||
| 4 | ALERT | ||
| serial_reuse | 1 | DISABLE | |
| 2 | ALL | ||
| 3 | SELECT | ||
| 4 | DML | ||
| 5 | PLSQL | ||
| 6 | FORCE | ||
| shadow_core_dump | 1 | NONE | |
| 2 | FULL | ||
| 3 | PARTIAL | ||
| standby_file_management | 1 | AUTO | |
| 2 | MANUAL | TRUE | |
| star_transformation_enabled | 1 | FALSE | TRUE |
| 2 | TRUE | ||
| 3 | TEMP_DISABLE | ||
| statistics_level | 1 | BASIC | |
| 2 | TYPICAL | TRUE | |
| 3 | ALL | ||
| workarea_size_policy | 1 | MANUAL | |
| 2 | AUTO | TRUE | |
| xml_db_events | 1 | ENABLE | |
| 2 | DISABLE |