SESSION_CACHED_CURSORS can help avoid even soft parses if the same SQL is run many times per session.
I also suggest that you use automatic undo management.
Dig Deeper on Oracle database performance problems and tuning
Related Q&A from Paul Baumgartel
I am updating 80% of the rows in a 30-column (6 VC  and a blob) table. I have the STD 10% pctfree set up. I am getting fair throughput,... Continue Reading
Can I install the Oracle 8i client and the Oracle 10g client on Windows XP? Continue Reading
How I can export multiple tables (3000 of them, actually) in Oracle 9i Unix-HP? I created three files (1000 tables in each file) with starting table ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.