Performance Issue need urgent help

[ggnanaraj]

Have you checked with the developers of your application that uses the db? Any issues there?

So also, check your v$session...

SELECT  rpad(USERNAME,15), TO_CHAR(LOGON_TIME, 'DD-MON-YYYY'), rpad(OSUSER,20),
rpad(module,15), RPAD(MACHINE,20),  status, COUNT(*) FROM V$SESSION
GROUP BY USERNAME, TO_CHAR(LOGON_TIME, 'DD-MON-YYYY'), OSUSER, module, MACHINE, status
order by 6

HTH.