RE: Info needed on X_$ or V_$ !!

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

  ---

        From: oracle-l-bounce_at_freelists.org
[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.98927 

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