to find last number generated for sequence object

[slimdave]

You can avoid the problem by changing the sequences as follows:

ALTER SEQUENCE XXX NOCACHE;

I'd say "disable the feature" rathr than "avoid the problem", since in doing so you are potentially ruining your system performance.