-
Hi everybody,
I am little bit confused...the problem is i want to know where all these V$ tables are stored(schema).
I connected to sql through
1.scott
2.system
3.sys
and i ran the query in all the three sessions
SQL> SELECT * FROM TAB WHERE TNAME LIKE 'V$%';
no rows selected
Then i simply typed....
SQL> DESC V$NLS_PARAMETERS
Name
----------------------------------------------------
PARAMETER
VALUE
SQL> DESC V$VERSION
Name
----------------------------------------------------
BANNER
And i am able to see the table definations...i just want to know where all these V$ tables are stored..
Thanks in advance
pras
-
Hi.
They are dynamic performance views owned by SYS not tables and they are called v_$ not v$. The v$ comes from the fact that you are accessing them via a public synonym named v$.
View: v_$database
Synonym: v$database
Try:
SELECT view_name
FROM dba_views
WHERE view_name LIKE 'V_$%';
And
SELECT synonym_name, table_name
FROM dba_synonyms
WHERE synonym_name like 'V$%';
That should clear it up.
-
Thanks
HI TimHall,
Thanks a lot!!!
pras
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|