Latest Answer : Hi,Dictionary cache is memory arear in shared pool.dictionary cache are used to hold db blocks of recently used data dictionary tables.thanksAlok.  ...

 The  System   Global  Area  in  a  Oracle database is the area in memory to facilitates  the  transfer  of information between users. It holds the 

 The data dictionary cache is stored in an area in SGA called the Shared SQL Pool.  This will allow sharing of parsed SQL statements among concurrent users. 

 Database buffers are cache in the SGA used to hold the data blocks that are read  from  the  data  segments in the database such as tables, indexes and clusters DB_BLOCK_BUFFERS 

 Dictionary  cache is information about the databse objects stored in a data dictionary table. 

 Number  of  times processes repeatedly query the dictionary table is called recursive  hints.  It  is due to the data dictionary cache is too small. By increasing the SHARED_POOL_SIZE 

List the Optional Flexible Architecture (OFA) of Oracle database? or How  can  we  organize  the  tablespaces in Oracle database to have maximum performance ?

 SYSTEM - Data dictionary tables.DATA  - Standard operational tables.DATA2- Static tables used for standard operationsINDEXES - Indexes for Standard operational tables.INDEXES1 - Indexes of static 

 To manage the database level transactions such as modifications of the data dictionary table that record information about the free space usage. 

Latest Answer : 1.System tablespace is required in all databases.2.It is created with the database.3.Contains the data dictionary and stored program units.4.Contains SYSTEM undo segment. ...

List  the  sequence  of  events  when a large transaction that exceeds beyond  its  optimal  value  when  an  entry  wraps and causes the rollback segment to expand into another extend. Transaction Begins. An entry is made in the RES header for new transactions entry Transaction acquires blocks in an extent of RBS The  entry  attempts to wrap into second extent. None is available, so that the RBS must extent. The

 It  is  a  measure  of  well the data cache buffer is handling requests for data. Hit Ratio = (Logical Reads - Physical Reads - Hits Misses)/ Logical Reads.