Latest Answer: 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 parameter we can optimize the size of ...
Latest Answer: Redo log buffer is circular buffer,lgwr writes these buffers in cyclic faishon.redo log buffers contains redo entreies which are used to reconstruct or redo chandes. ...
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 ...
Latest Answer: store data in tablespaces to avoid disk contension.system tablespace-recursive callsuserdata-users objectsindex tablespace-for indexesrollback segmnets-undo tablespace or manual rollback segmentsplace application specific data in respective tablespaces.place ...
Latest Answer: these r the extents which indicates data was not stored in the segment. ...
Latest Answer: depends upon the storage parameters. ...
Latest Answer: to avoid row migration from future updates to the block pctfree is set. ...
Latest Answer: to avoid the space wastage we use OPTIMAL parameter. ...
Latest Answer: create rollback segment roll1tablespace roll1; ...
Latest Answer: by correctly fixing optimal size ...
View page << Previous 6 7 8 9 [10] 11 12 Next >>
Go Top
