|
Related Questions |
View Answer |
|
How can we organize the tablespaces in Oracle database to have maximum performance
|
View Answer
|
|
How will you force database to use particular rollback segment
|
View Answer
|
|
What is meant by free extent
|
View Answer
|
|
Which parameter in Storage clause will reduce number of rows per block
|
View Answer
|
|
What is the significance of having storage clause
|
View Answer
|
|
How does Space allocation table place within a block
|
View Answer
|
|
What is the role of PCTFREE parameter is storage clause
|
View Answer
|
|
What is the OPTIMAL parameter
|
View Answer
|
|
What is the functionality of SYSTEM table space
|
View Answer
|
|
How will you create multiple rollback segments in a database
|
View Answer
|
|
How the space utilization takes place within rollback segments
|
View Answer
|
|
Why query fails sometimes
|
View Answer
|
|
How will you monitor the space allocation
|
View Answer
|
|
How will you monitor rollback segment status
|
View Answer
|
|
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.
|
View Answer
|
|
How can we plan storage for very large tables
|
View Answer
|
|
How will you estimate the space required by a non-clustered tables
|
View Answer
|
|
It is possible to use raw devices as data files and what are the advantages over file system files
|
View Answer
|
|
What is a Control file
|
View Answer
|
|
How to implement the multiple control files for an existing database
|
View Answer
|