Re: Strange Oracle behavior between different environments
Date: Sat, 20 Aug 2011 00:10:21 +0000 (UTC)
Message-ID: <pan.2011.08.20.00.10.20_at_gmail.com>
On Fri, 19 Aug 2011 12:19:24 -0700, Alex L wrote:
.
>
> Mladen, it appears that both have up to date statistics, running
> GATHER_STATS_JOB nightly. SYS.AUX_STATS$ are basically the same,
> difference CPUSPEED numbers.
> Solaris:
> SYSSTATS_INFO STATUS COMPLETED
> SYSSTATS_INFO DSTART 01-21-2006 05:43 SYSSTATS_INFO
DSTOP 01-21-2006>
> 05:43 SYSSTATS_INFO FLAGS 1
> SYSSTATS_MAIN CPUSPEEDNW 452.169401387898 SYSSTATS_MAIN
IOSEEKTIM 10
> SYSSTATS_MAIN IOTFRSPEED 4096
> SYSSTATS_MAIN SREADTIM
> SYSSTATS_MAIN MREADTIM
> SYSSTATS_MAIN CPUSPEED
> SYSSTATS_MAIN MBRC
> SYSSTATS_MAIN MAXTHR
Alex, the absence of the numbers for SREATIM,MREADTIM and MBRC tells me that you didn't gather system statistics. In that case, Oracle will use its own, platform and version dependent defaults. Defaults for Windows and Solaris are likely different. You should gather system stats in the moments when the loads experienced by the system is typical. Please, use DBMS_STATS.GATHER_SYSTEM_STATS procedure to collect it. I don't know the default values for either platform, by my experience tells me that the defaults are usually very off target and do not make much sense.
-- http://mgogala.byethost5.comReceived on Fri Aug 19 2011 - 19:10:21 CDT