Oracle 12c: DB Express – Sneak Peek

The new Database Express or DB Express database utility is different from the former DB Console. It is based on flash and “built-in” the database. To give you a small overview (sneak peek) into this great new tool for, for example, database performance tuning, hereby some pictures to create some appetite. I created some have load on my database, to make it a bit more interesting…

Main Menu

The main menu has a section for “Configuration”, “Storage”, “Security” and “Performance”


Screen Shot 2013-06-26 at 12.45.01
Click picture to enlarge

Screen Shot 2013-06-26 at 12.45.25
Click picture to enlarge

Screen Shot 2013-06-26 at 12.45.40
Click picture to enlarge

Screen Shot 2013-06-26 at 12.45.55
Click picture to enlarge

Screen Shot 2013-06-26 at 12.46.09
Click picture to enlarge

Configuration >> Memory (overview)


Screen Shot 2013-06-26 at 12.46.31
Click picture to enlarge

Performance >> Performance Hub [Summery Tab]


Screen Shot 2013-06-26 at 12.46.50
Click picture to enlarge

Performance >> Performance Hub [Activity Tab]


Screen Shot 2013-06-26 at 12.47.34
Click picture to enlarge

Performance >> Performance Hub [Workload Tab]


Screen Shot 2013-06-26 at 12.47.49
Click picture to enlarge

Performance >> Performance Hub [Monitored SQL Tab]


Screen Shot 2013-06-26 at 12.48.48
Click picture to enlarge

…and drill down in one of the shown sessions…


Screen Shot 2013-06-26 at 12.48.18
Click picture to enlarge

Performance >> Performance Hub [ADDM Overview Tab]


Screen Shot 2013-06-26 at 12.49.02
Click picture to enlarge

Performance >> Performance Hub [Current ADDM Findings Tab]


Screen Shot 2013-06-26 at 12.49.14
Click picture to enlarge

As you can see via this short introduction, a lot of the later performance goodies we already know and love are present in the new DB Express tool. Some of the old features have also disappeared.

In a “Pluggable Database” environment, this tool is a great asset to the developers, and for those who loved the disappeared toolset from DB Console, it is probably time to have a closer look at the “no cost” option called “Oracle Enterprise Manager 12c Cloud Control”…