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

Thread: Unix Server Strong Enough?

  1. #1
    Join Date
    Feb 2001
    Location
    Belgium, Sint-Truiden
    Posts
    82

    Question

    Fellow Oracle-lovers,

    as I'm only a DBA for 2 months and my experienced collegues left me :-((((, I have the following question.

    They (the people who earn a lot more than me) asked me to install 11 db's (4 with lots of data, needs to perform bulk statements, all the others just to test SQL-statements) on a new server that was purchased.
    The question of the bosses is if this machine will be powerfull enough to have a good performance , but actually I've no idea.

    The servers specifications: Unix with ULTRA SPARC 400 Mhz processor, 1 GB RAM and 4* 9 GB HD).
    We'll use Oracle 8i Standard Edition.

    If anyone has an idea (f.i. 400 Mhz Ultra Sparc should be as fast as a 1200 Mhz Intell (if you can compare them)), please let me know, as I'm desperate...

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    11 instances...? or one instance with 11 tablespaces, each tablespace for one application.
    If it was 11 instances I doubt it you have enough RAM, you prob need at least 2GB and assign more sga for those with bulk statements
    We have a machine with similar configuration but with 2 450MHZ CPUs and currently it has two instances which uses around 550MB RAM for SGA but none of the instances are for production, one is for testing (pre-production) and the other is for development. Well it really depends what do you want to do with those 11 instances

  3. #3
    Join Date
    Feb 2001
    Location
    Belgium, Sint-Truiden
    Posts
    82
    Pando,

    I've checked one of our big DB's and if I use the following algoritm for the SGA
    SGA = shared_pool_size + large_pool_size + log_buffers + (db_block_size * db_block_buffers) + java_pool_size.

    I find 342 Mb of SGA-size. Now I think that this is not all physically needed, but still we have probably 2 of these and the rest of them are smaller.

    For me I'ld like to purchase another GB, but offcourse I don't rule the budget... ;-)

  4. #4
    Join Date
    Feb 2001
    Location
    Belgium, Sint-Truiden
    Posts
    82
    I forgot to mention that it are really 11 instances...

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    sorry to hear about your story i wish you do some basic dba reading to understand oracle terminlology you are talking about running 11 instance rember oracle reccmmends atleast 256 mb of ram per instance for any productiuon work and simple airtmatic of multiplying that by 11 would require 2816 mb or approx 3gb .1 gb wont suffice.

    hope that you would pick up dba skills quickly even i was in a similar situation couple of months ago.

    btw that much memory is required bcoz a instance always runs in a memory while a databse from the hard disk


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