Re: Performance problem.

Well, unfortunately we haven't taken times in their current production
environment "11.0.3 (HPUX)", also I think the latest "tests" we have done
with Development people and not with end users aren't according to
reality, we scheduled some "huge" reports to simulate "load" in this
environment.

By the way when we had "stress tests" with end users (60 concurrent users,
when is supposed to support 120 concurrent users) we had "performance
problems", slow time when trying to navigate inside of the application
(changing screens).

I don't know if we are limited with systems resources (I didn't do
machine's sizing). In the first try with "stress test" this machine was
configured with 9 Gbytes of RAM, 2.8 dual CPU's at 1.9 GHz and 5 hard
disks using RAID 0+1.

We haven't tested this version on HPUX platform.

Yes, we used FULL export on 8.0.5, then we imported on 8.1.7.4 and finally
we upgraded to 9.2.0.6. I haven't compared index count on both
environments, unfortunately we don't have access to their production
environment to do this comparision.

Yes, we are on TEST. We can't go LIVE with these current problems.

Thanks in advance.

Kind regards,

Francisco Mtz.

> Is it overall performance slowdown, or you can identify particular
> actions which are slow comparing with previous state?
> Have you used the same DB version on HPUX?
> To migrate you used exp/imp methode are you? can you compare the index
> count on both environments?
>
> PS I hope this is something that is going on on non prod env :)
>
> Yury
>
> On 5/11/06, francisco.martinez@xxxxxxxxxxxxxx
> <francisco.martinez@xxxxxxxxxxxxxx> wrote:
>> Hi Yury,
>>
>> Thanks for your quick response.
>>
>> We are on 9.2.0.6 version. We haven't tested yet this environment with
>> "SYS" and "SYSTEM" statistics collection, so we are going after
>> eliminating virtualization on this server.
>>
>> Kind regards,
>>
>> Francisco Mtz.
>>
>>
>>
>> > Francisco,
>> >
>> > Which version of Oracle database you are on?
>> >
>> > PS If you are on 8.1.7, 9.0.1 I would definetely recommend to consider
>> > migration to 9.2
>> >
>> > Yury
>> >
>> >
>> > On 5/11/06, francisco.martinez@xxxxxxxxxxxxxx
>> > <francisco.martinez@xxxxxxxxxxxxxx> wrote:
>> >> Hi partners,
>> >>
>> >> We have upgraded one Ebusiness environment from 11.0.3 to 11.5.10.2,
>> >> also
>> >> we moved from HPUX to AIX, after that we are having some performance
>> >> issues on this new platform.
>> >>
>> >> We have gathered statistics for "ALL" the schemas and the main
>> problem
>> >> is
>> >> due to I/O, all the disks reach 100% of their usage.
>> >>
>> >> I haven't analyzed the "huge" queries causing a lot of I/O's, the
>> main
>> >> waits events in my Statpack report are next ones:
>> >>
>> >> Top 5 Timed Events
>> >> ~~~~~~~~~~~~~~~~~~ % Total
>> >> Event Waits Time (s) Ela Time
>> >> -------------------------------------------- ------------ -----------
>> >> --------
>> >> db file sequential read 426,010 9,678 60.75
>> >> db file scattered read 98,033 2,469 15.49
>> >> latch free 31,605 1,800 11.30
>> >> buffer busy waits 19,365 566 3.55
>> >> direct path read 6,879 458 2.88
>> >>
>> >> I have read Note:257338.1 "Direct I/O (DIO) and Concurrent I/O (CIO)
>> on
>> >> AIX 5L", unfortunately Oracle's file systems were created like "JFS"
>> >> (due
>> >> snapshot utility for Operating System) and they are mounted with big
>> >> files
>> >> support, so we are going to change them according to above document
>> to
>> >> support "cio" option.
>> >>
>> >> Also, I have read another note regarding to "rwrb" option when
>> mounting
>> >> filesystems to avoid Operating System buffer cache.
>> >>
>> >> Also I have heard that minservers and maxservers need to be
>> increased,
>> >> we
>> >> have next default configuration:
>> >>
>> >> oraprod@p5501:/admin/oraprod$ lsattr -El aio0
>> >> autoconfig available STATE to be configured at system restart True
>> >> fastpath   enable    State of fast path                       True
>> >> kprocprio  39        Server PRIORITY                          True
>> >> maxreqs    4096      Maximum number of REQUESTS               True
>> >> maxservers 10        MAXIMUM number of servers per cpu        True
>> >> minservers 1         MINIMUM number of servers                True
>> >>
>> >> Has anybody had the same performance problems on AIX?
>> >>
>> >> In this server we have "virtualization" configuration, we are going
>> to
>> >> eliminate this to avoid "memory" and "cpu" consumption.
>> >>
>> >> Any advice or comment will be really appreciated.
>> >>
>> >> Kind regards,
>> >>
>> >> Francisco Mtz.
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>> > --
>> > Yury
>> > +44 7738 013090 (GMT)
>> > ============================================
>> > http://otn.oracle.com/ocm/jvelikanovs.html
>> >
>>
>>
>>
>>
>
>
> --
> Yury
> +44 7738 013090 (GMT)
> ============================================
> http://otn.oracle.com/ocm/jvelikanovs.html
>

Other related posts: