RE: Anyone Running 9.2.0.8 Database on T4?
Date: Thu, 9 May 2013 13:16:00 -0400
Message-ID: <9CE162BC5ED2C643956B526A7EDE46FF0390A767B886_at_EXM-OMF-04.Ceg.Corp.Net>
Yep I've got a few of those (as sad as that is) but I only use T4's for dev/test databases so far. The biggest problem has been that with the hyper threading the CPU_COUNT parameter becomes something like 128 depending on your server configuration which leads to derived parameters having very large values. In many cases that meant PQ statements used hundreds of threads and in at least one case a database couldn't be opened without log_buffer being 100MB+ until CPU_COUNT was set to a lower value.
Thanks,
Finn
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stojan Veselinovski
Sent: Thursday, May 09, 2013 4:19 AM
To: ORACLE-L
Subject: Anyone Running 9.2.0.8 Database on T4?
Hi all,
Anyone out there running a 9.2.0.8 db on T4?
We are seeing a bit more CPU usage after our migration from the E25K. It was quite problematic in the first week where we had a number of statements burning cpu spinning for latches.
These sql's have been tuned and we've managed to stabilise performance but we tend to see a few more spikes here and there post migration.
We have migrated a number of databases onto the T4 and this is the only one that has regressed.
Regards - Stojan.
--
http://www.freelists.org/webpage/oracle-l
This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. -EXCIP
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 09 2013 - 19:16:00 CEST