Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can two sessions be bound in Oracle ?

Re: Can two sessions be bound in Oracle ?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 21 Oct 2003 10:40:38 +0100
Message-ID: <3f94ff18$0$246$ed9e5944@reading.news.pipex.net>


I don't believe that there is any similar feature. However the likelihood of you actually needing it is pretty remote given the different locking mechanism between the two systems. Perhaps you could give an example of why you think you would need it?

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"ben brugman" <ben_at_niethier.nl> wrote in message
news:3f94fd54$0$248$4d4ebb8e_at_read.news.nl.uu.net...

> Can Oracle coordinate two or more connections, to prevent lock and
deadlock
> situations between two 'friendly' connections. For example one application
> having two connections but not wanting locks between them.
>
> Similar to :
>
> From the Books on Line from SQL-server :
> "
> Bound connections allow two or more connections to share the same
> transaction and locks. Bound connections can work on the same data without
> lock conflicts. Bound connections can be created from multiple connections
> within the same application, or from multiple applications with separate
> connections. Bound connections make coordinating actions across multiple
> connections easier.
> "
>
> thanks for your attention,
> ben brugman
>
>
Received on Tue Oct 21 2003 - 04:40:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US