Re: Performace issue - 11.5.9 HP-UX 32 bit

Kalyan,
             Usually when more number of invoice validatation requests run
at the same time,each session will be waiting on read by the other session
wait event as all sessions will query on same blocks(If its an Logical
IO).To get a better understanding on whats going on, we need a 10046 raw
trace


Thanks
Anil

On Dec 5, 2007 12:57 AM, Kalyan Sundar <kalyan.sundu@xxxxxxxxx> wrote:

> Ya sure Anil. I will mail you ASAP.
> But I am not concerned about the solution to this particular issue now.
> Rather I am curious to know the approach to solve similar performance
> issues.
> Please let me know the bottlenecks of similar issues, so that I can
> handle/research on it in future.
>
> Thanks,
> Kalyan
>
>
>   On 12/4/07, anil kumar Pratapani <apratapani@xxxxxxxxx> wrote:
> >
> > Can you please take 10046 trace and mail us the rawtrace.,Please zip it
> >
> > On Dec 4, 2007 9:21 PM, Kalyan Sundar <kalyan.sundu@xxxxxxxxx> wrote:
> >
> > > Hi DBAs,
> > > Greetings!!!
> > >
> > > We are facing performance issue in our oracle system. We are on 11.5.9on 
> > > HP-UX 32-bit
> > > A group of users are running  'Invoice Validation' program during
> > > month-end . This has not been smooth till now. Whenever the Users tries to
> > > run the program, the Screen Freezes and they have to close the 
> > > application.
> > >
> > > This takes up the entire day with the program sometimes having a
> > > successful run.
> > > The user once tried the entire day to run the program but each time
> > > the screen froze and then she had to try late night at 1:30, the program
> > > then completed in an hour.
> > >
> > > I could infer that this is due to resource crunch. Please let me know
> > > the ways to capture the culprit eating up system's resource.
> > >
> > > Thanks,
> > > kalyan
> > > "*It is not exactly cheating, I prefer to consider it
> > > creative problem solving."*
> > >
> >
> >
>

Other related posts: