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: Norwood Bradly A <Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV>
Date: Tue, 1 Aug 2000 11:18:29 -0400
Message-Id: <10576.113487@fatcity.com>


Definitely, but JL is not very current, while Steve has an excellent free newsletter
in addition to an awesome collection of scripts, tips and Q&A's.

If anybody on the planet understands the depths of Oracle better than Steve, I have not yet run across his works.

-----Original Message-----
From: Vidya Kalyanaraman [mailto:kvidya13_at_hotmail.com] Sent: Tuesday, August 01, 2000 8:55 AM
To: Multiple recipients of list ORACLE-L Subject: Re: x$ tables info

You can refer to either of these three... IMHO, these are the best...

1. Jonathan Lewis's site... http://www.jlcomp.demon.co.uk
2. Steve Adams's site -      http://www.ixora.com.au
3. Oracle 8i Internal Services - Steve Adams

Thanks
Vidya

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Mon, 31 Jul 2000 21:46:31 -0800

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
also send the HELP command for other information (like subscribing). ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Author: Vidya Kalyanaraman INET: kvidya13_at_hotmail.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 Tue Aug 01 2000 - 10:18:29 CDT

Original text of this message

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