Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle




EnterpriseDB: Add/Remove Cluster
Oracle Tips by Burleson

I would really rather that the people at EnterpriseDB had called this "registering a cluster" rather than add and remove a cluster (Figure 6.3).  This menu option does not actually add or remove a cluster from your environment.  It adds a cluster to this instance of the DBA Management Server.  When you add a cluster, the management server will add a new tab to the home page and start tracking available statistics for the cluster.

Figure 6.3: Add/Modify Cluster

If you want to start tracking statistics in a database in the existing cluster, click the check box next to the database.  If you do not want to track statistics in a database, uncheck the box.

To add a cluster to this instance of the DBA Management Server, choose Configure New Cluster.  Remember that you are not really adding or changing a cluster anywhere.  You are just telling the management server to start tracking that cluster’s statistics.

The Configure New Cluster dialog (Figure 6.4) will allow you to enter the server name, port and database to track.

Figure 6.4: Configure Cluster

You enter either text server name or an ip address.  All fields are required.  Once you have entered the information, choose Configure and you are taken back to the Add/Remove Cluster page.

You can verify that you have added the cluster and made your changes by returning to the Home Page (under the Home menu option).  You should see a tab for each cluster that you've added and you should see additional databases if you have added those (Figure 6.5).

Figure 6.5: Verify Cluster Changes


The next menu option is the Monitoring option.  This is where you can get a view of who is doing what in your database instance.

User Activity

The User Activity page (Figure 6.6) will show you who is logged in and what they are currently running.  If you have turned on the stats_command_string option (see below in Monitoring Configuration), you will be able to see that actual command string.  You can configure some databases to log the command and others not to.  You may want to turn off command logging on heavy transaction databases such as the MGMTSVR database.

Figure 6.6: Monitor User Activity

You can choose the database to monitor from the Database dropdown.  You can also turn off auto-refresh if you would like to refresh manually.

Lock Status

The Lock Status page (Figure 6.7) shows current database locks.  Locks are normally transient in EnterpriseDB (and PostgreSQL) due to the superior locking mechanism in the database.  It is not unusual for this page to be empty.

Figure 6.7: Monitor Locks

Ironically, this report temporarily locks a critical system table.  You should only run this report when needed and you should probably turn off Auto Refresh to prevent performance issues in the database.

Buffer Cache

The Buffer Cache page (Figure 6.8) shows active hits on the memory area of EnterpriseDB.  You can get an idea about how your processes are using data from this screen.

The query behind this page also locks a critical system table so you should only run it when needed.

Figure 6.8: Monitor Objects in Buffer Cache


I spoke about this page in detail in Chapter 2.  See figure 2.5 and the text around that figure.

To re-iterate, these configuration options determine how much data the management server gathers and saves for monitoring purposes.  Like all monitoring, there is always a downside.  The more you gather, the heavier the load on the system. 

In my system (Figure 6.9), I have all of the monitoring options turned on.  This is not a production instance though.  How you set your instance is partially determined by how you will use it and what kind of available resources you have.

Figure 6.9: Monitor Statistics Collection Configuration


This is an excerpt from the book "EnterpriseDB: The Definitive Reference" by Rampant TechPress.


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter