Re: v$parameter ... where is it really defined?

You can find the definition of the view in v$fixed_view_definition.

The obvious query will let you know that v$parameter is a view on gv$parameter, which is itself a view. Do the query with gv$parameter and you will see that this view is derived from x$ksppi and x$ksppcv. At least for 8.1.7.

Frank Hubeny

Steve Salvemini wrote:

> I've noticed if I do an 'alter session set optimizer_mode = rule' in my
> sql session, the select stmt:
>
> SELECT NAME, VALUE
> FROM V$PARAMETER
> WHERE NAME = 'optimizer_mode';
>
> will return RULE (instead of the database setting of CHOOSE). This is
> only for my session, so the v$paramter view seems to be reasonably
> clever.
>
> So, I see that v$parameter actually is a synonym that points to the view
> V$_PARAMETER.
> The view however selects a few columns from v$parameter.
>
> I started to get confused at this point. Where is the real view defined,
> ie. how is it doing the session specific query as above for the
> optimiser mode.
>
> I suspect it is using PARAMATER$ as weel as some of its mates...
>
> Thanks folks.
  Received on Tue Apr 03 2001 - 02:19:42 CDT