Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: transaction enqueue lock
Norm,
We did dat. export table, create table, import table, rebuild
indexes.
Gave the table and indexes intrans of= 2 maxtrans = 20, pctfree (from
20 ) to 40.
Ran 7 programs concurrently . Four go and three lock on the first
insert . As the blockers finish the locked get on. We have no
exclusive table locks. No two programs are modifying the same row.
Still get the enqueue transaction lock. Somehow being limited to four
tasks. We were thinking of going through this again but to set the
inittrans to 6 to see if we get an increase.
jonl
Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<E2F6A70FE45242488C865C3BC1245DA70280C480_at_lnewton.leeds.lfs.co.uk>...
> Hi Jon,
>
> did you export/drop/import the tables (and obviously the indexes) after
> setting the new value? If you didn't then only new blocks allocated to
> the table will have the extra slots !
>
> Cheers,
> Norman.
>
Received on Wed Aug 14 2002 - 14:01:43 CDT