Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Raw partitions and Nr of datafiles
Yes there are a lot of disadvantages to that, two big ones are:
All our databases are raw, and we construct them on an as needed bases. It is a little more work, but you will really want to take advantage of the flexibility of raw partitions if you are going to go through the effort to do it.
P.S. Use some sort of tool to lay them out, veritos is a great tool for the job if you have access to it.
-- Robert Fazio, Oracle DBA rfazio_at_home.com remove nospam from reply address http://24.8.218.197/ "Mike_nl" <Mike_nl_at_dds.nl> wrote in message news:8F37DC21CMikenlddsnl_at_212.120.66.201...Received on Thu May 18 2000 - 00:00:00 CDT
> [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.