Answered by: Lachi on 2005-06-08 07:28:04For perticular transaction Alter system set rollback segment 'name'; For database, we can set in pfile. Rollback_segment='name' 

Latest Answer : In above answer one correction is there,  For perticular transaction we can use fallowing syntax.  >set transaction use rollback segment 'name' ...

 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. 

 It is area in memory that is used by a Single Oracle User Process. 

 Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored. 

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

 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 

 Changes made to entries are written to the on-line redo log files. So that they can be used in roll forward operations during database recoveries. Before  writing  them  into