DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: to find last number generated for sequence object

  1. #21
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you are not the only one flushing shared pool, the kernel does that internally too!

  2. #22
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

  3. #23
    Join Date
    Jul 2006
    Posts
    96

    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?





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

    Regards,

    Chiappa

  4. #24
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote 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
  •  


Click Here to Expand Forum to Full Width