SESSION_CACHED_CURSORS can help avoid even soft parses if the same SQL is run many times per session.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.