iSelfSchooling.com - Copyright © 1999-2009 iSelfSchooling.com ||  References  |  Job Openings
    Home  | Search more...  |  FREE Online VIDEO Oracle Training 

    Oracle Syntax  | Suggestions  | Private Tutoring

  Copyright & User Agreement

Email2aFriend  | Homepage us! |  Bookmark

Services

 Vision/Mission

 Services

 Biography

 Contact Us

 FREE Training

 SQL

 PL/SQL

 Forms 

 Reports

 Other TOOLS

 Fundamentals

 Performance

 OEM

 Application Server

 Grid Control

 Articles

 Prepare for OCP

Oracle SYNTAX

 Oracle Functions

 Oracle Syntax

 Oracle 10g Syntax

  PL/SQL Syntax

UNIX and more...

 UNIX for DBAs

 LINUX for DBAs

 DB using PHP

  A+ Certification

 Basics of JAVA  

 Tips of  SEO

Finance/Jobs

 Financial Aid

 Skilled

 Oracle

 Jobs

  Magazine

More Training

 Q & Answers

 SQL-PL/SQL

 DBA

 Developer

 Important Notes

 Case Studies

 9i New Features

 10g New Features

 10g Qs/As

 Grid Control

 OracleAS # I

 OracleAS # II

  LDAP and OID

  HTTP Server

 Instructor-Led

  Virtual Hosts

 Community Sharing

More to know...

Acknowledgement**

 FREE Legal Forms

 Who is who

 Market Place

 University Directory

 Advisory Articles

 Links...

 

 

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

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

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

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

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

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

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

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

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

 

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

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

 

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

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

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

 

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

 

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

 

  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