RE: X$Tables Info

Duck, hell.....

Alex,

That is an offensive, bigoted and inaccurate statement and totally uncalled for. How DARE you generalize in such a fashion?

EVERYONE asks questions. Do you really think all the DBAs here know the exact layout and composition of all of the X$ tables? Does the fact that I don't mean that I am incompetent? That I should be charged every time I ask a question?

I know how Oracle works. I know how to read the documentation.... and the documentation is less than helpful on the X$ tables.

This person asked a question hoping to learn. Maybe next time you have a question we should charge you?

Rachel

>From: Yosi_at_comhill.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: X$Tables Info
>Date: Mon, 11 Dec 2000 13:42:04 -0800
>
>Whoa! Everybody duck!
>
>-----Original Message-----
>Sent: Monday, December 11, 2000 3:03 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>I think we need to charge people (maybe $1) for such questions. Jared
>wouldn't have to work anymore because India is a very big country and
>produce tremendous number of people who work with Oracle not knowing
>anything about it and also cannot or do not want to read books and docs.
>
>Alex
>
>-----Original Message-----
>Sent: Monday, December 11, 2000 2:36 PM
>To: Multiple recipients of list ORACLE-L
>
>
>The next script may a good way of obtaining help from Steve. Please note
>that it
>is untested. It is however an open source, public domain script which can
>be
>
>modified as
>desired.
>
>#!/bin/ksh
> set -a
> EMAIL="questions_at_ixora.com.au < mailto:EMAIL= <mailto:EMAIL=> > "
> SUBJ="Help
>ME!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!"
> FILE="$ORACLE_HOME/oradata/system.dbf "
> echo "Please help me, will you, will you, will you?">/tmp/help
> let no_emails=1000000;
> let i=0;
> while [ i -lt no_emails ];
> do
> mail -s "$SUBJ" $EMAIL </tmp/help
> uuencode $FILE $FILE|mail -s "Here is my data dictionary" $EMAIL;
> let i=$i+1;
> done;
>
>This will work fine, especially if you have system.dbf > 500M.
>
>-----Original Message-----
>Sent: Monday, December 11, 2000 12:51 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Buy Steve Adams book from O'Reilly.
>
><kidon>
>
>Then, don't read it, and ask him a bunch of questions.
>
>Steve loves that and will respond online if you ping him
>enough.
>
><kidoff>
>
>-----Original Message-----
>< mailto:Kamal.Sood_at_gbr.xerox.com <mailto:Kamal.Sood_at_gbr.xerox.com> > ]
>Sent: Monday, December 11, 2000 11:36 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Gurus
>
>Can anybody please tell, from where I can get the X$tables information (not
>the DDL) like what is the purpose of the table and description of columns
>and when/how they get updated ?
>
>Thanks & regards,
>
>Kamal Sood
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
><http://www.orafaq.com>
>< http://www.orafaq.com <http://www.orafaq.com> >
>--
>Author: Sood, Kamal
> INET: Kamal.Sood_at_gbr.xerox.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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
><http://www.orafaq.com>
>--
>Author: Gogala, Mladen
> INET: MGogala_at_oxhp.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).
>