Note in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st ----- Original Message ----- From: "Duret, Kathy" <kduret@xxxxxxxxxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, June 02, 2004 10:03 PM Subject: RE: 4031 - errors : OK - here are some things that contributed to my problems and woes: : : 1) we set cursor_space_for_time = false - had been set to true for some : prepared statements we were running : this also gave us a bonus where it fixed leaks from update across : db_links and heterogeneous services (not my idea ok, I lost the fight : reminder to self to get bigger boxing gloves) : No need for bigger gloves - surely that's only more padding - you just need to improve your hit ratio. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------