Oracle MAS – Mental Acronym Strategy

Reading the latest post on Jonathan Lewis’s excellent blog, I was once again struck by Oracle’s mental acronym strategy, henceforth known, by me, as Oracle MAS.

You have to be careful in discussions – Did they just mention ASM? Or was it ASSM? Or did they mean ASMM?

Bloomin’ ‘eck. It’s all this Automatic … Management that’s to blame. Here’s a recap:

ASM – Automatic Storage Management – a DB-led “solution” for database filesystem / volume management which can stripe and mirror, and also balance IO by redistributing files. Introduced in Oracle 10g.

ASSM – Automatic Segment Space Management – feature that controls how space in a segment is allocated, used and reused. Does away with the need to manually manage settings for FREELISTS, FREELIST GROUPS and PCTUSED (set at a tablespace level). There’s not much comprehensive documentation on it online, almost implying that it’s a no-brainer a bit like LMTs. However, there are always exceptions and there are some articles out there that suggest ASSM as an OLTP only solutions – i.e. not Data Warehouse – and also mention issues for very high-end OLTP sites.

ASMM – Automatic Shared Memory Management – functionality introduced in Oracle 10g to allow Oracle to automatic manage the allocation of SGA components.


One Response to Oracle MAS – Mental Acronym Strategy

  1. Roger Snowden says:

    Hoo boy! Touched a nerve on this one, ya did!

    I did a contract gig at one of the telecoms some years ago. They actually had a toll-free acronym hotline.

    As a database company, you might think Oracle would have an acronym database somewhere. Maybe we do, but I just can’t find the url… or is it uri? You know, that html http shttpd xmldb thingie.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: