Re: Sporadic ORA-04030 , part tres

From: <bdbafh_at_gmail.com>
Date: 7 Apr 2005 08:48:53 -0700
Message-ID: <1112888933.131739.30470@f14g2000cwb.googlegroups.com>

Ed,

Have you been examining v$sesstat for pga usage per session?

Its probably not an option, but if you were to not use pga_aggregate_target with dedicated server connections ... the pga memory would be associated with the user process ... after you uninstall windows and install a certified Linux distribution. (something that I'm sure that you are aware of).

Perhaps a migration of the oracle database server OS would be less painful than a recoding of the application?

I know far too well that the trace files for 4030s in 10g have far more detail than in 9.2. Have you tested this against 10.1.0.4 yet?

-bdbafh Received on Thu Apr 07 2005 - 10:48:53 CDT