Re: GV$ Views
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: post.ethan@xxxxxxxxx
- Date: Thu, 12 Apr 2007 09:35:04 +1100
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
