What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Answer Posted / guest
This value causes the optimizer to the cost-based approach
for all SQL statements in the session regardless of the
presence of
statistics and to optimize with a goal of best throughput.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is the data pump import utility?
How to check the oracle tns settings?
How do I reset a sequence in oracle?
What is an external table?
20. Using a set operator, display the client number of all clients who have never placed an order.
What are the attributes of cursor?
Hi Can any one tell me what are the API's used in requisition import.
How to use existing values in update statements using oracle?
How many types of cluster table in Oracle?
How to delete all rows a table in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is the difference between formal parameters and actual parameters?
What is meant by a deadlock situation?