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@xxxxxxxxx> 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@xxxxxxxxx>
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