High resource in our performance Database Server last 4 months...

Hi all,

Almost every day I find Session who happens to our database server that makes the performance data base to be very slow.
The following are some examples of processes that often emerge and make a slow performance.


UPDATE SET FND_CONCURRENT_REQUESTS PP_END_DATE = SYSDATE, POST_REQUEST_STATUS = 'E' WHERE REQUEST_ID =: B1

DELETE FROM WHERE AP_INTERFACE_REJECTIONS PARENT_TABLE = 'AP_INVOICES_INTERFACE' AND parent_id =: B1

R.RESPONSIBILITY_NAME SELECT FROM WHERE R.RESPONSIBILITY_ID FND_RESPONSIBILITY_VL R =: B2 AND R.APPLICATION_ID =: B1

SELECT SUBSTR (REPLACE (USER_CONCURRENT_PROGRAM_NAME,'''', ''), 1.240),
Substr (CONCURRENT_PROGRAM_NAME, 1.30) FROM WHERE FND_CONCURRENT_PROGRAMS_VL CONCURRENT_PROGRAM_ID =: B1 AND APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID