Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / guest

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


Please Help Members By Posting Answers For Below Questions

How to delete multiple rows from a table in oracle?

1109

What is oracle sid?

999

What is Redo Log Buffer in Oracle?

1273

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

1024

What is the difference between sharding and partitioning?

1034

What is coalesce function?

1136

Explain view?

1081

Explain the use of rows option in exp command.

1145

What is define in oracle?

1107

what are archived logs?

2256

What is MTTR advisor in Oracle?

1133

What is hash cluster in oracle?

1243

What privilege is needed for a user to connect to oracle server?

1031

How to set up autotrace for a user account?

1107

Give the various exception types.

1035