Re: pay_balance_values_v (ORACLE APPS HRMS) problem.
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: sjaffarhussain@xxxxxxxxx
- Date: Mon, 30 May 2005 10:20:48 +0200
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.
HTH
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.
>--=20
>Best Regards,
>Jaffar, OCP DBA
>Banque Saudi Fransi
>Saudi Arabia
>---------------------------------------------------------------------------=
>-------------
>"It is your atittude, not your aptitude that determins your altitude."
>--
>//www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
