Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: pay_balance_values_v (ORACLE APPS HRMS) problem; OAUG DBSIG marketing warning.

RE: pay_balance_values_v (ORACLE APPS HRMS) problem; OAUG DBSIG marketing warning.

From: Mark W. Farnham <>
Date: Mon, 30 May 2005 08:57:52 -0400
Message-ID: <>

The OAUG DBSIG is holding a meeting during the OAUG Connection Point 2005 Conference (aka The OAUG global conference for 2005.) For folks in your situation I can't think of a better place to be. In the first place, it is quite likely you'll meet someone who has already solved your exact problem. In the second place, you'll very likely learn how to apply scientific, unlikely to de-support you, techniques to find and fix performance problems in code you can't touch.

You'll be able to return to your company and say that the types of things you propose to do are commonly supported by Oracle, and you'll probably learn how to submit e-business suite performance enhancement requests to Oracle in a way that makes it as easy as possible for Oracle to act on your request.

In general I have found that Oracle never really intends to make life hard for us.


Mark W. Farnham
Director, OAUG
Vice Chair, OAUG DBSIG

-----Original Message-----
[]On Behalf Of The Human Fly Sent: Monday, May 30, 2005 4:26 AM
To: Stephane Faroult
Cc: Oracle-L Freelists
Subject: Re: pay_balance_values_v (ORACLE APPS HRMS) problem.

As other suggested, I wanted to try increasing my PGA size. I just learned that its on test server with 250 pga size. Let me try increasing pga size first then I will look after other options. Stephane, I think we can play with these sqls as you suggested, the only problems here in my org. that they said it provided by oracle and we should not touch it, something like this impression. Thanks for your time.

On 5/30/05, Stephane Faroult <> wrote:
> I don't see why not been allowed to change any SQL provided by Oracle
> would prevent you from tracing it. It doesn't work as you would like it
> to. Check what it does. Get the query text if you can. See how you would
> like it to work. Try hints. Once you know how it *should* work you have
> a number of options opened, without even touching the code:
> - A number of parameters can possibly be modified, preferably at the
> session level, to change the behaviour of the optimiser (BTW, stupid
> question but ... stats are OK? Perhaps that some surgically computed
> histogram would help)
> - When everything else fails, you can use the black magic of outlines to
> make Oracle execute the query as best suits you.



> Stephane Faroult

> The Human Fly wrote:

> >Hello list,
> >
> >We are facing performance problems with PAY_BALANCE_VALUES_V view
> >which comes with Oracle Apps HRMS module. Since it is written by
> >ORACLE, one should expect it runs very fast and there will be no
> >performance problems.
> >We have Windows server with 2 cpu and 4 gb of RAM. However, when I run
> >a simple SELECT * FROM PAY_BALANCE_VALUES_V it is taking end-less
> >time. I can't even trace this as we can't change any sql which is
> >provided by oracle. However, I seek your assistance or advices on
> >this.
> >Does anyone have faced performance problem with this veiw?
> >
> >Thanks for your time.
> >--=3D20
> >Best Regards,
> >Jaffar, OCP DBA
> >Banque Saudi Fransi
> >Saudi Arabia
> >------------------------------------------------------------------------=
> >-------------
> >"It is your atittude, not your aptitude that determins your altitude."
> >--
> >
> >
> >
> >


Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia


"It is your atittude, not your aptitude that determins your altitude."

Received on Mon May 30 2005 - 09:05:43 CDT

Original text of this message