Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
obiee v12 - "too many running queries"
Hello,
we've experienced "too many running queries" error since last week intermittently.
Weblogic has no stuck thread, so we presume it's a db issue.
The only solution we've found out is to restart BI services.
I've some questions for you:
- Is there a way to check which are the current running queries? In this way i could analyze them from a dba perspective.
- We've several connection pool. Why *all* off them return "too many running queries" at the same time?
thank you very much.
Daniele
OBIEE v12.2.1.2.0
DB: oracle exadata
Answers
-
Did you check this document?: https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=211650537315642&id=1462776.1&_afrWindowMode=0…
EDIT : That link doesn't seem to work correctly, try this one instead:
0 -
It might also be worth checking with your local network support to ascertain if there have been any network / DNS or similar issues recently.
0 -
Hello Martin, i've checked that doc and everything is ok.
thank you,
Daniele
0 -
Hello Robert, that's a good point but, is there a log i can forward to network guys to help them?
thank you,
Daniele
0