I've got a good reason. Monitor your PGA usage for SMON. Ours is at = 220MB and growing steadily. For this DB, that's over half of the total = PGA size. The largest user PGA is at 4MB, with the majority of them at = about 200K. It looks like bug #3544705, but I've filed a TAR to make = sure... I'm Rich Jesse and I approve of this message. Rich Jesse System/Database Administrator rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > Sent: Thursday, May 06, 2004 6:23 AM > Subject: Re: Reason for upgrading from 8.1.7 to 9iR2 >=20 >=20 > End of year, 8i support is discontinued, i.e. assuming you are paying > for Oracle Support :). ---------------------------------------------------------------- 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 -----------------------------------------------------------------