Schema of Oracle Database (System Tables)

[Hermann Merz_1]

Hello,
is there somewhere in the Internet a description in which tables I can find which information about "System-Tables" in Oracle.
For example, I need inforamtion about max-extends, FreeSpace in tablespaces, .. .
Yes, I know, dba_tablespaces. But i am sure there are also other tables.

best regards

[MARTINACHE]

Hi,

There are a lot of site where you can find this find of informations.

I suggest you http://www.oriolecorp.com

Click "Free DBA Toolkit".

Then you will find a lot of scripts. Analyze them and you will get the infos that you need.

Regards,

Patrice.

[Volker Borowski]

Hi,

usally, you go fine by
dba_segments
dba_tables
dba_indexes

Have the full selection:
select * from dba_synonyms where synonym_name like 'DBA%';

Good hunting
Volker

[Pier Pasini]

Hi,
you can see any system table with
select table_name,comments from dict[ionary];

and

desc

see also oracle server reference manual
on otn.oracle.com

good luck

[Andreas D. Skjervold]

Hi!
The CA Data Dictionary for Oracle8i Poster is a nice artifact for your white office wall, and comes in handy remembering dictionary names and columns.
Order free hardcopy from:
http://ca.com/products/posters.htm

rgds
Andreas

[Dieter Degrendele_1]

Hi,

You can do following script:

select * from tab
where tname like 'DBA%'

Of course you still have to do a describe of the tables you are interested in.

Bye for now,
DD