Home » SQL & PL/SQL » SQL & PL/SQL » does execute immediate create a new connection?
does execute immediate create a new connection? [message #670069] Fri, 01 June 2018 12:11 Go to next message
gunderj
Messages: 17
Registered: April 2016
Location: California
Junior Member
Does execute immediate create a new connection? I think not, but I have a situation where v$session is showing connections that I cannot explain. They timeout after a while, so if our dynamic (execute immediate) is causing this then I need to figure out how to close them. Thanks.
Re: does execute immediate create a new connection? [message #670070 is a reply to message #670069] Fri, 01 June 2018 12:26 Go to previous messageGo to next message
BlackSwan
Messages: 26730
Registered: January 2009
Location: SoCal
Senior Member

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide

Please do NOT tell us what you think you see.
SHOW us using COPY & PASTE.

Explain why they are a problem that needs external intervention.
Re: does execute immediate create a new connection? [message #670072 is a reply to message #670069] Fri, 01 June 2018 13:48 Go to previous message
Michel Cadot
Messages: 67303
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Does execute immediate create a new connection?
No unless you reach another db using a database link.

Previous Topic: Oracle.ucp.jdbc.HarvestableConnection error
Next Topic: Multiple tables joining
Goto Forum:
  


Current Time: Fri Aug 14 06:43:01 CDT 2020