Re: AWS EC2 image with ASM

Yeah 1M:

It is a DWH:

db_block_size                        integer     16384
db_file_multiblock_read_count        integer     64

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