Home » RDBMS Server » Server Administration » reconstruct the database.
reconstruct the database. [message #237556] Mon, 14 May 2007 21:03 Go to next message
Messages: 50
Registered: December 2006
Location: bangalore
hi to everyone,

i am pavan, working as a Jr dba.i am facing one problem. for one server i need to reconfigure the server.

my query is how much size can i allocate for below parmeters.
it is a telecom project

1.data is comming to the server is 1 to 2 gb per day.
2.i need to have 4 tablespace
3.system ts
4.sysaux ts
5.undo ts.
6.user data ts
7.i have 1 gb ram
8.size of SGA
9.size of pga
10.db buffer size
11.large pool size
12.redolog buffer size
13.redolog file size
14.temp ts size.

i want to create new database and i need to export entire data in the present server. present my db size is 20 and i am expecting 2 gb of data every day.

i dont have othere application on same server.

my questions is what is the idel size of above parameters.
my db should support for minimum 10 years.
my os is sun solaries.

could you please give me above sizes or any document regarding this issue.

it is very urgent. i need to complete this task with in 5 working days.
please help me to sort this problem..
Re: reconstruct the database. [message #237907 is a reply to message #237556] Wed, 16 May 2007 02:04 Go to previous message
Messages: 27
Registered: April 2007
Location: Chennai, INDIA
Junior Member
Well, How many concurrent connections do u expect during peak load? u need to start with some approximate value and the size the values according to your application over the time.

To start with follow the below calculation:

Allocate 3MB - 5MB per concurrent connection. For eg.
If there are 400 concurrent conns during peak load, then size SGA as 400*5MB (this is just to start with). Enable adviser to size correctly.

Data TBS size could be 20Gb initially and then could be sized accordingly.

PGA - May be all free memory available to the server initially. Can be sized using STATS PACK report.

Large pool - set to very low unless u run ur db as shared server or use RMAN.

Log Buffer - Depends upon no of concurrent transactions. Initially 10MB is fair.

Redo log file size - 100MB to start with. Look for log swich alerts in alert file to go for bigger size.

This should help u to start the show.

All the best.
Previous Topic: faq
Next Topic: Questions
Goto Forum:

Current Time: Thu Oct 27 06:35:54 CDT 2016

Total time taken to generate the page: 0.32826 seconds