What is SAVE POINT ?
For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later rolling back all work performed from the current point in the transaction to a declared savepoint within the transaction.
What are the values that can be specified for OPTIMIZER MODE Parameter ?
COST and RULE.
Can one rename a tablespace? (for DBA)
No, this is listed as Enhancement Request 148742. Workaround:
Export all of the objects from the tablespace
Drop the tablespace including contents
Recreate the tablespace
Import the objects
What is RULE-based approach to optimization ?
Choosing an executing planbased on the access paths available and the ranks of these access paths.
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.
No comments:
Post a Comment
Thanks to given comments.......