Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: selecting from an Object View starts a transaction???
Read consistency ?
"Carlo Sirna" <carlo.sirna_at_digisoft.it> wrote in message
news:b69nbt$1uus3$1_at_ID-135096.news.dfncis.de...
> Hi!
>
> I have an object view called v_banca.
>
> I have noticed that every time I access this object view oracle
> (8.1.6) does start a transaction.
>
> take a look at this example:
>
> SQL> select sys.dbms_transaction.local_transaction_id from dual;
> LOCAL_TRANSACTION_ID
> --------------------
>
> (there is no active transaction id, but if I try to access this object
> view...)
>
> SQL> select count(*) from v_banca;
> COUNT(*)
> ----------
> 3
>
> SQL> select sys.dbms_transaction.local_transaction_id from dual;
> LOCAL_TRANSACTION_ID
> --------------------
> 16.1.7453
>
> A new transaction has started... I understand that there could be a
> good reason for this... but I can't really focus it...
> Does anybody have an explaination for this?
>
> Thanks,
> Carlo Sirna
>
>
Received on Mon Mar 31 2003 - 09:55:28 CST