Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Schema of Oracle Database (System Tables)

Schema of Oracle Database (System Tables)

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
Update the world
5 REPLIES
MARTINACHE
Respected Contributor

Re: Schema of Oracle Database (System Tables)

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.
Patrice MARTINACHE
Volker Borowski
Honored Contributor

Re: Schema of Oracle Database (System Tables)

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

Re: Schema of Oracle Database (System Tables)

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

Re: Schema of Oracle Database (System Tables)

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Dieter Degrendele_1
Frequent Advisor

Re: Schema of Oracle Database (System Tables)

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
The possible we did, the unpossible we're doing but for a miracle you have to wait some time.