What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?



What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSIO..

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

Post New Answer

More Oracle General Interview Questions

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

0 Answers  


Give syntax for SQL and ORACLE joins.

0 Answers   TCS,


am completed mca2011 how get certification in oracle

1 Answers  


Explain the use of indexes option in exp command.

0 Answers  


Please explain joins in oracle?

0 Answers  






How to manage transaction isolation level?

0 Answers  


What is a shared pool?

1 Answers  


Explain what are the characteristics of data files?

0 Answers  


How to run queries on external tables?

0 Answers  


What is flashback in Oracle?

0 Answers   MCN Solutions,


query to find the maximum no persons with same age(age colomn) from emp table

1 Answers  


What is concurrency in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)