What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?



What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the A..

Answer / 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

More Oracle General Interview Questions

How do I manually create a database in oracle?

0 Answers  


How to create a new table in your schema?

0 Answers  


What is an UTL_FILE.What are different procedures and functions associated with it?

1 Answers  


Explain the use of Merge statement in oracle 11g

0 Answers   Infosys,


what are stored procedures?

7 Answers   TCS, Wells Fargo,


why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,


How to do paging with oracle?

0 Answers  


what is index?

4 Answers  


How to define a record variable to store a table row?

0 Answers  


Explain the use of show option in imp command.

0 Answers  


What is sharded cluster?

0 Answers  


if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

1 Answers   MasterCard,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • 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)