Dynamic Performance tables and views [message #323642] |
Thu, 29 May 2008 02:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
amjadali
Messages: 11 Registered: May 2008
|
Junior Member |
|
|
Dear Friends,
As per my understanding....
Datadictionary is Base tables and views on it is data dictionary view which is stored in system tablespaces and is created at the time of database creation and by running the catalog.sql script respectively. .....
And fixed tables ( dynamic performance table and view is in the memory and source is from memory and controlfile for information )
My problem is when is the fixed tables and its view created....
Thanks and Regards.....
|
|
|
Re: Dynamic Performance tables and views [message #323658 is a reply to message #323642] |
Thu, 29 May 2008 02:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Data dictionary are tables created at database creation time.
Fixed tables are pseudo-tables not real ones, no creation.
Catalog (including dynamic v$ views) is view set upon data dictionary and fixed tables, some created at database creation time, some with catalog.sql script (and depending ones).
Often "data dictionary" is used for all these.
Regards
Michel
|
|
|