Re: "SET TRANSACTION READ ONLY" / "SET TRANSACTION USE ROLLBACK SEGMENT"

[Ronald J Kimball]

On Fri, Aug 17, 2001 at 12:26:29PM -0400, Hugo A. Gonzalez F. wrote:
> O.K.
> 
> Excuse my ENGLISH, but i try to tell to you my problem, if any body can
> undestand in spanish and can translate to english "best".
> 
>     I use this sentences: " Set Transaction read only " / "Set transaction
> use rollback segment  " , in perl's progrmas, but still use any
> rollback, and my idea is that use none or one in exclusive, from PERL.

Okay...  Hugo is doing Set Transaction statements that should change how
his queries use rollback segments, but the behavior of his queries isn't
actually changing.


Have you turned off AutoCommit?  With AutoCommit on, I think that the Set
Transaction will last only for the duration of the Set Transaction
statement.

You can turn off AutoCommit when you connect:

  $dbh = DBI->connect($dsn, $username, $password, { AutoCommit => 0 });

or sometime after you connect:

  $dbh->{AutoCommit} = 0;

Also, after you call $dbh->commit(), I think you will need to do the Set
Transaction statement again.


> The version is ORACLE 8.1.7, and PERL 5.003.

Are you really using perl5.003, or did you mean perl5.005_03?  perl5.003 is
quite old.


I hope that's helpful!

Ronald

"SET TRANSACTION READ ONLY" / "SET TRANSACTION USE ROLLBACK SEGMENT"

[Hugo A. Gonzalez F.]

O.K.

Excuse my ENGLISH, but i try to tell to you my problem, if any body can
undestand in spanish and can translate to english "best".

I use this sentences: " Set Transaction read only " / "Set transaction
use rollback segment  " , in perl's progrmas, but still use any
rollback, and my idea is that use none or one in exclusive, from PERL.

The version is ORACLE 8.1.7, and PERL 5.003.


One more time: excuse my english, i promise to you be better about
this.

Thanks,

Hugo Gonzalez.

--- 0 -


> Buenos Dias:
>
> Utilizando ORACLE 8.1.7 y PERL 5.003
>
>Al utilizar sentencias en PERL : " Set Transaction read only " / "Set
> transaction use rollback segment  " , y no lo aplica en el programa
> donde lo utilizo, Y por supuesto siempre termina con "SNAP SHOT TOO OLD
> "
>
> Hugo Gonzalez.

"SET TRANSACTION READ ONLY" / "SET TRANSACTION USE ROLLBACK SEGMENT"

[Hugo A. Gonzalez F.]

Buenos Dias:

Utilizando ORACLE 8.1.7 y PERL 5.003

   Al utilizar sentencias en PERL : " Set Transaction read only " / "Set
transaction use rollback segment  " , y no lo aplica en el programa
donde lo utilizo, Y por supuesto siempre termina con "SNAP SHOT TOO OLD
"



Hugo Gonzalez.