RE: X$Tables Info

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Mon, 11 Dec 2000 14:37:28 -0500
Message-Id: <10707.124225@fatcity.com>

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=> "    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-----
From: Mohan, Ross [mailto:MohanR_at_stars-smi.com] Sent: Monday, December 11, 2000 12:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: X$Tables Info

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-----
From: Sood, Kamal [ 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 Subject: X$Tables Info

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>  

-- 
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 

Received on Mon Dec 11 2000 - 13:37:28 CST