Re: GV$ Views

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Thu, 12 Apr 2007 09:35:04 +1100
Message-ID: <49d668000704111535w5e101bb8gf791c4b2888cb8d2@mail.gmail.com>

No,

it's not a union all.

Generally v$ is a gv$ with an added predicate "where inst_id = USERENV('Instance')"

See v$fixed_view_definition for details.

On 4/12/07, Ethan Post <post.ethan_at_gmail.com> wrote:
> Is it a safe assumption (in every case) to assume that every GV$ view is
> just a union all of the underlying V$ views?
>

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 11 2007 - 17:35:04 CDT