Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Roberto.

Asked: February 14, 2017 - 4:21 pm UTC

Last updated: February 16, 2017 - 3:43 am UTC

Version: 12.1.0.2

Viewed 1000+ times

You Asked

What is your stance on using AMM on a production system? Several Metalink notes and books recommend its use but that is not always what Oracle support recommends.

If there are known issues and AMM is not recommended then I wonder why not have the documentation updated with the correct advise.

Thanks!

and Connor said...

For me - its about the DBA "involvement".

In a given organization, I might have (say) 50 databases to look after. Out of those, typically 45 of those are non-critical, ie,

- as long as they run *reasonably* well, thats fine
- if they go down for some reason, then I need to fix it, but its not going to kill my business

The other 5 databases ... well...thats where I earn my salary. They are

- mission critical to the business
- must *not* go down
- must run at optimal performance
- etc etc

For those 45 databases, that I'd rather not spend time on - I might opt for AMM, because its unlikely I'll be proactively monitoring those db's anyway - its just not a practical use of my time.

For the 5 mission critical databases, I'll probably *not* use AMM, because I'll be much more actively involved in monitoring, tuning, etc those database to ensure the absolute best outcomes for my users.


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Interesting

Roberto, February 15, 2017 - 4:29 pm UTC

And for those critical databases, do you use ASMM then?
Connor McDonald
February 16, 2017 - 3:43 am UTC

Depends on the database.

If I'm confident in the quality of the apps on that database, I'll probably use auto, because the shared pool and buffer cache will most likely end up at an equilibrium.

If it is a not so nice app, I might not, so I lock down things like shared pool size to ensure that I dont get spontaneous uncontrolled growth.

Of course, you can have a little of each, ie, have auto and also set lower bounds for each pool.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.