Re: pga_aggregate_target

[Ryan]

Anyone have problems with pga_aggregate_target on Solaris. Richard Foote wrote the following about HP-Unix.   http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=829Gb.63613%24aT.16120%40news-server.bigpond.net.au&rnum=1&prev=/groups%3Fq%3Dpga%2Bgaffuri%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Friday, December 26, 2003 3:19 PM Subject: Re: pga_aggregate_target Read the PGA section of the performance tuning manual. It's pretty good, tuning the PGA is fairly simple. If you are using statspack, the pga data will give you some good history. I have some scripts I can share if you like, let me know. Jared "Jeffrey Beckstrom" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  12/26/2003 11:34 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        pga_aggregate_target Starting an upgrade project for 8i to 9i R2.  How can I come up with a reasonable starting value for the pga_aggregate_target parameter?       Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113