Thursday, May 14, 2009, between 5:00 and 8:00 PM

at Premier Inc. (2320 Cascade Pointe Blvd., Charlotte, NC 28208)

Few DBAs realize the Oracle database provides a powerful tool to balance database resource consumption among various groups of database users.  The resource manager can be used:
     
      to prioritize interactive application users over adhoc reporting users;
      allow some users to execute queries with a higher degree of parallelism;
      move long running queries to a reduced priority;
      queue up query requests while limiting the number actively running;
      systematically cancel queries that are consuming too many resources; or
      balance database resource consumption between applications.

Database consolidation is contributing to production environments where a single database serves multiple applications and/or groups of users.  Balancing the needs of the various groups so that no single application or user group can consume all the available resources becomes very important in these shared environments; the resource manager is one tool DBAs can use to meet this need.

This presentation will include resource manager training as well as demonstrations of the initial setup, plan changes, and actual performance of as many of the scenarios listed above as presentation time allows.

Margaret Norman is the Lead Finance Database Administrator at Duke Energy.  Since 1996 Margaret has used Oracle to develop implement and maintain transactional processing systems for large numbers of concurrent users, operational data stores, data warehouses and mixed use databases.  Recent focus areas include database and application performance tuning, scalability, and securing credit card and personal identifiable information to meet PCI and SOX audit requirements.