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.

Report message to a moderator

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: 26766
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.

Report message to a moderator

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: 68641
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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 16:42:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.