Home » Other » General » diff between v$ tables and DBA_ tables
diff between v$ tables and DBA_ tables [message #185424] Tue, 01 August 2006 12:11 Go to next message
jittu_143
Messages: 1
Registered: August 2006
Location: dallas
Junior Member

Hi,

Can any one tell me the differences between v$ tables and dba_ tables?

thnx a lot
Re: diff between v$ tables and DBA_ tables [message #185444 is a reply to message #185424] Tue, 01 August 2006 15:30 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
V$% views return data from memory structures. Data is lost when the instance is restarted.

DBA_% tables return data from the database's data dictionary (SYSTEM tablespace). Data persists across instance restarts.
Previous Topic: _xpl_peeked_binds_log_size: what does it mean?
Next Topic: please help me quickly
Goto Forum:
  


Current Time: Tue Dec 03 06:05:31 CST 2024