=========================================
CREATING DB_LINK SESSIONS ON COSKAN
=========================================

16:23:21 COSKAN >
16:23:41 COSKAN > select * from dual@LINK_1;

D
-
X

=========================================
SAME TIME ON LINK_1
=========================================
16:23:57 LINK_1 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

       SID STATUS   
---------- --------
        12 INACTIVE 

=========================================
ON COSKAN  ---open LINK_2
=========================================
16:23:44 COSKAN > select * from dual@LINK_2;

D
-
X

=========================================
SAME TIME  ON LINK_2
=========================================
16:24:24 LINK_2 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

       SID STATUS   
---------- --------
        13 INACTIVE 

=========================================
ON COSKAN ---open LINK_3
=========================================
16:24:13 COSKAN > select * from dual@LINK_3;

D
-
X
=========================================
SAME TIME  ON LINK_3
=========================================
16:24:55 LINK_3 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

       SID STATUS   
---------- --------
        11 INACTIVE 

=========================================
ON COSKAN ---open LINK_4
=========================================
16:24:40 COSKAN > select * from dual@LINK_4;

D
-
X
=========================================
SAME TIME  ON LINK_4
=========================================
16:25:17 LINK_4 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

       SID STATUS   
---------- --------
        64 INACTIVE 

=========================================
COSKAN  -----now another db_link as 5th LINK_5
=========================================
16:25:09 COSKAN > ---now another db_link as 5th
16:25:47 COSKAN > select * from dual@LINK_5;
select * from dual@LINK_5
                   *
ERROR at line 1:
ORA-02020: too many database links in use

=========================================
ON COSKAN -----Try to close the LINK_1
=========================================

16:25:51 COSKAN > 
16:26:11 COSKAN > alter session close database link LINK_1;
ERROR:
ORA-02080: database link is in use
=========================================
SAME TIME SESSION ON LINK_1 --session is alive
=========================================
16:26:25 LINK_1 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

       SID STATUS   
---------- --------
        12 INACTIVE 
=========================================
ON COSKAN ---try to do a commit
=========================================

16:26:34 COSKAN > 
16:26:44 COSKAN > commit;

Commit complete.
=========================================
SAME TIME SESSION ON LINK_1   sesssion is still alive
=========================================
16:27:02 LINK_1 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

       SID STATUS   
---------- --------
        12 INACTIVE 
=========================================
ON COSKAN ----try to close the first link again
=========================================
16:26:46 COSKAN > 
16:28:38 COSKAN > alter session close database link LINK_1;

Session altered.
=========================================
SAME TIME ON LINK_1 ----session on is closed
=========================================
16:29:04 LINK_1 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

no rows selected

=========================================
ON COSKAN ---now add another db_link as 4th of new list
=========================================
16:28:41 COSKAN > 
16:29:53 COSKAN > select * from dual@LINK_5;

D
-
X
=========================================
SAME TIME ON LINK_5 
=========================================
16:30:48 LINK_5 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

       SID STATUS   
---------- --------
       488 INACTIVE 
==========================================
ON COSKAN  --open session for LINK_6
==========================================
16:30:04 COSKAN > ---now open session for link 6
16:31:30 COSKAN > select * from dual@LINK_6;

D
-
X
==========================================
SAME TIME ON LINK_4---sesssion is dead 
==========================================
16:32:08 LINK_4 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

no rows selected
==========================================
ON COSKAN --open session for LINK_7
==========================================
16:31:40 COSKAN > 
16:35:01 COSKAN > select * from dual@LINK_7;

D
-
X
==========================================
SAME TIME ON LINK_3---sesssion is dead 
==========================================

16:35:33 LINK_3 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

no rows selected

==========================================
ON COSKAN --- --open session for LINK_8
==========================================
16:35:08 COSKAN > 
16:42:25 COSKAN > select * from dual@LINK_8;

D
-
X

==========================================
SAME TIME ON LINK_2---sesssion is dead 
==========================================


16:43:30 LINK_2 > select sid,status from v$session  where machine='COSKAN' and username ='TEST'

no rows selected