Problems in memory tuning

[mohi]

Hello, I have problems with memory tuning. The reports of Dev2000 in our company are taking a very long time. I checked the indexes on the columns of those tables being accessed and found that they are properly indexed. Then I increased the shared pool size, sort area size and db buffer cache size and now I have problem that the reports have become more slow. What should I do?

[sambavan]

My suggestion would be to run the stats pack and then proceed to tune the SGA. Your cholk points could be anywhere. Check your buffer cache size optimizer_mode and etc

Sam

[jperusco]

Hi Sam,

Have a look at the init.ora parameter OPTIMIZER_MAX_PERMUTATIONS.

"OPTIMIZER_MAX_PERMUTATIONS restricts the number of permutations of the tables the optimizer will consider in queries with joins."

HTH
John