I am excited to announce that Database Performance analyzer 10.1 with support for Oracle 12c multitenant is now available in the customer portal and for free evaluation from the SolarWinds Website. What's so special about DPA 10.1?  Let's take a look!

 

New Features in 10.1

  • Support for Oracle 12c Multitenant
    • Monitor Oracle Pluggable Databses (PDBs)
    • Automatic Grouping of PDBs
    • Summary View, showing usage per PDB
    • Detect and alert when PDBs are added, remove or moved.
    • Mass registrion for PDBs, just like other
    • PDBs should up in the Orion integration
    • Using a PDB as an DPA repository
  • Improved Mass Registration
  • Offline License Deactivation
  • Lots of minor fixes - see the Release Notes.

 

What is a PDB?

What's a PDB you ask?   Officially, a Pluggable Database is "user-created set of schemas, objects, and related structures that appears logically to an application as a separate database". Basically, its everything that makes up the database.  Why is this important?  Previously, Oracle didn't have a good way to have multiple databases on one Oracle instance. You had a couple of options, table spaces and multiple instances per server, but they had their drawbacks.  Multitenant support is kind of like virtualization, where you can quickly "plug" in multiple databases into one Oracle "container" (aka CDB) and let them share resources and be managed as a whole, improving resource utilization and reducing management time.

 

Monitoring Oracle Multitenant and PDB changes

Adding individual PDBs now works just like Oracle single tenant or the classic Oracle databases.  Just choose Oracle, enter the needed information and go!  Same thing with mass registration.  DPA will only allow you to register PDBs, not CDBs (Container Databases).  If you try to add the CDB, DPA will politely ask you to register the PDBs instead.

 

Once you have registered two Oracle PDBs in the same CDB (Container Database), they will auto group in the home screen.  If you register just one PDB from a CDB, is will still show up as an individual database.

CDB View - Summarizing PDB Load

As a bonus, you can click on the CDB and get summary data across the PDB instances, allowing you to quickly see which PDB has more wait time, what kinds of waits they are experiencing,

 

Which PDB is waiting the most in the CDB?  Quickly see the balance between the PDBs.

If you are seeing unusual wait times at the PDB level, you can drill up and review the PDB.  Here we see a major increase "direct path read" and "read by other session".

Finally, if you want to look across all your PDBs and find the query with the most wait time, use the Top SQL tab.  You can click on the link to see the query.

 

PDB Annotations and Alerts

The data collected from a PDB is the same data we've always collected for Oracle.  However, we do annotate all PDB changes - when they are added, removed or moved.

For example, you will see annotations on the 30-day trend when

  • You plug in a PDB
  • You move a PDB from one CDB to another (see sample below)
  • You unplug a PDB

PDB Odds and Ends

  • If you have a dozens or hundreds of PDBs, mass registration allows you to quickly add them via a spreadsheet upload.
  • If you want to use a PDB as a repository for DPA, no problem - it works out of the box.
  • PDBs will show up in the Orion integration and support all current features, so they will map to your Orion nodes and application just like traditional databases.

 

 

But Wait, There's More

Every release has some minor features too, and 10.1 is no exception.

  • The mass registration file can now be uploaded directly to DPA via the GUI, rather than moving the file to the DPA server.  This simplifies mass registration and makes it a more secure process.
  • You can now deactivate licenses without involving support or customer service - even if you are offline.
  • Lots of minor fixes - see the Release Notes.

 

What's next?

Our dedicated team of database nerds and code jockies are hard at work on the next awesome DPA release - check out the What We Are Working On for DPA (Updated April 7, 2017) post.  If you don't see everything you've been wishing for there, you add it to our Database Performance Analyzer Feature Requests

 

If the above features get you excited, get on the list for the next beta by filling out this survey.