Have you opened a TAR on this? You should if you have support that is not charged per incident. What is your version? There were a couple of bugs related to this view, but I don't see anything recent. Regards, Chris Gait On 5/30/05, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote: > Hello list, >=20 > 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? >=20 > Thanks for your time. > --=3D20 > Best Regards, > Jaffar, OCP DBA > Banque Saudi Fransi > Saudi Arabia > -------------------------------------------------------------------------= --=3D > ------------- > "It is your atittude, not your aptitude that determins your altitude." > -- > //www.freelists.org/webpage/oracle-l >=20 --=20 Regards, Chris Gait -- //www.freelists.org/webpage/oracle-l