Skip to content
February 16, 2011 / doganay

PARAMETER VALUES (ALL PROBABILITIES)

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Hi,

you may want to use this useful Tanel Poder script to see a parameter’s probable values:


--------------------------------------------------------------------------------
--
-- File name: pvalid.sql
-- Purpose: Show valid parameter values from V$PARAMETER_VALID_VALUES
-- underlying X$ table X$KSPVLD_VALUES
--
-- Author: Tanel Poder
-- Copyright: (c) http://www.tanelpoder.com
--
-- Usage: @pvalid --
-- @pvalid optimizer
--
--------------------------------------------------------------------------------
set lines 100

COL pvalid_default HEAD DEFAULT FOR A7
COL pvalid_value HEAD VALUE FOR A30
COL pvalid_name HEAD PARAMETER FOR A50
COL pvalid_par# HEAD PAR# FOR 99999

BREAK ON pvalid_par# skip 1

SELECT
-- INST_ID,
PARNO_KSPVLD_VALUES pvalid_par#,
NAME_KSPVLD_VALUES pvalid_name,
-- ORDINAL_KSPVLD_VALUES,
VALUE_KSPVLD_VALUES pvalid_value,
DECODE(ISDEFAULT_KSPVLD_VALUES, 'FALSE', '', 'DEFAULT' ) pvalid_default
FROM
X$KSPVLD_VALUES
WHERE
LOWER(NAME_KSPVLD_VALUES) LIKE LOWER('%&1%')
ORDER BY
pvalid_par#,
pvalid_default,
pvalid_Value
/

 

 

http://www.tanelpoder.com/files/scripts/pvalid.sql

 

try and pray 🙂

Advertisements

2 Comments

Leave a Comment
  1. Himanshu Sharma / Jul 13 2011 10:41 pm

    Hi

    Is it means Oracle 10g can run rule base optimizer query ?

    • doganay / Jul 14 2011 2:12 pm

      I do not get it. How did you make that connection?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: