 Related Questions Latest Answer : Hi,Database buffers are used to store copy of data of data blocks that has been used recently.the set of database block buffers are called db buffer cache.redo log buffers are used to store temorary entries for redo that supose to written to redo logfiles.thanksAlok. ... Latest Answer : Alter table < Table_Name> move tablespace ; Alter index rebuild tablespace ; ... 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 ... 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 : create rollback segment roll1tablespace roll1; ... 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 : Edit itit.ora file after shutdown the data base, set path for another control file in the parameter setting. then copy the control file to the desired location where the path is setting, then start the database. ... Latest Answer : when a user updated a particular table (for example 100 rows)...the old value will be retained in the roll back segments(Oracle 8) and now it is Undo segment (oracle 9i). If the user issue a rollback command the old value will be taken from the rollback ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
