Blog - comments

Hi Perry, The spare CPU power is of course available for other processes ( i.e non-caged database)! ...
When I studied Oracle New Feature Guide "Media Failure: PDB SYSTEM Data File" , I was surprised tha...
Hayat Khan

Really a nice article to study.

Thanks,

Amol Bhoite

Bonjour,

Tout d'abord merci pour cet article. J'aimerai savoir si ACFS est gratuit ?

Chris

Chris
Hi Jerome.. I have a question. Suppose if we have 8 CPUs on server and we assign 2 CPUs to a databas...
Perry Kahlon
Blog Pierre Sicot Oracle Database 12c: Oracle OEM express

dbi services Blog

Welcome to the dbi services Blog! This blog focuses on IT infrastructure - featuring news, troubleshooting, and tips & tricks. It covers database, middleware, and OS technologies such as Oracle, Microsoft SQL Server, Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.

Oracle Database 12c: Oracle OEM express

Together with Oracle Database 12c, Oracle has introduced a new administration console named Oracle Enterprise Manager Express (Oracle OEM Express). This "light" version of Enterprise Manager Database Console - which is not supported in Oracle 12c anymore - is a management product built into Oracle Database 12c.

There is no installation or management required, the database creation with dbca enables OEM Express and gives you the URL connect string.

As there is no mid-tier or middleware components in OEM Express, the performance overhead with the database server is not important.

The URL connection is: http://db_hostname:port/em/

 

OEM Express: the features

OEM Express only features the basic administration pages of Enterprise Manager Cloud 12c:

 

Configuration:

  • Initialization parameters
  • Memory
  • Database feature
  • Database properties

Storage:

  • Tablespace
  • Undo
  • Redo
  • Archive log
  • Control files

Performance hub:

  • Real-time performance monitoring and tuning
  • Historical performance and tuning
  • SQL monitoring
  • ADDM
  • Active Session History (ASH) analytics
  • Automatic SQL Tuning Advisor and SQL Tuning Advisor

 

Thus, OEM Express allows you to manage the basic features of an Oracle database: user security, database memory, and storage. You can also access real time performance charts.

OEM Express is easy to handle and the response times are very correct.

The database homepage looks like the Cloud 12c homepage with its performance, resource, and sql monitoring pages:

 

em1

 

 The storage page displays the main properties of the tablespaces and datafiles (free space, datafile, etc.):

 

em2

  

The user page displays the different user properties (account status, creation date, expiration date, etc.):

 

em3

 

The performance hub page shows a lot of useful information (memory, I/O, monitored SQL, ADDM):

 

em4

 

Conclusion

OEM Express might be a good solution if you do not have 100 databases to administrate. In this last case, you should use Oracle Enterprise Manager Cloud Control 12c.

With OEM express, Oracle has replaced the old resource-consuming Oracle Enterprise Manager Database Console by a new, easy-to-handle, and nicely performing product.

One of the main advantages is that you do not need to install the product: OEM Express is built into the database, but the performance impact is really not important.

Rate this blog entry:
1

Pierre Sicot is Senior Consultant at dbi services. He has more than fifteen years of experience in Oracle database administration, engineering, and optimization. His specialty is the installation, migration, optimization, and security of Oracle databases in production environments. Prior to joining dbi services, Pierre was consultant at Trivadis in Lausanne. He also worked at ilem Group as a database administrator and also as a Consultant for different customers. Pierre holds a engineering diploma of ESME Sudria in France. His branch-related experience covers Energy, Banking, Public Administration, etc.

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Friday, 25 April 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)
NewsOfficesContact

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter