RE: v$Views and d$Tables
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 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 ORACLE-L 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 so does Oracle9i DBA 101 and it explains them too 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 & > Techniques... etc..) there are a number of pages showing the output > from 'describe' of many of such views. > > - Kirti > > -Original Message- > Sent: Friday, January 17, 2003 1:14 AM > To: Multiple recipients of list ORACLE-L > > > Hello all, > > Could anyone of you give me a list of v$views and d$tables and > their description... ? > I am not able to log-in to dba ...i don't have access to it... > or any links/documents where i can find them.. > > Thanks and Regards, > Santosh > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Freeman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: v$Views and d$Tables
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 ORACLE-L 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 so does Oracle9i DBA 101 and it explains them too 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 & > Techniques... etc..) there are a number of pages showing the output > from 'describe' of many of such views. > > - Kirti > > -Original Message- > Sent: Friday, January 17, 2003 1:14 AM > To: Multiple recipients of list ORACLE-L > > > Hello all, > > Could anyone of you give me a list of v$views and d$tables and > their description... ? > I am not able to log-in to dba ...i don't have access to it... > or any links/documents where i can find them.. > > Thanks and Regards, > Santosh > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Freeman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: v$Views and d$Tables
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 so does Oracle9i DBA 101 and it explains them too 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 & > Techniques... etc..) there are a number of pages showing the output > from 'describe' of many of such views. > > - Kirti > > -Original Message- > Sent: Friday, January 17, 2003 1:14 AM > To: Multiple recipients of list ORACLE-L > > > Hello all, > > Could anyone of you give me a list of v$views and d$tables and > their description... ? > I am not able to log-in to dba ...i don't have access to it... > or any links/documents where i can find them.. > > Thanks and Regards, > Santosh > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: v$Views and d$Tables
so does Oracle9i DBA 101 and it explains them too 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 & > Techniques... etc..) there are a number of pages showing the output > from 'describe' of many of such views. > > - Kirti > > -Original Message- > Sent: Friday, January 17, 2003 1:14 AM > To: Multiple recipients of list ORACLE-L > > > Hello all, > > Could anyone of you give me a list of v$views and d$tables and > their description... ? > I am not able to log-in to dba ...i don't have access to it... > or any links/documents where i can find them.. > > Thanks and Regards, > Santosh > > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: v$Views and d$Tables
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 pages showing the output from 'describe' of many of such views. - Kirti -Original Message-From: Santosh Varma [mailto:[EMAIL PROTECTED]]Sent: Friday, January 17, 2003 1:14 AMTo: Multiple recipients of list ORACLE-LSubject: v$Views and d$Tables Hello all, Could anyone of you give me a list of v$views and d$tables and their description... ? I am not able to log-in to dba ...i don't have access to it... or any links/documents where i can find them.. Thanks and Regards,Santosh
RE: v$Views and d$Tables
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 NUMBER TYPE_TEXTVARCHAR2(4000) OID_TEXT_LENGTH NUMBER OID_TEXT VARCHAR2(4000) VIEW_TYPE_OWNER VARCHAR2(30) VIEW_TYPEVARCHAR2(30) 2. Tables OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) TABLESPACE_NAME VARCHAR2(30) CLUSTER_NAME VARCHAR2(30) IOT_NAME VARCHAR2(30) PCT_FREE NUMBER PCT_USED NUMBER INI_TRANSNUMBER MAX_TRANSNUMBER INITIAL_EXTENT NUMBER NEXT_EXTENT NUMBER MIN_EXTENTS NUMBER MAX_EXTENTS NUMBER PCT_INCREASE NUMBER FREELISTSNUMBER FREELIST_GROUPS NUMBER LOGGING VARCHAR2(3) BACKED_UPVARCHAR2(1) NUM_ROWS NUMBER BLOCKS NUMBER EMPTY_BLOCKS NUMBER AVG_SPACENUMBER CHAIN_CNTNUMBER AVG_ROW_LEN NUMBER AVG_SPACE_FREELIST_BLOCKSNUMBER NUM_FREELIST_BLOCKS NUMBER DEGREE VARCHAR2(10) INSTANCESVARCHAR2(10) CACHEVARCHAR2(5) TABLE_LOCK VARCHAR2(8) SAMPLE_SIZE NUMBER LAST_ANALYZEDDATE PARTITIONED VARCHAR2(3) IOT_TYPE VARCHAR2(12) TEMPORARYVARCHAR2(1) SECONDARYVARCHAR2(1) NESTED VARCHAR2(3) BUFFER_POOL VARCHAR2(7) ROW_MOVEMENT VARCHAR2(8) GLOBAL_STATS VARCHAR2(3) USER_STATS VARCHAR2(3) DURATION VARCHAR2(15) SKIP_CORRUPT VARCHAR2(8) MONITORING VARCHAR2(3) Rgrds, Sony > -Original Message- > From: Santosh Varma [SMTP:[EMAIL PROTECTED]] > Sent: Friday, January 17, 2003 2:14 PM > To: Multiple recipients of list ORACLE-L > Subject: v$Views and d$Tables > > Hello all, > > Could anyone of you give me a list of v$views and d$tables and their > description... ? > I am not able to log-in to dba ...i don't have access to it... > or any links/documents where i can find them.. > > Thanks and Regards, > Santosh > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: v$Views and d$Tables
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 that is the case, the sql.bsq (under the $ORACLE_HOME/rdbms/admin) will be of use. KG = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: v$Views and d$Tables
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 !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
v$Views and d$Tables
Hello all, Could anyone of you give me a list of v$views and d$tables and their description... ? I am not able to log-in to dba ...i don't have access to it... or any links/documents where i can find them.. Thanks and Regards,Santosh