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' ...
Latest Answer : Yes. Using raw files/devices for database can have a slight performance gain. Raw files are unformatted disk partitions that can be used as one large file. Raw devices have the benefit of no file system overhead, because they are unformatted partitions. ...
Latest Answer : The Control File is a small binary file necessary for the database to start and operate successfully. Each Control file is associated with only one Oracle database. Before a database is opened, the control file is read to determine if the database is ...
Latest Answer : Multiplexing Redo log file called Mirroing. ( Keeping multiple copies in different disks) ...
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
