iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

IMPORTANT-READ CAREFULLY  

 

More Resources by Google:

 

Oracle Enterprise Manager Case Study

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)

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:

  1. Discovering a Server Node

  2. Identifying all of the databases

  3. Setting Preferred Credential Users

  4. Accessing a database

  5. Changing a user credential

  6. Shutting down a database

  7. Starting-up a database

 

Hands-On 02 (Managing Users using OEM) -

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

 

  1. Selecting a target database

  2. Creating an Oracle user

  3. Granting a role to a user

  4. Granting system privileges to a user

  5. Locking a user

  6. Removing a user

 

 Hands-On 03 (Managing Roles using OEM)

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

 

  1. Selecting a target database

  2. Creating a role

  3. Granting a role to a role

  4. Granting a system privilege to a role

  5. Removing a role

 

 Hands-On 04 (Managing Profiles using OEM)

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

 

  1. Selecting a target database

  2. Creating a profile

  3. Limiting a user resources

  4. Removing a profile

 

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

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

 

  1. Selecting a target database

  2. Creating a tablespace

  3. Creating a datafile

  4. Changing the block size of a tablespace

  5. Using the Locally Managed option

  6. Adding an additional datafile to a tablespace

  7. Using the automatically extend option

  8. Obtaining a SQL statement syntax

  9. Removing a tablespace

 

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

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

 

  1. Selecting a target database

  2. Obtaining information about Control Files

  3. Obtaining information about Online Redo Log Files

  4. Obtaining information about Archived Redo Log Files

 

 Hands-On 07 (Managing Database Objects using OEM)

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

 

  1. Selecting a target database

  2. Creating a table

  3. Adding columns and Datatypes

  4. Changing column attributes

  5. Defining a default storage parameter

  6. Creating a public synonym

  7. Obtaining SQL statement syntaxes

 

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

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

 

  1. Using the Top Session Tool

  2. Selecting a target database

  3. Obtaining information about a SQL Statement

  4. Browsing a SQL Statement in the memory

  5. Running the EXPLAIN PLAN statement

  6. Obtaining table access information

 

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

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:

 

  1. Creating a Group

  2. Obtaining a background picture

  3. Assigning databases to a group

  4. Creating an Oracle Event

  5. Assigning Access Privileges of an Event

  6. Assigning target database to an Event

  7. Testing a created event

  8. Scheduling a frequent run of an Event

  9. Notifying users

  10. Registering an Event

  11. Adding an Event to the Repository Library

  12. Refreshing the CONSOLE

  13. Obtaining a Red Flag

 

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

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

 

  1. Obtaining the “Disk space used by tables” report

  2. Selecting a target database

  3. Obtaining the “Instance” report

  4. Obtaining “SGA” information

  5. Obtaining the “Security” report

  6. Obtaining user information

  7. Obtaining profile information

  8. Obtaining role information

  9. Obtaining the “Storage” report

  10. Obtaining tablespace information

  11. Obtaining datafile information

  12. Obtaining rollback segment information

  13. Obtaining redo log and archive log information

 

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

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:

 

  1. Using the Diagnostics Pack Tool

  2. Selecting a target database

  3. Obtaining Session CPU Activity

  4. Obtaining Session Memory Use

  5. Obtaining Session Efficiency

  6. Obtaining Memory Size

  7. Obtaining I/O statistics

  8. Obtaining Session Identification

  9. Obtaining detailed session information

  10. Obtaining SQL statements

  

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

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

 

  1. Selecting a target database

  2. Obtaining the “Disk Reads Per Execution” output

  3. Obtaining the “Buffer Gets Per Execution” output

  4. Obtaining the “Execution” output

  5. Obtaining the “Disk Reads” output

  6. Obtaining the “Buffer Gets” output

  7. Obtaining the “Hit Ratio” output

 

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

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

 

  1. Using the “Lock Monitor” tool

  2. Selecting a target database

  3. Identifying the Lock Session

  4. Obtaining locked users

  5. Obtaining a user’s lock mode

  6. Resolving lock contentions

  

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

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

 

  1. Using the “Performance Manager” tool

  2. Selecting a target database

  3. Obtaining disk I/Os

  4. Using the “File Read Operations” chart

  5. Changing the “Refresh Rate” option

  6. Monitoring the “Physical Reads/Sec” activity

  7. Monitoring the “Physical Block Reads/Sec” activity

 

 Hands-On 15 (Scheduling a Database backup)

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:

 

  1. Using the “Backup” tool

  2. Using the Backup Wizard

  3. Specifying a backup date and time

  4. Identifying backup target databases

  5. Submitting a backup job

 

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

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:

 

  1. Using the “Database Wizards” tool

  2. Using the “Export Wizard” tool

  3. Specifying a backup table

  4. Scheduling a Job

  5. Adding created export jobs to the Job Library

  6. Using the “Import Wizard” tool

  7. Specifying a restore table

  8. Scheduling a Job

  9. Adding created import jobs to the Job Library

  10. Viewing created Jobs in the Job Library
 

Google
 
Web web site