What is em in oracle

em in oracle is Enterprise Manager, which is the abbreviation of Enterprise Manager. You can use the Web interface to monitor, manage, and maintain the Oracle database through Oracle EM. The DBA can perform various management and monitoring of the database through OEM from any location that can access the web application. It is a general management middleware produced by Oracle, which can manage Oracle's entire series of database, middleware, and application software.

The operating environment of this tutorial: Windows 10 system, Oracle version 19c, Dell G3 computer.

Oracle's EM is the abbreviation of Enterprise Manager, which can be translated as the Enterprise Manager of the Oracle database.

After Oracle10g, you can use the Web interface through oracle EM to monitor, manage, and maintain the Oracle database. DBAs can perform various management and monitoring of the database through OEM from any location that can access the web application.

is a general management middleware produced by Oracle, which can manage the entire series of Oracle's Database, middleware, and application software.

Extension:

In 11g, OEM is divided into Grid control and Database control, both of which can be used for DB management. From the perspective of DB management, the biggest difference between the two is that Grid can monitor and centrally manage multiple databases, while database control can only manage and monitor one database and cannot be used to monitor multiple databases. It only runs on the database.

(Grid control can monitor the entire Oracle ecosystem. It has a central storage warehouse to collect data about multiple targets on multiple computers, and provides an interface to display common features of all discovered targets. Information.)

In 12c, the management of 12c database can be achieved by using cloud control or Database Express. 12c no longer supports database control. EM express is a very simplified version of Database control that only provides the most basic database management and performance monitoring management. For example, if you want to back up and restore, you can only do it through cloud control (EMCC). Through EM Express, you can view the basic parameter information of the database, store information, add data files, table spaces, user management, etc.

There is no middleware or middle layer on EM express, which ensures that its running overhead on the oracle database server is very, very small. It is built inside the Oracle database by using Oracle's XDB server. Please refer to some contents of Oracle XDB for details.

The above is the detailed content of What is em in oracle. For more information, please follow other related articles on the PHP Chinese website!