| Dynamic Performance tables and views [message #323642] |
Thu, 29 May 2008 02:10  |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
