RE: tabs, connections, and resulting sessions from sqldeveloper

Each connection results in 2 actual connections.  

One for reports, the browser/tree, and the worksheet.  

A second one for bg queries used to power things like the Insight feature in the SQL Workheet.  

If you open an 'unshared' worksheet to a database - it opens a private connection for just that worksheet that the rest of the product doesn't have access to. I'm not sure if unshared worksheets also get the 2nd connection for insight feature. But with unshared worksheets, each additional worksheet would result in an additional connection.  

From: Mark W. Farnham [mailto:mwf_at_rsiz.com] Sent: Wednesday, June 14, 2017 9:04 AM
To: ORACLE-L <oracle-l_at_freelists.org> Subject: tabs, connections, and resulting sessions from sqldeveloper  

Anyone, but Jeff it you're lurking in particular: Is there a simple document summarizing the relationship of database connections, tabs, running queries, and so forth from sqldeveloper to the number of sessions created and held?  

(Hint: I'm looking for something shorter than reading the entire concepts guide. The target readership is impatient, would be well-served by reading the entire concepts document, but that is unlikely to happen.)  

mwf

--
http://www.freelists.org/webpage/oracle-l