Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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 CDT