You may also want to ask your DBA's to make sure that the queries' execution paths are optimized. Oracle 10g would save the execution path automatically but 11g does not. Once I started sending captured queries (pulled from SQL logging) to our dba's and they scripted the execution path, we started seeing big performance improvements.
- Performance matrix vikram_k
- Re: Performance matrix Misi Mladoniczky
- Re: Performance matrix LJ LongWing
- Re: Performance matrix Misi Mladoniczky
- Re: Performance matrix Darrell Reading
- Re: Performance matrix Tommy Morris
- Re: Performance matrix vikram_k
- Re: Performance matrix Tommy Morris
- Re: Performance matrix LJ LongWing