Re: pay_balance_values_v (ORACLE APPS HRMS) problem.

perhaps you want to consider increasing your sort area size

----- Original Message ----- 
From: "The Human Fly" <sjaffarhussain@xxxxxxxxx>
To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, May 30, 2005 3:04 PM
Subject: pay_balance_values_v (ORACLE APPS HRMS) problem.


> 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."
> --
> http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: