Have you ever just WISHED that a parameter existed in Oracle? I know I have, and old coworkers of mine have long joked about the need for things like the “fix_database.sh” script.
So I ask you, what parameters would you just LOVE to see show up by Oracle 20rr (Really Robust)? I’ll start:
- _allow_all_corruption = TRUE|FALSE
- make_cbo_work = TRUE|FALSE
- ignore_bad_queries = TRUE|FALSE
- ignore_user_list = (comma delimited list of users)
- auto_create_sr_on_error = TRUE|FALSE
Oh, and also two SQL*Plus commands I’d like:
- set alias for select = sleect
- set tab complete on
Any other ideas?
easy…
run_fast = TRUE | FALSE
sorry I should said
run_fast = TRUE | FASTER
optimizer_mode = RULE
How about
work_correctly = first_time , with sometimes being the default. Oh, the default is how it works today. Sorry
How about
do_what_i_mean = TRUE;
do_what_i_said = FALSE;
set alias for from= form
cursor_sharing=disallow_statements_that_should_have_used_bind_variables
exceptions=disallow_when_others_then_null | disallow_when_others_without_raise
stupid_query_detection=off | normal | aggressive | facist
Here are some Oracle parameters that would be interesting to see:
tune_database=TRUE;
tune_application=TRUE;
tune_sql=TRUE;
fix_instance=TRUE;
fix_panic
create_datawarehouse
create_OLAP_cube
replace_sysadmin=TRUE|FALSE
oracle_support=GRADUATE|EXPERT
oracle_support_1st_language=LOCAL|OTHER
set_install_directories=OFA|RANDOM|ASIS
set alias for select = sleect
THAT is hilarious!!!