something very strange

[shawish_sababa]

Hi LND



exept for looking at the code itself (wich is warped) is there a way to find out that i have a row inserted in a serializeble mode?

looking at the documentation i see no way of that.

[sambavan]

Wrong Advise : Removed by Editor

[Edited by uday on 03-09-2001 at 05:48 PM]

[jmodic]

Sam,

Again I think that async operations have nothing to do with that. Once the transaction is commited both users have to read that row from the same buffer from cache, no matter how data is written to disks.

I think LND has pointed to more likely couse of this mistery.

[LND]

serializable mode is not for inserts, it is for reading:

a session in serializable mode does not see commits(i.e. commited data) done by other sessions.

The commands are
SET TRANSACTION ISOLATION_LEVEL SERIALIZABLE and
SET TRANSACTION ISOLATION_LEVEL READ_COMMITTED

The mode is valid until transaction ends(commit, rollback, ddl). The SET TRANSACTION must be first statement of transaction (after lastcommit, rollback, ddl)

Exception is if all instance is running in serializable mode (quite hard to believe). Check init.ora parameters (isolation_level I believe)

[sambavan]

Jurij, LND, thanx for fixing my missconceptions. Guss what? I'm still learning.

That was one good piece of information. :D

Sam

[akkerend]

You can set the isolation level for a transaction (with SET TRANSACTION) and for a session (with ALTER SESSION).
If INIT.ORA parameter SERIALIZABLE is set to TRUE the isolation level is set to SERIALIZABLE for the instance. Oracle recommends not to change the default value (FALSE) for the SERIALIZABLE parameter. It is provided for sites that must run in ANSI/ISO compatible mode, or that want to use applications written to run with earlier versions of Oracle.

[shawish_sababa]

Hi guys


first of all, i think i'm crazy becous this is me weekend and i'm reading your answers at home... thank you all and i have to say that not only sambavana is the one stuying hear.

any way, i have to get back to the office to be able to get to check on all of your advices. just whanted to let you know that i'm not answering you all becouse thwe db is far away.

[shawish_sababa]

Hi guy's

dont know why, but everything is o.k. now!

thank you all again