johndanter
Legendary Poster
Hi folks,
I have this query popping up every so often in our database (shown below) and we think we've traced it P47036.
The user is just entering a Sold To AN8 and clicking Find.
It's killing the server as it's a huge table and no index on it. (we'll come back to that later)
The DBA will then kill the Oracle session and CNC state the E1 session is dead, yet the SQL statement comes back to life!!!!!
Is this possible?
Or could it be another user is repeating the action?
FROM PRODDTA.F47036 T0, PRODDTA.F470371 T1 WHERE (((T1.SZHLVL = :1 AND T1.SZAN8 = :2 ))) AND (T0.SYEKCO = T1.SZEKCO AND T0.SYEDOC = T1.SZEDOC AND T0.SYEDCT = T1.SZEDCT) ORDER BY T0.SYEDOC ASC , T0.SYEDCT ASC , T0.SYEKCO ASC
Thanks
John
I have this query popping up every so often in our database (shown below) and we think we've traced it P47036.
The user is just entering a Sold To AN8 and clicking Find.
It's killing the server as it's a huge table and no index on it. (we'll come back to that later)
The DBA will then kill the Oracle session and CNC state the E1 session is dead, yet the SQL statement comes back to life!!!!!
Is this possible?
Or could it be another user is repeating the action?
FROM PRODDTA.F47036 T0, PRODDTA.F470371 T1 WHERE (((T1.SZHLVL = :1 AND T1.SZAN8 = :2 ))) AND (T0.SYEKCO = T1.SZEKCO AND T0.SYEDOC = T1.SZEDOC AND T0.SYEDCT = T1.SZEDCT) ORDER BY T0.SYEDOC ASC , T0.SYEDCT ASC , T0.SYEKCO ASC
Thanks
John