-
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.
-
how to view v$_sequence ( not available)
hi v$_sequences, is not available , i checked.
how to create that is there any built in script?
Originally Posted by JChiappa
-
Originally Posted by madhugp
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|