OraFAQ Forum: General » diff between v$ tables and DBA

Home » Other » General » diff between v$ tables and DBA_ tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

diff between v$ tables and DBA_ tables [message #185424]

Tue, 01 August 2006 12:11

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

Report message to a moderator

Re: diff between v$ tables and DBA_ tables [message #185444 is a reply to message #185424]

Tue, 01 August 2006 15:30

Frank Naude
Messages: 4596
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.

Report message to a moderator

Previous Topic:	_xpl_peeked_binds_log_size: what does it mean?
Next Topic:	please help me quickly

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 20 06:57:13 CDT 2025