Oracle Parameters You’d Love to See

Share Button

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:

  1. _allow_all_corruption = TRUE|FALSE
  2. make_cbo_work = TRUE|FALSE
  3. ignore_bad_queries = TRUE|FALSE
  4. ignore_user_list = (comma delimited list of users)
  5. auto_create_sr_on_error = TRUE|FALSE

Oh, and also two SQL*Plus commands I’d like:

  1. set alias for select = sleect
  2. set tab complete on

Any other ideas?

Share Button

10 Responses to “Oracle Parameters You’d Love to See”

  1. Delfino says:

    easy…
    run_fast = TRUE | FALSE

  2. Delfino says:

    sorry I should said
    run_fast = TRUE | FASTER

  3. thierry says:

    optimizer_mode = RULE

  4. Hazel says:

    How about

    work_correctly = first_time , with sometimes being the default. Oh, the default is how it works today. Sorry

  5. Justin says:

    How about

    do_what_i_mean = TRUE;
    do_what_i_said = FALSE;

  6. OLI says:

    set alias for from= form

  7. Andre says:

    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

  8. 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

  9. Richard Gowan says:

    replace_sysadmin=TRUE|FALSE
    oracle_support=GRADUATE|EXPERT
    oracle_support_1st_language=LOCAL|OTHER
    set_install_directories=OFA|RANDOM|ASIS

  10. Brad says:

    set alias for select = sleect

    THAT is hilarious!!!

Leave a Reply