Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: x$ tables info

RE: x$ tables info

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Fri, 4 Aug 2000 09:44:40 +0300
Message-Id: <10578.113816@fatcity.com>


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
Received on Fri Aug 04 2000 - 01:44:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US