Sometimes concurrent request is running very slow or could not able to complete so user have to handle those request through follow few steps. Find out the request which is...

Details of concurrent request with user and period SELECT req.request_id, DECODE (prg.user_concurrent_program_name, 'Report Set', 'Report Set:' || req.description, prg.user_concurrent_program_name) AS name, argument_text AS parameters, req.resubmit_interval, NVL2 (req.resubmit_interval, 'Periodically', NVL2 (req.release_class_id,...

During the debug of form user face issue to find out the trace file of the activity. Below script make it easy to find trace file through concurrent request id....

Full details of blocking session SELECT s.inst_id, NVL (s.username, 'Internal') database_user, s.SID, s.event, s.p1, s.serial#, p.spid, m.TYPE, DECODE (m.lmode, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4,...

Find Record lock through query which provide two record of same form session in which status of one session should be NOWAIT which should be kill for release the lock....