Oracle Enterprise Manager (OEM) - May 05, 2009 at 18:00 PM by
What are the components of OEM?
Oracle Enterprise Manager (OEM) has the following components:
Collection agent or Oracle Management agent (OMA) - Used to collect hardware, OS
related information and applications running on target.
Aggregation agent or Oracle Management Server (OMS) – Collects data from OMA and
aggregates it into a repository. It is also used to view the status of systems
and services through a UI.
Repository agent or Oracle management repository (OMR)- It can be a highly
available and fault tolerant instance of the oracle database used to store data
collected by OMS. Installers can be used to make them fault tolerant.
Post-form commit fires once during the post and commit transactions process,
after the database commit occurs. The post-form-commit trigger fires after
An extent is stored some specific information. This information is stored using
specific number of adjoining data blocks. A collection of extent is called as a
segment stored in the same tablespace.............
Latches are used to protect Oracle data structures to be modified or run by more
than one process. They are more restrictive than locks. Locking has a similar
The parser scans the statement and breaks it into logical units such as
keywords, identifiers and operators, A query or a sequence tree is built using
the units above. This is done to transform the source data into the format
required by the result set.............
A parameter makes the cursor more reusable, A parameter avoids scoping
Roles in Oracle can be used to grant privileges to a specific group of users
for security. The database manager is usually responsible for granting
privileges to a Role..........