The Oracle Enterprise Manager Case Study consists of the 16 most common Oracle database administrator client needs. In your organization, you are expected to know at least how to: Discover a server node; Manage users; Manage roles; Manage profiles; Manage Tablespaces and Datafiles; Obtain database structure information; Manage Database Objects; Optimize SQL statements; Manage Groups and Events; Obtain Database Information; Obtain Memory Statistical Information; Obtain information about a session lock problem; Obtain SQL statement Information; Obtain Disk I/Os; Schedule logical backups; and Perform a logical backup and restoration using the Oracle Enterprise Manager tool.

Hands-On Oracle Enterprise Manager (OEM)-CD#01

Hands-On 01 (Discovering a Server Node using OEM) - Manuscript

As a DBA, you are responsible for adding databases to the Oracle Enterprise Manager. You will be told the domain name and server and then you’ll need to discover the node to your OEM. You are also responsible for starting and shutting down a database.

Your tasks are:

Discovering a Server Node
Identifying all of the databases
Setting Preferred Credential Users
Accessing a database
Changing a user credential
Shutting down a database
Starting-up a database

Hands-On 02 (Managing Users using OEM) - Manuscript

As a DBA, you are responsible for managing an Oracle user account. The following is a summary of your task:

Selecting a target database
Creating an Oracle user
Granting a role to a user
Granting system privileges to a user
Locking a user
Removing a user

Hands-On 03 (Managing Roles using OEM) - Manuscript

As a DBA, you are responsible for managing Oracle roles. The following is a summary of your task:

Selecting a target database
Creating a role
Granting a role to a role
Granting a system privilege to a role
Removing a role

Hands-On 04 (Managing Profiles using OEM) - Manuscript

As a DBA, you are responsible for managing Oracle profiles. The following is a summary of your task:

Selecting a target database
Creating a profile
Limiting a user resources
Removing a profile

Hands-On 05 (Managing Tablespaces and Datafiles using OEM) - Manuscript

As a DBA, you are responsible for managing Oracle tablespaces and datafiles. The following is a summary of your task:

Selecting a target database
Creating a tablespace
Creating a datafile
Changing the block size of a tablespace
Using the Locally Managed option
Adding an additional datafile to a tablespace
Using the automatically extend option
Obtaining a SQL statement syntax
Removing a tablespace

Hands-On 06 (Obtaining a database structure information using OEM) - Manuscript

As a DBA, you are responsible for obtaining database structure information. The following is a summary of your task:

Selecting a target database
Obtaining information about Control Files
Obtaining information about Online Redo Log Files
Obtaining information about Archived Redo Log Files

Hands-On 07 (Managing Database Objects using OEM) - Manuscript

As a DBA, you are responsible for managing database objects. The following is a summary of your task:

Selecting a target database
Creating a table
Adding columns and Datatypes
Changing column attributes
Defining a default storage parameter
Creating a public synonym
Obtaining SQL statement syntaxes

Hands-On 08 (Optimizing a SQL statement using OEM) - Manuscript

As a DBA, you are responsible for optimizing a SQL statement. The following is a summary of your task:

Using the Top Session Tool
Selecting a target database
Obtaining information about a SQL Statement
Browsing a SQL Statement in the memory
Running the EXPLAIN PLAN statement
Obtaining table access information

Hands-On 09 (Managing Groups and Events using OEM) - Manuscript

As a DBA, you are responsible for managing a group’s item and an event’s item. The following is a summary of your task:

Creating a Group
Obtaining a background picture
Assigning databases to a group
Creating an Oracle Event
Assigning Access Privileges of an Event
Assigning target database to an Event
Testing a created event
Scheduling a frequent run of an Event
Notifying users
Registering an Event
Adding an Event to the Repository Library
Refreshing the CONSOLE
Obtaining a Red Flag

Hands-On 10 (Obtaining a Database Information using OEM) - Manuscript

As a DBA, you are responsible for obtaining database information. The following is a summary of your task:

Obtaining the “Disk space used by tables” report
Selecting a target database
Obtaining the “Instance” report
Obtaining “SGA” information
Obtaining the “Security” report
Obtaining user information
Obtaining profile information
Obtaining role information
Obtaining the “Storage” report
Obtaining tablespace information
Obtaining datafile information
Obtaining rollback segment information
Obtaining redo log and archive log information

Hands-On 11 (Obtaining a Memory Statistical Information using OEM) - Manuscript

As a DBA, you are responsible for obtaining statistical information about the memory for performance and tuning purposes. The following is a summary of your task:

Using the Diagnostics Pack Tool
Selecting a target database
Obtaining Session CPU Activity
Obtaining Session Memory Use
Obtaining Session Efficiency
Obtaining Memory Size
Obtaining I/O statistics
Obtaining Session Identification
Obtaining detailed session information
Obtaining SQL statements

Hands-On 12 (Obtaining a SQL statement Information using OEM) - Manuscript

As a DBA, you are responsible for obtaining SQL statement information for performance tuning purposes. The following is a summary of your task:

Selecting a target database
Obtaining the “Disk Reads Per Execution” output
Obtaining the “Buffer Gets Per Execution” output
Obtaining the “Execution” output
Obtaining the “Disk Reads” output
Obtaining the “Buffer Gets” output
Obtaining the “Hit Ratio” output

Hands-On 13 (Detecting a session lock problem using OEM) - Manuscript

As a DBA, you are responsible for detecting a session lock problem. The following is a summary of your task:

Using the “Lock Monitor” tool
Selecting a target database
Identifying the Lock Session
Obtaining locked users
Obtaining a user’s lock mode
Resolving lock contentions

Hands-On 14 (Obtaining Disk I/Os using OEM) - Manuscript

As a DBA, you are responsible for obtaining disk I/Os for performance tuning purposes. The following is a summary of your assigned task:

Using the “Performance Manager” tool
Selecting a target database
Obtaining disk I/Os
Using the “File Read Operations” chart
Changing the “Refresh Rate” option
Monitoring the “Physical Reads/Sec” activity
Monitoring the “Physical Block Reads/Sec” activity

Hands-On 15 (Scheduling a Database backup) - Manuscript

As a DBA, you are responsible for scheduling a Database backup for your organization’s database. The following is a summary of your assigned task:

Using the “Backup” tool
Using the Backup Wizard
Specifying a backup date and time
Identifying backup target databases
Submitting a backup job

Hands-On 16 (Performing a logical backup and restore) - Manuscript

As a DBA, you are responsible for performing a logical backup and restoration of your organization’s database in case of a disaster. The following is a summary of your assigned task:

Using the “Database Wizards” tool
Using the “Export Wizard” tool
Specifying a backup table
Scheduling a Job
Adding created export jobs to the Job Library
Using the “Import Wizard” tool
Specifying a restore table
Scheduling a Job
Adding created import jobs to the Job Library
Viewing created Jobs in the Job Library