Michael Pye wrote:
> DA Morgan wrote:
>> SQL> shutdown immediate;
>>
>> What's the CPU load?
>>
>> And yes the block sizes could be part of the issue. Why 1K?
>
> cpu load drops to 0 when the database is not running. When it is running
> it averages about 5/6 but sometimes going up to 20, when previously it
> would average 2/3 and maybe sometimes go to 7/8 under heavy load.
>
> The default vxfs block size is 1k and we didn't change it from default
> when we made this filesystem. We've only since discovered that the
> default is not the same as ufs, 8k.
>
> --
> Michael
I'd suggest pouring through the docs and metalink and, if you don't find
the answer, opening an SR and asking the question.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Jul 04 2007 - 17:05:16 CDT
