Home » Developer & Programmer » Data Integration » Block Size
Block Size [message #92895] Mon, 28 January 2002 01:35 Go to next message
Messages: 1
Registered: January 2002
Junior Member
Does anyone know the typical size of the db_block_size for an Oracle Warehouse?
Also where would i get some information on the physical layout of files/tablespaces/redo logs, etc..etc... for an Oracle Warehouse, as this would be different to an OLTP system.
Re: Block Size [message #92896 is a reply to message #92895] Mon, 28 January 2002 06:12 Go to previous messageGo to next message
Ajay Gandhi
Messages: 14
Registered: January 2002
Junior Member
Try 32K. That would speed up the performance. I would suggest using OFA (optimal flexible architecture) for datafile layout. It all depends on how your disks are organized, ie. striped, RAID ??

Re: Block Size [message #92903 is a reply to message #92895] Thu, 14 February 2002 01:58 Go to previous message
Messages: 5
Registered: February 2002
Junior Member
As per my experience,in data warehouse project use above 8k Block size(16K or 32K).
Becase your table full scan is very fast.
And I suggest this value mainley depends on my environment(RAM,Disk space).
Previous Topic: searching for job in DW
Next Topic: Fastest method for creating indexes
Goto Forum:

Current Time: Thu May 23 10:05:28 CDT 2024