Hi Linda,
We can't ignore this and be unsupported in the database level.
In order to get a long-term support, customers started to upgrade their Oracle databases to 19C.
Yes, I recommend 19C Db upgrades for both EBS 12.1 and 12.2 customers, but we don't have any implementation on production yet.
What do you mean by ASME? Is it ASM?
ASM is a subject that should be considered independent to the storage architecture actually.
ASM is introduced in 10g for performance and managebility..
A filesystem can be created on ASM, this is called ACFS. ACFS is a copy-on-write filesystem that supports snapshots.
Why ASM has a good performance?
1) ASM uses block devices. It does not use a filesystem.. So, when you use ASM, you get through a very thin layer of code on the OS, as ASM sees the disks as block devices. Thus, less code is executed in the OS layer.
2)Allocation units(Multiple of MB) are used for read/write operations. ASM writes blocks in multiple of MB. Larger IO's but fewer number IO's.
3)ASM uses Direct IO .. It does not use a cache. Without ASM, yhen you write, OS writes it into the cache, but Oracle has a cache too.. These caches ignore eachother.. This situation ends up with double buffering.. We dont have double buffering in ASM.
4)Code Path
Why ASM is more managable?
You can add more storage, take off disks and rebalance on the fly.
Automatic rebalancing makes you not to optimize IO's anymore.
On Linux , we have asm libraries. Before the installations , you can prepare disks for ASM configuration. By doing so, you will not encounter any problems when you install ASM.
Read my blog post if you want to know more on ASM ->
https://ermanarslan.blogspot.com/2013/11/database-oracle-database-12c-briefing.html
Locked
