commit after select ???

From: Markus Albert <Markus.Albert_at_cern.ch>
Date: 1997/11/03
Message-ID: <345D7570.BC769778@cern.ch>

--------------05EBC64D6E9D3C7E78A42C59
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi everybody,

I have a problem with rollback segments. We use ORACLE server 7.3.3.0 and have a database link from instance A to

instance B. The applications connected to A and reading data (with SQL select statement)
from tables/views from B, via the database link, have to commit in order not to fill
up the rollback segments.
For me this looks quite strange but I have been told that it is a means of security,
because the server doesn't know what else is being done over this link (eventually inserts, updates...).

Is there a way of getting around this problem without including commit - commands after
those database link queries ???

Thanks for any help !

Bye, Markus.

        |||
        o-o
*---ooO--|--Ooo-------------------------------------*
|                                                   |
|   CERN European Laboratory for Particle Physics   |
|                                                   |


 *---------------------------------------------------*

|              Markus Albert  (SL/OP)               |
|                                                   |
| mail : SL Division, CERN, CH-1211 Geneva 23       |
|        Switzerland                                |
| Tel. : + (4122) 767 5138,5534,7500                |
| Fax  : + (4122) 767 8570                          |
| email: Markus.Albert_at_cern.ch                      |

| WWW : http://wwwcn.cern.ch/~malbert/Welcome.html |
*---------------------------------------------------*

| "La plus perdue de toutes les journees est celle  |
|  ou l'on n'a pas ri."                             |
|                              Nicolas de Chamfort  |
*---------------------------------------------------*



--------------05EBC64D6E9D3C7E78A42C59

Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

<HTML>
Hi everybody,

I have a problem with rollback segments. We use ORACLE server 7.3.3.0 and have a database link from instance A to
 instance B. The applications connected to A and reading data (with SQL select statement)
 from tables/views from B, via the database link, have to commit in order not to fill
 up the rollback segments.
 For me this looks quite strange but I have been told that it is a means of security,
 because the server doesn't know what else is being done over this link (eventually inserts, updates...).

Is there a way of getting around this problem without including commit - commands after
 those database link queries ???

Thanks for any help !

Bye, Markus.
<PRE>
        |||         o-o

*---ooO--|--Ooo-------------------------------------*
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |

|   CERN European Laboratory for Particle Physics   | |                                                   |
*---------------------------------------------------*

|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Markus Albert&nbsp; (SL/OP)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;
| mail : SL Division, CERN, CH-1211 Geneva 23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Switzerland&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
| Tel. : + (4122) 767 5138,5534,7500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
| Fax&nbsp; : + (4122) 767 8570&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
| email: Markus.Albert_at_cern.ch&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
| WWW&nbsp; : http://wwwcn.cern.ch/~malbert/Welcome.html |


 *---------------------------------------------------*

| "La plus perdue de toutes les journees est celle&nbsp; |

|  ou l'on n'a pas ri."                             | |                              Nicolas de Chamfort  |

*---------------------------------------------------*</PRE>

</HTML>

--------------05EBC64D6E9D3C7E78A42C59-- Received on Mon Nov 03 1997 - 00:00:00 CST