|
Question |
Rating |
View Answer |
|
How can we plan storage for very large tables ? |
|
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 toexpand into another extend. |
|
View Answer |
|
How will you monitor rollback segment status ? |
|
View Answer |
|
How will you monitor the space allocation ? |
|
View Answer |
|
Why query fails sometimes ? |
|
View Answer |
|
How the space utilization takes place within rollback segments ? |
|
View Answer |
|
How will you create multiple rollback segments in a database ? |
|
View Answer |
|
What is the functionality of SYSTEM table space ? |
|
View Answer |
|
What is the OPTIMAL parameter? |
|
View Answer |
|
What is the role of PCTFREE parameter is Storage clause ? |
|
View Answer |
|
How does Space allocation table place within a block ? |
|
View Answer |
|
What is the significance of having storage clause ? |
|
View Answer |
|
Which parameter in Storage clause will reduce no. of rows per block? |
|
View Answer |
|
How free extents are managed in Ver 6.0 and Ver 7.0 ? |
|
View Answer |
|
What is meant by free extent ? |
|
View Answer |
|
How will you force database to use particular rollback segment ? |
|
View Answer |
|
List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ? |
|
View Answer |
|
How will you swap objects into a different table space for an existing database ? |
|
View Answer |
|
What is meant by redo log buffer ? |
|
View Answer |
|
What is meant by recursive hints ? |
|
View Answer |