Damage Control

Apps Users: Do you recognize this key sequence? alt-v r enter alt-r alt-r alt-r alt-r alt-r ... That's me waiting for concurrent requests to complete ... or worse ... to start! Are you, your Developers or Test Team constantly clicking the "Refresh" button on the View Concurrent Requests screen to no avail? If this is you then read on ... or forward to your DBA ... it could be time to decrease the sleep time of your standard concurrent manager! Does the following query return 30, 60 or higher for the "Standard" concurrent manager? select fcq.concurrent_queue_id , fcq.concurrent_queue_name , fcqt.user_concurrent_queue_name , fcqs.sleep_seconds sleep_sec , fcqs.min_processes min_proc from fnd_concurrent_queues fcq , fnd_concurrent_queues_tl fcqt , fnd_concurrent_queue_size fcqs , fnd_concurrent_processors fcpr where fcq.concurrent_queue_id = fcqs.concurrent_queue_id and fcq.concurrent_queue_id = fcqt.concurrent_q
http://feeds.feedburner.com/~r/garethroberts/~3/248796077/boost-productivity-reduce-user.html