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_at_gmail.com> 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."
> --
> http://www.freelists.org/webpage/oracle-l
>=20
--=20
Regards,
Chris Gait
--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 30 2005 - 17:21:31 CDT
