Home » RDBMS Server » Server Administration » Database Physical Layout.
Database Physical Layout. [message #423011] Mon, 21 September 2009 16:12 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Dear All,

We are considering of building a database to be primarily used for datawarehousing. We need to know more about the physical layout: what type of raid configuration for the data files, what should be the ideal size of LUNs, and how much space to allocate for the FRA, how big should be the size of the redologs etc. The database size we are estimating now would be between 1 to 1.5TB. Any suggestion, direction, advise would be highly appreciated.

Thanks.
Re: Database Physical Layout. [message #423222 is a reply to message #423011] Tue, 22 September 2009 16:51 Go to previous message
venucsit
Messages: 2
Registered: September 2009
Junior Member
It may not always be possible to provide a specific size recommendation for redo log files, but redo log files in the range of a hundred megabytes to a few gigabytes are considered reasonable. Size your online redo log files according to the amount of redo your system generates. A rough guide is to switch logs at most once every twenty minutes.

RAID 0+1 (Sometimes called RAID 10
Previous Topic: ORA-600 [kkdlReadOnDiskDefVal: error]
Next Topic: Oracle Scheduled Jobs.
Goto Forum:
  


Current Time: Mon Sep 26 11:10:22 CDT 2016

Total time taken to generate the page: 0.06731 seconds