Home » RDBMS Server » Backup & Recovery » Dynamic Performance tables and views (9i)
Dynamic Performance tables and views [message #323642] Thu, 29 May 2008 02:10 Go to next message
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
Michel Cadot
Messages: 64152
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
Previous Topic: Problem in Creating Recovery Catalog
Next Topic: How to Take export of Synonym
Goto Forum:
  


Current Time: Sat Dec 10 14:44:46 CST 2016

Total time taken to generate the page: 0.08418 seconds