1 Reply Latest reply: May 11, 2013 2:56 AM by Alvaro RSS

    public database link vs  shared publicdatabase link

      Hello to all ;

      I know very well about public database link.
      I want to create shared public database link (two databases in same host).

      My question is

      How it is *( shared public database link )* different from public  database link ?

      Shared => what exactly it does between databases ?

      Thanks in advance ..

      Edited by: 969352 on May 11, 2013 12:38 AM
        • 1. Re: public database link vs  shared publicdatabase link
          Shared Database links enable multiple sessions on the source database to share the same connection to the target database, much like a 1:n relation that is present in an shared server configuration between server processes and user processes.

          They differ from regular DBLINKS in that way, Regular DBLINKS will create a connection on the target database for every session that uses the DBLINK on the source, it's a 1:1 relation.

          Please read: http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_admin003.htm