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

Thread: installing a new instance correctly

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    installing a new instance correctly

    Hi,
    I’m installing a new oracle instance with Database Configuration Assistant, but I’d like to know if I installed correctly.
    My O.S. is windows 2003 server with 1 Gb Ram and Oracle 9.0.1 version.
    May be max 15 user connecting simultaneity

    I installed Oracle with this parameters:
    Tamplate Name= DataWarehouse
    Dedicated Server Mode

    Memory Custom:
    Shared pool=33554432 bytes
    Buffer cache=32mbytes
    Java pool=33554432 mytes
    TOTAL=96Mbytes

    Memory Typical:
    Max n. of users=20
    Percentage of physical memory(511mb) for oracle=70 (my machine has 1gb ram, must I increase this value here or is not important??)
    Shared pool=94mb
    Shared pool=183mb
    Java pool=50mb
    Larged pool=10mb
    PGA=20mb
    TOTAL=357
    Sort area size=1048576 bytes
    In the init.ora SGA_MAX_SIZE=139232672
    I CHOOSE TYPICAL INSTALL

    How can I know if my database is installed correctly and which parameter I’d change?

    Thanks
    Raf

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    does it start?

    only you know who much memory you need for each part of the sga because you have properly sized it and you know what your application is going to do?

    Also you say at the start 15 Users then say later 20 users

    then you say this

    Shared pool=94mb
    Shared pool=183mb, whats it to be?

    20mb for pga_aggregate_target seems a little mean as well

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Was your Oracle Software Installation Successful ?
    Did you create database after software installation ?
    Last edited by SANJAY_G; 02-04-2004 at 07:03 AM.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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