sysdate as indexed column
Hello
I have table for debug
create table DBG
(
tag VARCHAR2(4000),
data VARCHAR2(4000),
changedate DATE,
execs VARCHAR2(4000),
lasterr VARCHAR2(4000)
)
and index on changedate
create index IDX_CHANGEDATE on DBG (CHANGEDATE)
tablespace IDX_DATA
pctfree 10
initrans 10
maxtrans 255
storage
..
so and time to time i have situation when applications (about 20-30 instances application) begin insert in same time.
I get enq: TX - index contention
And very slowly insert
So i increase initrans for index to 30 now . But i'm interesting : if i make this index reverse is it resolve problem with " enq: TX - index contention"
By the way: there is no sequences when insert.