Re: Question on ASM LUN size and adding datafiles
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: <riyaj.shamsudeen@xxxxxxxxx>
- Date: Sun, 21 Nov 2010 10:05:20 +0100
Riyaj Shamsudeen pisze:
> Kumar
>
> 2. If you know how much you need, it is better to allocate ahead of time.
> Autoextending has *some* amount of overhead (but not too much as long as you
> keep meaningful extend size). Autoextend also updates the file headers, and
> you can run in to concurrency related to issues in the file header block if
> there are many processes constantly trying to extend the files.
>
I may add something concrete for allocating before.
On 9i if IO subsystem is slow/highly loaded/etc there were problems with
application working - some statements fail with error about lack of
free space, while every file was set to auto-extensible.
The best solution was to allocate earlier.
So even if this is not a problem in let's say 10g, I would name it a
good practice anyway. In the end the space will be allocated anyway and
You may choose the time, when this is done.
Regards
Remigiusz
--
Pole nakazi
----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
pos : DBA at DIiUSI
addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod numerem:
0000021828,
dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku,
VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego,
o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych,
NIP: 586-000-78-20, REGON: 190024711
--
//www.freelists.org/webpage/oracle-l
Other related posts:
