How can we plan storage for very large tables?
Limit the number of extents in the table Separate the Table from its indexes Allocate sufficient temporary storage Read more »
Archive for May, 2008
List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment to expand into another extend?
Transaction Begins An entry is made in the RBS header for new transactions entry Transaction acquired blocks in an extent of RBS The entry attempts to wrap into... Read more »
How will you monitor rollback segment status?
Querying the DBA_ROLLBACK_SEGS view The status available as follows : IN USE - Rollback Segment is on-line AVAILABLE - Rollback Segment available bur not on-line OFF-LINE... Read more »
What are the different types of Modules available in Oracle?
There are three types of modules in Oralcle Forms : Form Module - A collection of objects and code routines Menu Module - A collection of Menus( a main menu and... Read more »
What is use of LOG option in IMP command?
Name of the file to which the log of the import will be written. Read more »
What is use of DESTROY (Ver 7) option in IMP command?
A flag to indicate whether the create tablespace command found in dump files from full exports will be executed. Read more »
What is use of INDEXFILE option in IMP command?
If filename is given then all the DDL will be created in the given file. Read more »
What is use of PARFILE option in IMP command?
Name of the parameter file to passed for import command. Read more »
What is use of COMMIT option in IMP command?
A flag to indicate whether import should commit after each array. If ‘N’ then commit will take place at table level. Read more »
What is use of INCTYPE option in the IMP command?
The type of import being performed. Read more »
What is use of RECORDLENGTH option in IMP command?
The length of the record in bytes of the export dump file. Read more »
What is use of TABLES option in IMP command?
A list of tables to be imported. Read more »
What is use of TOUSER option in IMP command?
A list of database accounts into which objects in the export dump file will be imported. Read more »
What is the use of FROMUSER option in IMP command?
A list of database accounts whose objects should be read from the export dump file. Read more »
What is the use of FULL option in IMP command?
A flag to indicate whether full import should be done or not. Read more »