Oracle Parameters You’d Love to See
May 1st, 2007 by The Oracle AlchemistHave 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?
May 1st, 2007 at 11:34 am
easy…
run_fast = TRUE | FALSE
May 1st, 2007 at 11:35 am
sorry I should said
run_fast = TRUE | FASTER
May 1st, 2007 at 12:06 pm
optimizer_mode = RULE
May 2nd, 2007 at 8:13 am
How about
work_correctly = first_time , with sometimes being the default. Oh, the default is how it works today. Sorry
May 3rd, 2007 at 1:19 am
How about
do_what_i_mean = TRUE;
do_what_i_said = FALSE;
May 3rd, 2007 at 1:46 pm
set alias for from= form
May 4th, 2007 at 1:39 pm
[...] Karam, the Oracle Alchemist has his wishlist of Oracle parameters you’d love to see, e.g.: make_cbo_work = [...]
May 4th, 2007 at 5:48 pm
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
May 7th, 2007 at 3:39 pm
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
May 17th, 2008 at 3:41 am
replace_sysadmin=TRUE|FALSE
oracle_support=GRADUATE|EXPERT
oracle_support_1st_language=LOCAL|OTHER
set_install_directories=OFA|RANDOM|ASIS
May 29th, 2008 at 12:07 pm
set alias for select = sleect
THAT is hilarious!!!