Another Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Another Database

  1. #1
    Join Date
    Nov 2000
    Posts
    157
    Hi ALL

    My oracle734 database (production) is running on NT4.0

    I have a database(production) on server1

    Now I have to create another database on the same server with different parameters.The old one also should exist.

    PARAMETER OLD NEW

    db_files 20 45

    db_block_buffers 20000 25000

    db_block_size 2k 4k

    shared_pool_size 120mb 120mb


    The RAM on server is :785,824 kb

    Is it ok to create another database on the same server with this much of RAM.What other factors i have to consider?Please let me know.

    Thanks
    Ravi
    ravi

  2. #2
    Join Date
    Feb 2001
    Posts
    66
    I think somebody said here that is ok to have a shared_pool_size <20% of the ram, now if you consider the second db, in the seem logic, <10% of server ram must be ok

  3. #3
    Join Date
    Nov 2000
    Posts
    157
    could you please more explicit about this.Really i didn't get any idea from this.Is it ok to create another database with the RAM on server i specified.

    Thanks
    ravi
    ravi

  4. #4
    Join Date
    Feb 2001
    Posts
    66
    my personal opinion is that 120Mo, for the two servers is the highest you can figure out for each db, so you ok.
    You must pay attention to not outrun the real memory of the machine, so to avoid the disk swaping.

    Anyways, you can issue:

    Select bytes/1024/1024 from v$sgastat where POOL='FREE MEMORY';

    If this value is consistently high over time, another area of SGA needs memory, you may want to decrease SHARED_POOL_SIZE.

    [Edited by m_d_marian on 03-07-2001 at 12:57 PM]

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