What does this pl/sql query perform on the database.
LOCK TABLE FND_CONCURRENT_QUEUES IN EXCLUSIVE MODE NOWAIT
Keyword Statement / Keyword remarks LOCK TABLE FND_CONCURRENT_QUEUES 'FND_CONCURRENT_QUEUES' table is explicitly locked IN EXCLUSIVE MODE will allow queries to be executed by the session that has execute this key words, but will not allow any other DML activities to be performed by other users NOWAIT lets you get control of the object even if the respective object is been locked by some other sessions/users.
For almost 3 months we are getting performance issue in the morning for about 45min to 1 hr. In EM graph, commit graph is going beyond CPU limit. Even login page is not loading....
Please check the DB, Application and apache log files for more information. I also suggest you to run an addm task to get analysis information and recommendation.