DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Creating Sequances in Oracle

  1. 09-18-2002, 04:20 AM #1
    rajasg_200
    rajasg_200 is offline Junior Member
    Join Date
    Sep 2002
    Posts
    1

    Question

    If i want create 30 to 40 sequacnes in oracle , is there any perforamance difference ..because sequances will be loaded in to cache memory in oracle.
    as i want to create 30 different sequences in next project.
    If so please explain why?
    Thanks in advance
    Reply With Quote Reply With Quote
  2. 09-18-2002, 06:25 AM #2
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    As long as you "Keep" them in the buffer pool, it should not be a problem.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Reply With Quote Reply With Quote
  3. 09-18-2002, 06:50 AM #3
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    shared pool just in case
    Reply With Quote Reply With Quote
  4. 09-18-2002, 07:02 AM #4
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Oops!
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Reply With Quote Reply With Quote
  5. 09-18-2002, 07:38 AM #5
    prakashs43
    prakashs43 is offline Senior Member
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    creating sequences depends on business application
    if u want to create a sequence which should be acessed faster then go for caching , but it consumes RAM ans saves time in getting the next value .
    if u want to create a sequence which is rarely used then , it could be placed in shared pool and pinned using DBMS_SHARED_POOL.KEEP procedure in order not to skip any numbers .
    siva prakash
    DBA
    Reply With Quote Reply With Quote
  6. 09-18-2002, 07:40 AM #6
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hmm if it´s reraly used why should it place it in memory...?
    that´s waste of memory
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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