Archive for May, 2007



Oracle Parameters You’d Love to See

Tuesday, May 1st, 2007

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?