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

12 comments

  1. How about

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

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

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

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.