RE: Info needed on X_$ or V_$ !!
Date: Wed, 23 Apr 2008 11:07:16 -0400
The v$ views are documented in the Oracle version# Reference Manual.
Dion told you how to see the view definitions.
The x$ views are actually program logic structures contained in the shared memory of the instance, that is, the SGA.
You can argue over if it is better to query the v$ view or the x$ view the v$ view is built on but I find the v$ view names are usually easier to understand.
- Mark D Powell --
Phone (313) 592-5148
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ???
Sent: Tuesday, April 22, 2008 8:05 PM To: in.amitverma_at_gmail.com Cc: oracle-l Subject: Re: Info needed on X_$ or V_$ !! v$fixed_view_definition would be a good start point. Also check gv$ views which expose global-version of v$views. Dion Cho 2008/4/23, Amit Verma <in.amitverma_at_gmail.com>: Dear All, http://forums.oracle.com/forums/forum.jspa?forumID=61 1. Where we can use X_$ or V_$. 2. Is X_$ and V_$ contains the same data/info. If the info is not same, then at which the info is presented. 3. Is both X_$ and V_$ are views Please let me know your concerns. Thanks, Amit Verma Oracle DBA & System Adminstrator E-Mail:- in.amitverma_at_gmail.com, v.amit_at_hotmail.com WebSite:- http://www.linkedin.com/in/vamit IM:- verma.labs_at_gmail.com Mobile:- (+91) 98910.98927Received on Wed Apr 23 2008 - 10:07:16 CDT