![]() ![]() In oracle 10g with all above options it took more than 8 hrs to analyze same table. In 10g same proc took more than 8 but table size has grown to 135g only. ![]() my observation are follow on same host for gathering a stats of 120g table in oracle 9i it took 54 min with following options. The db size 1.1tb segment level with CIO enabled file system. Table stat generation taking lots of time in oracle 10g as compate to oracle 9i this observation on AIX platform only. In 10g the default of parallel_adaptive_multi_user is true. If parallel_adaptive_multi_user set to true then the degree of queries will be reduced depending on the number of active queries are running on the database. similarly oracle has changed default value of some of the parameters like parallel_adaptive_multi_user. Optimizer considers I/O & cpu for calculating cost of a query. As we all of us knowns Oracel has made drastic changes in oracle 10g optimizer. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |