Nothing to add to few previous posters regarding setting your tuning targets.
Few additional thoughts coming to mind after that...I would expect that 10+K executions per second don't do hard parses - it wouldn't fly as high as 10000+ executions per second. Perhaps, it's still doing soft parsing which would be significant at this rate so it might be something to look at.
It can also be implied from previous posts - doing many small calls for a single business transaction/function is often quite inefficient so redesign might be in order.
Zhu,Chao wrote:We have some databases with load profile like lots of light query (mostly pk based), each execution cost only 3-6 buffer_gets and no complex join etc. But due to excessive executions (10K+ query per second), load is also driving pretty high.Anyone has experience tune such kind of application/database? From single SQL point of view, they are already perfect.-- Regards Zhu Chao www.cnoug.org No virus found in this incoming message. Checked by AVG.Version: 7.5.524 / Virus Database: 269.23.6/1403 - Release Date: 4/29/2008 7:26 AM
