Re: AWS EC2 image with ASM

oh sorry guys one more thing I just remembered - when you create the fs - we also used the su and sw parms - they may be calculated automatically..... but in any case - FYI.

mkfs.xfs -d su=256k,sw=4 /dev/mapper/tempvg-templv

su - stripe unit size

sw - stripe width

Alignment to the storage geometry is key here for maximum throughput basically.

Niklas Iveslatt
Senior Partner

Arisant LLC ~ http://www.arisant.com
44 Inverness Dr. E Bldg. C Suite 2 ~ Englewood, CO 80112 mobile: 303.882.4461 ~ main: 303.330.4065 ~ fax: 888.889.0155

  Need to send me something securely? *Click here* <https://arisant.sendsafely.com/u/niklas.iveslatt>

On Fri, Oct 27, 2023 at 11:15 AM Niklas Iveslatt < niklas.iveslatt_at_arisant.com> wrote:

> Yeah 1M:
>
> It is a DWH:
>
> db_block_size integer 16384
> db_file_multiblock_read_count integer 64
>
> Looks like used 128K stripe size for the data drive with 8 x 1 TB drives
> Redo was on this same data rive - doesn't have to be obviously
> Temp was 256K with 4 x 1 TB drives.
>
> Thanks!
>
> Niklas Iveslatt
> Senior Partner
>
>
> Arisant LLC ~ http://www.arisant.com
> 44 Inverness Dr. E Bldg. C Suite 2 ~ Englewood, CO 80112
> mobile: 303.882.4461 ~ main: 303.330.4065 ~ fax: 888.889.0155
>
> Need to send me something securely? *Click here*
> <https://arisant.sendsafely.com/u/niklas.iveslatt>
>
>
> On Fri, Oct 27, 2023 at 10:31 AM Tim Gorman <tim.evdbt_at_gmail.com> wrote:
>
>> Niklas,
>>
>> What stripe widths do you use in the underlying logical volume?
>>
>> FWIW, since ASM defaults to 1M (for "coarse" grain striping), that's what
>> I tend to use in LVs for Oracle as well.
>>
>> Thoughts?
>>
>> -Tim
>>
>>
>> On 10/27/2023 9:18 AM, Niklas Iveslatt (niklas.iveslatt) wrote:
>>
>> If I can say something that could be a little controversial, an Oracle
>> database will run really well with an xfs file system - close to raw i/o
>> performance - with a properly tuned lvm and disk - so like if you line up
>> the block size, with strip size, configure the lvm/xfs etc. - old school
>> stuff basically. Then you can use lvm / xfs to manage + just use then the
>> old school ways of looking and managing files. I mean of course it requires
>> a little bit of investent in linux disk skills but it is not all that
>> complicated.
>>
>> Anyway, just some Friday morning thoughts :) Take it for what it is
>> worth!
>>
>> Niklas Iveslatt
>> Senior Partner
>>
>>
>> Arisant LLC ~ http://www.arisant.com
>> 44 Inverness Dr. E Bldg. C Suite 2 ~ Englewood, CO 80112
>> mobile: 303.882.4461 ~ main: 303.330.4065 ~ fax: 888.889.0155
>>
>> Need to send me something securely? *Click here*
>> <https://arisant.sendsafely.com/u/niklas.iveslatt>
>>
>>
>> On Fri, Oct 27, 2023 at 9:23 AM Mladen Gogala <gogala.mladen_at_gmail.com>
>> wrote:
>>
>>> On 10/27/23 03:58, Nenad Noveljic wrote:
>>>
>>> Is anyone aware of any EC2 image with preinstalled ASM? I found this
>>> one: oracle-19c-asm-image-ssm-v8, but it doesn't work (crs services
>>> don't start).
>>>
>>> Best regards,
>>> Nenad
>>>
>>> Hi Nenad,
>>>
>>> Did you configure the libasm driver before use? Personally, I always
>>> want to configure ASM myself. It's very complex product and I don't think
>>> it would be possible to have a generic version. Maybe I'm wrong.
>>>
>>> Regards
>>>
>>> --
>>> Mladen Gogala
>>> Database Consultant
>>> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>>>
>>>

--
http://www.freelists.org/webpage/oracle-l