Oracle 10g ASMM Features

Oracle 10g Oracle10g Automated Memory Management

Oracle Database 10g now provides for automated management of SGA Memory Areas, relieving the DBA from having to worry over database block buffers, shared pools, and other internal memory structures.

In addition, there are a number of other new automation features in Oracle Database 10g, let's take a quick look at them.

Oracle Database 10g Automation Features

Oracle Database 10g provides a wealth of features that can be used to automate almost every aspect of Oracle Database 10g database administration. It is important to note that these automation features are OPTIONAL, and they are not intended to replace standard DBA activities. Rather, the Oracle Database 10g automation features are aimed at shops that do not have the manpower or expertise to manually perform the tasks.

The automation features of Oracle Database 10g appear to offer two products bundled into a single package. The 10g customer can have the flexible (and complex) Oracle Database 10g database, or they can use the automated memory, storage, and SQL features for a simple (alBCt sub-optimal) database.

So, if your 10g database does not require detailed, expert tuning, then the automated features might be a good choice. The automated features are targeted at these market segments:

• Small shops – Small installations that cannot afford a trained Oracle DBA.
   
• Shops with over-worked DBAs - Large shops with hundreds of instances where the DBA does not have time to properly tune each system

Remember, the automated features are not for every shop, and a human DBA will almost always perform better than the automated Oracle features.

There are some duplicate acronyms that may be problematic because it is not clear which component is being used. The duplicate Oracle Database 10g acronyms include:

SGA – System Global Area
SGA – Server Generated Alerts
ASM – Automated Segment Management (bitmap freelists)
ASM – Automatic Storage Management

Whenever possible we have tried to avoid the use of conflicting acronyms and we have avoided the temptation to use too many acronyms. For example, it is perfectly valid in Oracle Database 10g to state “The AWR gives data to AMT for the US to re-analyze statistics”.

How to disable AMM:  See these important notes on disabling AMM (Automatic Space Memory Management)

If you like Oracle tuning, you might enjoy my book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.