RE: v$Views and d$Tables

2003-01-19 Thread Santosh Varma
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

2003-01-18 Thread Robert Freeman
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

2003-01-17 Thread Deshpande, Kirti
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

2003-01-17 Thread Rachel Carmichael


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

2003-01-17 Thread Deshpande, Kirti



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

2003-01-17 Thread Sony kristanto
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

2003-01-17 Thread Santosh Varma
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

2003-01-17 Thread K Gopalakrishnan
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

2003-01-16 Thread Santosh Varma



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