Latest Answer : there are main two causes for reparsing1)the objects which the query is refrencing has been modified 2) or the parsed version of sql text has been aged out of the library cache. ...

Latest Answer : Optimal Flexible Architecture is a set of configuration standard created to ensure reliable Ora installation that require little maintenance. It has a default file naming and Directory layout for naming convention and Directory distribution. It organizes ...

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.

 Due to insufficient Shared SQL pool size. Monitor   the ratio of the reloads takes place while executing SQL statements.   If   the   ratio   

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 

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

 The space used transaction entries and a deleted record does not become free immediately after completion due to delayed cleanout. Trailing nulls and length bytes are not stored.  Inserts 

List of table accounts should be exported. 

 List of tables should be exported.