SESSION_CACHED_CURSORS can help avoid even soft parses if the same SQL is run many times per session.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.