Oracle database initialization parameters
For optimal performance with Client Management , the following Oracle database initialization parameters are recommended.
Parameter | Value |
|---|---|
filesystemio_options | SETALL |
query_rewrite_enabled | FALSE |
optimizer_mode | CHOOSE |
optimizer_features_enable | 9.2.0 |
cursor_sharing | FORCE |
open_cursors | 800 |
session_cached_cursors | 5000 |
compatible | 11.2.0 |
commit_logging | BATCH |
commit_wait | NOWAIT |
optimizer_index_cost_adj | 20 |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*