Re: Performace issue - 11.5.9 HP-UX 32 bit

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: