| database sizing of different size [message #63352] |
Tue, 28 September 2004 21:10  |
Jay
Messages: 127
Registered: October 1999
|
Senior Member |
|
|
Hi All,
I have to do a oracle database sizing for windows/UNIX.
I have absolutely no inputs from the client, just a rough
guidleline.
I need to make a sizing document for 3 catagories of db's:-
Small db (>1gb), medium db (>10gb) and a large db (>100gb).
The following parameters would need to be put in the document for
these 3 db catagories:-
>Memory (RAM) reqd?
>SGA size?
>Shared pool size?
>large pool?
>java pool?
>db buffers?
>redo size?
>rbs size?
etc etc.
If someone of you could help me out, that would be great.
Thanks,
Jay.
|
|
|
|
| Re: database sizing of different size [message #63361 is a reply to message #63352] |
Wed, 29 September 2004 06:23  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
You can use the values supplied for SMALL/ MEDIUM and LARGE as listed in the default INIT.ORA file as guideline:
db_block_buffers = 100 # SMALL
# db_block_buffers = 550 # MEDIUM
# db_block_buffers = 3200 # LARGE
shared_pool_size = 3500000 # SMALL
# shared_pool_size = 5000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
...
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
