to find last number generated for sequence object - Page 3
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,026
    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.
    this space intentionally left blank

  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,026
    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.
    this space intentionally left blank

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