Thank you very much Roberttahiti.oracle.com was really useful
site..had every information in it..
santosh
-Original Message-
Freeman
Sent: Sunday, January 19, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L
All of these views are pretty well documented in the Oracle9i
All of these views are pretty well documented in the Oracle9i docs too. The
doc's of the v$ tables is much better these days (but still isn't perfect).
Check out tahiti.oracle.com.
Robert
-Original Message-
Kirti
Sent: Friday, January 17, 2003 11:40 AM
To: Multiple recipients of list
For V$Views definitions have a look at catalog.sql, which has some
information. I understand by D$tables, you mean the dictionary tables.
If that is the case, the sql.bsq (under the $ORACLE_HOME/rdbms/admin)
will be of use.
KG
=
Have a nice day !!
Thank you very much.
santosh
-Original Message-
Gopalakrishnan
Sent: Friday, January 17, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
For V$Views definitions have a look at catalog.sql, which has some
information. I understand by D$tables, you mean the dictionary tables.
If
Do you have 'EXECUTE CATALOG' previllege ?
1. Views
OWNER NOT NULL VARCHAR2(30)
VIEW_NAME NOT NULL VARCHAR2(30)
TEXT_LENGTH NUMBER
TEXT LONG
TYPE_TEXT_LENGTH
http://tahiti.oracle.com
Look
in Database Reference Guide.
Or if
you have Rich Niemiec's book (Performance Tuning Tips Techniques... etc..)
there are a number of pagesshowing the output from 'describe' ofmany
of suchviews.
-
Kirti
-Original Message-From: Santosh Varma
/start of plug
so does Oracle9i DBA 101 and it explains them too
/end of plug
I'm so ashamed, it won't happen again
--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
http://tahiti.oracle.com
Look in Database Reference Guide.
Or if you have Rich Niemiec's book (Performance Tuning Tips
Not a problem...
I have not bought your book yet... :(
And I *would* expect more useful information in your book, than just 'describes' ;)
- Kirti
-Original Message-
Sent: Friday, January 17, 2003 10:11 AM
To: Multiple recipients of list ORACLE-L
/start of plug
so does Oracle9i