jobq slave wait taking too long
Dear all,
On our production database server, I often see certain sessions taking way too long with the wait event "jobq slave wait".
how can I prevent "jobq slave wait" events ? (or at least make it shorter or less frequent)
I tried to search about this but could not find a good source that could help me in this regard.
Please help.
DB Version : 10.1.0.5 using Real Application Clusters
OS Version : Windows 2003
Thanks in advance.