Hi lists
Is there a way to see the description of the column,means what value the
column stores
for v$, x$ tables.
eg: desc v$session
we will see the column like...
SADDR
SID
SERIAL#
AUDSID
PADDR
USER#
USERNAME
COMMAND
srinvias,
Do you have the Oracle Reference Manual? If you look for the descriptions of
each of the v$ views, they give all the info you are looking for. The x$
ones are not listed though..
HTH
Mark
-Original Message-
Shrinivas (MED, Keane)
Sent: Friday, November 02, 2001 12:00 PM
To:
The names from V$FIXED_TABLE and comments of the
columns from catalog.sql script. More detail from
Oracle Reference manual.
Regards.
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote:
Hi lists
Is there a way to see the description of the
column,means what value the
column
The v$ are views, not tables. And for the x$, I believe that you have to be
connected as SYS or internal to see them
Dave
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L
Hi lists
Is there a way to see the
Hi,
For V$ views you can find the details in Oracle Xi Reference Manuals.
For X$ tables the information is not documented externally.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
Shrinivas (MED, Keane)
Sent: Friday, November 02, 2001 4:00 AM
I have a zip file which contain the list of all x$ tables and structure, may
be it's help
-Original Message-
Sent: Friday, November 02, 2001 5:00 AM
To: Multiple recipients of list ORACLE-L
The v$ are views, not tables. And for the x$, I believe that you have to be
connected as SYS