Re: Where can I get detail description about system table ?

Randall Roberts wrote:

> Also, the "Oracle 8i Reference" has over 120 pages on v$ (dynamic
> performance) views.
>
> You can download .pdf versions of both documents from technet.oracle.com (no
> www).
>
> Randall
>
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> news:tgauqo35jer947_at_beta-news.demon.nl...
> >
> > "ALex_1998" <mingx_98_at_yahoo.com> wrote in message
> > news:4b149eee.0105181115.4808bf05_at_posting.google.com...
> > > Thanks,
> > > I don't know is three any doucument ,
> > > have detail description for all import system table,
> > > such v$sysstat,
> > > what is exact meaning of 'db block gets','consistent gets' etc,
> > >
> > > in Oracle admin guide, I can't get this ,
> > >
> > >
> > > Thanks
> >
> > Check out the Oracle Performance Tuning Manual.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> >
> >

The best documentation I have found on the data dictionary can be found by browsing the following files.

SQL. BSQ
CATALOG.SQL
CATPROC.SQL
CATEXP.SQL
PUPBLD.SQL And if you still have any questions, there are plenty more files in RDBMS/ADMIN for your reading pleasure.

Daniel A. Morgan Received on Sun May 20 2001 - 23:57:42 CDT