BNFD - Your DBA NoteBook On The Net!!!

Monday, March 17, 2008

Data dictionary view VS Dynamic view

Dictionary Views vs Dynamic Performance Views:

1. Dictionary Views Dynamic Performance Views
The DBA_ views usually have plural names (for
example, DBA_DATA_FILES).

The names of the V$ views are generally singular
(for example, V$DATAFILE).

2. The DBA_ views are available only when the
database is open and running.

Some V$ views are available even when the
database is not fully open and running.

3. The data contained in the DBA_ views is generally
uppercase.

The data contained in the V$ views is usually
lowercase.

4. The data contained in the DBA_ views is static
and is not cleared when the database is shut
down.

The V$ views contain dynamic statistical data
that is lost each time the database is shut
down.

5 comments:

Anonymous said...

Thanx Deepthi .. nice info.

Anonymous said...

Thats a very good info Deepthi, thanks.

Anonymous said...

Deepti you have to learn more things regarding data dictionary views and dynamic performance views, before posting. OK..

Anonymous said...

u dont know anything diptimayee .. better learn n then post. ok

Little Kid said...

Hello Deeptimayee

Nice info.. thanks a lot for your posts.
Please send me ur gmail ID ..may be u can help me in trouble...

Anyways will wait for ur reply.
reply me vswajit@gmail.com