Re: X$ tables in the sys account

From: <GO.MSB_at_isumvs.iastate.edu>
Date: Fri, 14 May 1993 14:33:22 GMT
Message-ID: <C70trn.KK2_at_news.iastate.edu>

In article <ayai4B1w165w_at_uidixon.uucp>, uidixon!idixon_at_infocom.co.uk (Ian Dixon) writes:
>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
>
>Thanks
>
>Ian
>
>--
>Ian Dixon Email : idixon_at_infocom.co.uk
>Reading, England

---

Try the Performance Tuning Guide (5317-V6.0 0290) pp 3-20/25

Marvin Beck Iowa State University Received on Fri May 14 1993 - 16:33:22 CEST