|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions 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 : 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) ... Latest Answer : LGWR process wirtes all change vectors from theredo log buffer to online redo log file sequentially. ... Latest Answer : Disk shadowing or mirroring is done either using a software or a hardware utility called RAID. Disk shadowing enables another disk to take-over from a failed hard disk avoiding any downtimes. Generally Hardware fial-overs are enabled on all servers. ... The System Global Area in a Oracle database is the area in memory to facilitates the transfer of information between users. It holds the 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 Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop Latest Answer : If its the same database use:alter table the_table move tablespace other_tablespace; alter index the_index rebuild tablespace other_tablespace; ... Create a database which implicitly creates a SYSTEM Rollback Segment in a SYSTEM tablespace. Create a Second Rollback Segment name R0 in the SYSTEM tablespace. Make Latest Answer : Create rollback segment by using command likecreate rollback segment rbs01 tablespace tbs1 storage (initial 1M next 1M optimal 5M minextents 20 maxextents 100)Edit the database initialization file to include the name of the new rollback segmentROLLBACK_SEGMENTS = ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
