Oracle Database 12c: DB Express – Sneak Peek

0

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

Share.

About Author

Marco Gralike, working for AMIS Services BV as a Principal Oracle Database Consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like Operating System Administration and Application Servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance. He is an Oracle XMLDB enthusiast ever since. He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco is a member of the OakTable network and an Oracle ACE Director (specialization Oracle XMLDB).

Leave a Reply