sys.seq$ table

[ngupta15]

Its a weird problem but let me explain....

One out of 130 sequences in my DB is getting updated very frequently almost 5000 values every min.

i tried to find any statement accessing that seq but there is nothing in v$SQLAREA or v$SQLTEXT.

It was generating huge log so I changed default to cache value to 5000, so has reduce the log generation but the statement :

update SYS.SEQ$ set INCREMENT$ = 1, MINVALUE = 5, MAXVALUE = 9999999999999999999999999999, CYCLE# = 0, ORDER$ = 0, CACHE
= 20, HIGHWATER = 1764451042, AUDIT$ = '--------------------------------' where ROWID = 'AAAAA9AABAAAAC7AAf';

still running (I got this from archive log using logminer)....

I'll appreciate your help

Thanks,
Naresh

[ngupta15]

anybody on the forum knows about this kind of seq problem.....