Smallest Oracle 9i Instance for a single User
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Smallest Oracle 9i Instance for a single User

  1. #1
    Join Date
    May 2002
    Posts
    2

    Question

    Hello,
    i am Junior "DBA", and my Company is using an Oracle 9i and Remedy Action Request System.
    For testing on my Notebook i search for a minimum Sized Oracle Instance for a Single User System.
    The Action Request System needs only a Oracle Instance without any spatial etc.
    Is it possible to create a small Instance with a smaller Systemtablespace than 250 MB , the Undotbs with 200 MB or the Redo Log Groups with each 100 MB ? Is it possible to get a Script ?
    By the way, sorry for my bad or incredible Englisch ... But i try to give my verry best :-)))
    Thank you


    Andreas

  2. #2
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Based on my understanding on the earlier version of oracle , you need not to have a so big redo log file in 100 MB .
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    I've got Oracle9i Release II running on an old laptop. I used a 4M for the shared pool and the buffer cache. You can definitely reduce the size of the redo logs. Try 1M to start with. The undo tablespace can be below 100M provided you're not doing loads of work requiring undo. Also, the system tablespace can drop down to about 70M provided you don't pick all the optional features.

    To get a script, start the Database Configuration Assistant and pick a custom install. Reduce the size of all the files to values you find acceptable. Remember to uncheck all the extra features or your system tablespace will end up at about 260M. At the end of this process choose to save the creation scripts rather than run them immediately. You then have a set of scripts you can adjust as you wish.

    Some of the extra options require quite a bit of memory to load. If you pick these you will need to allocate quite a bit of memory to the shared pool, large pool and java pool.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  4. #4
    Join Date
    May 2002
    Posts
    2
    thank you,
    is it possible to change the size of the redo on a created Instance ?


    Andreas

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