Home » SQL & PL/SQL » SQL & PL/SQL » V$tables
V$tables [message #190803] Fri, 01 September 2006 05:57 Go to next message
sam4all
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member
Hi

What are these v$, x$ tables and views?
what are the uses ?
Re: V$tables [message #190807 is a reply to message #190803] Fri, 01 September 2006 06:13 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member


sqlplus, concepts manual

v$view datadictionary views

x$ are base tables.



Re: V$tables [message #190814 is a reply to message #190807] Fri, 01 September 2006 06:44 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Technically, the majority of the x$ tables are the underlying C structures, made visible as tables from inside the database
Re: V$tables [message #190819 is a reply to message #190807] Fri, 01 September 2006 07:14 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
and v$views are dynamic performance views rather than dd views

Jim
Previous Topic: Data insertion
Next Topic: DBMS_CRYPTO for BLOB Encryption using VB6
Goto Forum:
  


Current Time: Tue Dec 06 06:18:16 CST 2016

Total time taken to generate the page: 0.16356 seconds