What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?
Answer / guest
This value causes the optimizer to choose the rule-based
approach for all SQL statements in a session regardless of
the presence of statistics
Is This Answer Correct ? | 0 Yes | 0 No |
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Give syntax for SQL and ORACLE joins.
am completed mca2011 how get certification in oracle
Explain the use of indexes option in exp command.
Please explain joins in oracle?
How to manage transaction isolation level?
What is a shared pool?
Explain what are the characteristics of data files?
How to run queries on external tables?
What is flashback in Oracle?
query to find the maximum no persons with same age(age colomn) from emp table
What is concurrency in oracle?