RE: Performance problem.

Thanks Jason, I will do that.

Kind regards,

Francisco Mtz.

> I would suggest running statspack on the database for specific
> intervals.  I would also suggest sending the output of the statspack
> report to www.oraperf.com.  A very comprehensive analysis is sent back
> to you within minutes.  This may give you a better insight to your
> performance issues.  I'm not saying this is the silver bullet, but it is
> one way to try to pinpoint the issues.  I used this method to find an
> internal latch issue with Alpha TRU64 and Oracle 9.2.0.5.
>
> Jason Gilbertsen
>
>
> -----Original Message-----
> From: ora-apps-dba-bounce@xxxxxxxxxxxxx
> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of
> francisco.martinez@xxxxxxxxxxxxxx
> Sent: Thursday, May 11, 2006 9:06 AM
> To: ora-apps-dba@xxxxxxxxxxxxx
> Subject: 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: