|
-
Currently my Optimizer_Index_cost_adj is 100 and even after as per your sugegstions like setting it to low value- It did'nt helped.Anything else do I need to look into
1* ALTER SESSION SET OPTIMIZER_INDEX_COST_ADJ = 10
Session altered.
120 rows selected.
Elapsed: 00:22:52.09
Statistics
----------------------------------------------------------
798 recursive calls
1 db block gets
6166391 consistent gets
6062185 physical reads
120 redo size
7247 bytes sent via SQL*Net to client
512 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
38 sorts (memory)
0 sorts (disk)
120 rows processed
Last edited by portal; 06-15-2005 at 04:29 PM.
sat
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote