RE: x$ tables info

Bhat,

You can get information about X$ tables from V$FIXED_TABLE view.

HTH, Sandeep.

	-----Original Message-----
	From:	LBhat_at_LEVI.com [SMTP:LBhat_at_LEVI.com]
	Sent:	Tuesday, August 01, 2000 11:17 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	x$ tables info

	Where can I get detailed info about x$ tables?

	Regards,
	Bhat

	-----Original Message-----
	Sent: Tuesday, August 01, 2000 4:44 AM
	To: Multiple recipients of list ORACLE-L


	Hi Stephane,

	It shows buffer busy waits on buffers containing blocks from those
	datafiles.
	Make sure that your script offsets the file number by one when doing
the
	join to V$DATAFILE.
	Have a look at my buffer_busy_waits.sql script for an example.
	Also, for buffer busy waits against rollback segment header blocks,
	my enough_rollback_segments.sql script makes a helpful distinction
	between read waits and write waits
	that might help you to work out what's going on there.

	You may want to post the output of both scripts back to the list?

	Regards,
	Steve Adams
	http://www.ixora.com.au/
	http://www.oreilly.com/catalog/orinternals/
	http://www.christianity.net.au/


	-----Original Message-----
	stephane
	Sent: Tuesday, 1 August 2000 4:00
	To: Multiple recipients of list ORACLE-L


	Hi,

	I'm trying to understand x$kcbfwait.
	I can't find a reference of this table in any V$
	views.

	I have a script that linked x$kcbfwait to v$datafile.
	It seems to show waits on datafiles but I do not quite
	understand what's going on. The datafiles having the
	more waits are the ones containing the rollback
	segments.



	=====
	Stephane Paquette
	DBA Oracle
	stephane_paquette_at_yahoo.com
	spaquette_at_houra.fr


	(33) 01 53 93 06 50


	__________________________________________________
	Do You Yahoo!?
	Kick off your party with Yahoo! Invites.
	http://invites.yahoo.com/
	--
	Author: =?iso-8859-1?q?paquette=20stephane?=
	  INET: stephane_paquette_at_yahoo.com

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L


	(or the name of mailing list you want to be removed from).  You may

	also send the HELP command for other information (like subscribing).

	-- 
	Author: Steve Adams
	  INET: steve.adams_at_ixora.com.au

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L


	(or the name of mailing list you want to be removed from).  You may

	also send the HELP command for other information (like subscribing).
	-- 
	Author: 
	  INET: LBhat_at_LEVI.com

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L


	(or the name of mailing list you want to be removed from).  You may