you are not the only one flushing shared pool, the kernel does that internally too!
Printable View
you are not the only one flushing shared pool, the kernel does that internally too!
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.
hi v$_sequences, is not available , i checked.
how to create that is there any built in script?
Quote:
Originally Posted by JChiappa
You need to do an explicit grant select to the schema owner for it to be available. :rolleyes:Quote:
Originally Posted by madhugp