Unable To Extract Data From PAY_BALANCE_VALUES_V - Performance Issues
(Doc ID 1916545.1)
Last updated on OCTOBER 23, 2023
Applies to:
Oracle Payroll - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 11i version, Balances
ACTUAL BEHAVIOR
---------------
Facing performance issue when extracting data from PAY_BALANCE_VALUES_V.
TKPROF SQL Trace shows the most expensive query is:
select *
from
pay_balance_values_v where assignment_id=:"SYS_B_0"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 244 148.89 227.79 0 15327 0 3644
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 246 148.89 227.79 0 15327 0 3644
Tables are last analyzed on 28-Jun-2014.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Issue the following sql:
select * from PAY_BALANCE_VALUES_V.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |