Toad World® Forums


Welcome to the Spotlight on Oracle forum. This forum is for discussing any and all aspects of Spotlight on Oracle. Have a question? Ask it here. Something been on your mind about Spotlight and you’re wondering what others think? Again, post it here for general discussion. This forum your place to ask questions, share your experiences, and hopefully have a little fun, too.

We look forward to your participation!

Steve Hilker
Toad World Admin

Hi, In the spotlight on oracle predictive diagnostics what is the difference between active connections and connected connections? I’ve always looked at is as active are just that, running sql and connected can be connected but idle. The diagnostics seems to make no distinction, however they are different items on the drop down. both say I will run out of memory with 117 connections. I have over 2k and have no issues. The database server is a DL580, 40 CORES and 500GB RAM. any ideas?


Should say connected sessions.