to find last number generated for sequence object

[pando]

you are not the only one flushing shared pool, the kernel does that internally too!

[gandolf989]

The only time that I really care about the last sequence is when I do an insert. And if I insert a new value with a sequence, and I care what the number is, then I use the returning clause. All this talk about gapless sequences reminds me of the posts about number of extents per table/index.

[madhugp]

hi v$_sequences, is not available , i checked.
how to create that is there any built in script?

One can use v$_sequences , as said by HJR in http://www.dizwell.com/prod/node/59

Regards,

Chiappa

[gandolf989]

hi v$_sequences, is not available , i checked.
how to create that is there any built in script?

You need to do an explicit grant select to the schema owner for it to be available.