| Block Size [message #92895] |
Mon, 28 January 2002 01:35  |
Nav
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  |
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 |
veera
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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
