|
-
what size of db_block_size should I use when building a datawarehouse db?
Hi,
I'm new to data warehouse db. The current data warehouse db size is 300gig which has the db block size of 4kb which I think it is small and not sure why the privious dba build the small size of the db. I got assign to build the new datawarehouse db which I'm not sure should I build with 8kb or 16k block size based on the size of 300gig+ db so I can export the current db and import to the new db.
Any suggestion is greatly appreciate it.
Trina
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|