ORA-08177- serialize error

[zeeshan]

Hi
I have Oracle 9i version 9.0.1.1.1 running on windows 2000 server.

We are using Developer 6i as Front end.

When my clients try to insert or update record in some table an error
occurs.


ORA-20006: ORA-20001: ORA-08177: can't serialize access for this transaction

ORA-04088: error during execution of trigger


I am using serializable transactions.

Someone told me that if I increased the initrans of the table being
effected by those sql, this will solve the prob.

Also I added this parameter in the init.ora file

[B] DELAYED_LOGGING_BLOCK_CLEANOUTS=FALSE [B]

But the error is still occuring.

What am I doing Wrong. Can anybody plz tell me something which could be helpful.

Its very urgent I really need Help.

[sysdba]

I remember it was discussed not long time ago.
Do a search on this forum.

[zeeshan]

Thanx for replying.

I did try the search but can u plz give me some info about it.

I'll really appreciate it.

[stancho]

Originally posted by zeeshan
I am using serializable transactions.

offtopic - why are you using serializable transactions?

[zeeshan]

Sorry for Late Reply.

Well we use Serializable transaction for no reason.
The Database had already been running when I took over.
The Transaction type is serializable.
I have changed this to read Committed but the prob is still
here.

Any Ideas!