Oracle Database 12c: DB Express – Sneak Peek

Marco Gralike

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

Screen Shot 2013-06-26 at 12.45.25

Screen Shot 2013-06-26 at 12.45.40

Screen Shot 2013-06-26 at 12.45.55

Screen Shot 2013-06-26 at 12.46.09

Configuration >> Memory (overview)

Screen Shot 2013-06-26 at 12.46.31

Performance >> Performance Hub [Summery Tab]

Screen Shot 2013-06-26 at 12.46.50

Performance >> Performance Hub [Activity Tab]

Screen Shot 2013-06-26 at 12.47.34

Performance >> Performance Hub [Workload Tab]

Screen Shot 2013-06-26 at 12.47.49

Performance >> Performance Hub [Monitored SQL Tab]

Screen Shot 2013-06-26 at 12.48.48

…and drill down in one of the shown sessions…

Screen Shot 2013-06-26 at 12.48.18

Performance >> Performance Hub [ADDM Overview Tab]

Screen Shot 2013-06-26 at 12.49.02

Performance >> Performance Hub [Current ADDM Findings Tab]

Screen Shot 2013-06-26 at 12.49.14

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 Cloud Control”…

Next Post

Oracle Database 12c: PL/SQL package UTL_CALL_STACK for programmatically inspecting the PL/SQL Call Stack

Facebook0TwitterLinkedin  Oracle Database 12c ships with a brand new supplied package called UTL_CALL_STACK. This package provides an API for inspecting the PL/SQL Callstack. The package complements the DBMS_ UTILITY.FORMAT_CALL_STACK that returns a pretty print human readable overview of the callstack. Here is an example of how this package could be […]