Re: Performance problems with Oracle EE 8iR2 on 64 Bit Solaris

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 18 Dec 2000 13:43:00 +0000 (GMT)
Message-ID: <eCh*zu4Jo@news.chiark.greenend.org.uk>

Alexander Penev <peneva_at_wien.spardat.at> wrote:

>Next weak we have a new meeting also with a support specialist from oracle
>but I would be very glad to become some advise from you in order to check
>some more performance options before we make the new tests. This could be as
>well advices in connection with the operating system and the T3 storage
>array "behavior" or other parameters which are not commonly known.

Have you run a utlbstat/utlestat report for these tests? What Oracle wait events are you seeing?

If you see 'buffer busy wait' wait events, adding freelists may help. I've had good results adding freelists to tables with heavy insert activity.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/

Received on Mon Dec 18 2000 - 07:43:00 CST