PL/SQL (MOSC)

MOSC Banner

sysdate as indexed column

edited Mar 28, 2020 3:16AM in PL/SQL (MOSC) 3 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center