Oracle 11g, windows server2008
Hi
How can I find out which table columns used a sequence in my database (in past 2 or 3 days for example)
This is needed because the sequence increments by 1 BUT while doing a query on table column which use this sequence, it was found that large gaps are being produced in between the numbers in the table column using this sequence.
The cache is 20 .
We dont need consecutive numbers, just curious why the sequence is producing bigger gaps than expected.
What are the reasons for the sequence cache being cleared, other than shutdown,rollback&export/import of the database?
The gap is not uniform , sometimes there is a gap of 20.. sometimes 17 or 100, i.e uneven numbers with no pattern..and while searching the codes,packages etc, to see where the sequence is being used, its only this one table column but there culd be some other column using this, so would like to know that and that could be the reason why the sequence is having large gaps like this.
(E.g. for producing a 100 records, it used 1000 numbers etc..)
Thanks very much