Raw partitions and Nr of datafiles

[posted and mailed]

Hello,

I have a unix server with a raw partition configuration. My idea is to configure all partitions as 100 MB so I'm maximal flexible to allocate these pieces to tablespaces of different sizes.

I mean, when I need 3 GB I will alocate 30 chunks of 100 MB. When I need a TS size of 300 MB I will allocate 3 chunks.

The reason for this approach is that when I have for example chunks of 500 MB and I need 100 MB for a table space I will have an overhead of 400 MB!!!!

Can anyone tell me if there are any real disadvantages when I choose 100 MB raw partitions (and not a mix of 100 MB, 500 MB and 1 GB). Is there a performance issue or another limitation?

I like to get some answers of you.

BYeeeee

Greeting from Holland,

Mike. Received on Wed May 17 2000 - 00:00:00 CEST