X$ tables in the sys account

From: Ian Dixon <uidixon!idixon_at_infocom.co.uk>
Date: 13 May 93 21:02:09 GMT
Message-ID: <ayai4B1w165w_at_uidixon.uucp>

Can anybody tell me more about the various X$ tables (or are they views?) in the sys account?

I've heard them mentioned in the past and found a refernce today in an Oracle Technical Bulletin. Running a select on the table mentioned gave me a bad shock because it told me that I could have 30 database files maximum and I've currently got 27.

Is there a list of these tables anywhere?

Any help appreciated

--
Ian Dixon                       Email : idixon_at_infocom.co.uk
Reading, England

Received on Thu May 13 1993 - 23:02:09 CEST

This message: [ Message body ]
Next message: Patrick Jones: "GUI with ProC"
Previous message: Andy Paradis: "decent database tuning books?"
Next in thread: GO.MSB_at_isumvs.iastate.edu: "Re: X$ tables in the sys account"
Reply: GO.MSB_at_isumvs.iastate.edu: "Re: X$ tables in the sys account"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message