What are the values that can be specified for
OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

Answer Posted / guest

CHOOSE,ALL_ROWS,FIRST_ROWS and RULE

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out the difference between commit, rollback, and savepoint?

806


How are extents allocated to a segment?

785


What are the different types of failures that occur in Oracle database?

832


What the is the diff between local index and global index. give some example.

1379


How to pass a parameter to a cursor in oracle?

849


What is recovery manager in Oracle?

816


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5043


How to check the oracle tns settings?

791


We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5120


How a database is related to tablespaces?

775


Can you create a synonym without having a table?

772


How to revoke create session privilege from a user in oracle?

759


How would you begin to troubleshoot an ORA-3113 error?

1828


Explain the types of exception?

865


What is the fastest query method to fetch data from the table?

1097