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

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

•  

• 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)

•  

• 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)

•  

• 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)

•  

• Selecting a target database

• Creating a profile

• Limiting a user resources

• Removing a profile

•  

•  

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

•  

• 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)

•  

• 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)

•  

• 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)

•  

• 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)

•  

• 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 )

•  

• 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 tablelspace 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)

•  

• 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)

•  

• 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)

•  

• 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)

•  

• 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)

•  

• 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)

•  

• 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