obiee v12 - "too many running queries"

Question

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

PeregoD · Answer

Hello Robert, that's a good point but, is there a log i can forward to network guys to help them?

thank you,

Daniele

PeregoD · Answer

Hello Martin, i've checked that doc and everything is ok.

thank you,

Daniele

Robert Angel · Answer

It might also be worth checking with your local network support to ascertain if there have been any network / DNS or similar issues recently.