| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sparc IV Plus upgrade
Yours is a fair question but the application does 400 txns per sec and hence plan stability is of utmost importance.
From the AWR
the application 35 sqlids that run over 100,000 times in a 30 minute period,
160 sqlids that are run more than 10,000 times in a 30 minute period
280 sqlids that are run over 1,000 times in a 30 minute period and if any plan does change for the worse and the system gets fried.
Thanks
Fairlie
Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com> wrote:
Hi Fairle,
¿Why you aren’t collecting system stats? You could save your current stats, give a shot to system stats for a while, and then compare..
alvaro
All,
Environment: 8 node RAC on Solaris Sun sparc 9 64 bit
Database : 10.2.0.3 RAC
Customer is upgrading CPU boards from Sparc IV to Sparc IV pluses. There is no change in the number of cpus.
Assuming there is no collection of system stats (which could thus affect query plans) can anyone think of any other issues...in doing this upgrade...
Also is anyone out there using Sparc IV pluses.
Fairlie Rego
Senior Oracle Consultant
http://el-caro.blogspot.com/
M: +61 402 792 405
 |
 |