OBE 11g: Monitoring and Tuning the Database

En  esta lección de "Oracle  By Example" aprenderemos lo siguiente:

Purpose
This chapter introduces you to some of the monitoring and tuning operations as performed through Enterprise Manager.

Time to Complete
Approximately 1 hour

Summary
In this tutorial, you learned how to:

• Create a tablespace with a specified threshold.
• Triggering a tablespace usage alert.
• Set metric thresholds.
• Create a performance finding.
• Solve the performance finding using ADDM.

Ir a la lección

OBE 11g: Performing Backup and Recovery

En  esta lección de "Oracle  By Example" aprenderemos lo siguiente:

Purpose
This chapter introduces you to Oracle Database backup and recovery operations as performed through Enterprise Manager.

Time to Complete
Approximately 1 hour

Summary
In this tutorial, you will learned how to:

• Configure the flash area.
• Configure backup policies.
• Confirm the DBID and the DB_UNIQUE_NAME values..
• Perform a whole database backup.
• Restore and recover the database.
• Perform a Flashback table.
• Manage your backups including deleting obsolete backups or using the cataloging feature.

Ir a la lección

OBE 11g: Managing Schema Objects

En  esta lección de "Oracle  By Example" aprenderemos lo siguiente:

Purpose
A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes. You can create and manipulate schema objects using Oracle Enterprise Manager.

Time to Complete
Approximately 1 hour

Summary
In this tutorial, you learned how to:

• Query for tables in a specific schema.
• Create an table and view the attributes and contents of the new table.
• Create a view.
• Manage database resident program units.
• Load data into an existing table.

Ir a la lección

OBE 11g: Administering Users and Security

En  esta lección de "Oracle  By Example" aprenderemos lo siguiente:

Purpose
You must create user accounts and grant appropriate database access privileges to those accounts so that users can access your database. Some user accounts are automatically included in the pre-configured database, but for security reasons, most of these accounts are locked and expired. In this chapter you will learn how to create and manage user accounts. You will use Enterprise Manager to create a role and two users in your database. You will also unlock the HR user account.

Time to Complete
Approximately 1 hour

Summary
In this tutorial, you will learned how to:

• Create a new user.
• Change the attributes associated with a user.
• Unlock a user account and set a new password.
• Grant system privileges to a user.
• Create a role and assign the new role to an existing role.

Ir a la lección

OBE 11g: Managing Database Storage Structures

En  esta lección de "Oracle  By Example" aprenderemos lo siguiente:

Purpose
In this chapter you will learn how to use Enterprise Manager to explore the structure of your database. In addition, you will learn how to make a number of changes to your database storage structure.

Time to Complete
Approximately 1 hour

Summary
In this tutorial, you learned how to:

• Review the structure of the control files, tablespaces, datafiles, and redo log files.
• Create the FSDATA tablespace.
• Modify the automatic extension increment for a tablespace.
• Add another member to a redo log group.
• Modify the undo parameters using the Automatic Undo Management page in EM or the Undo Advisor.

Ir a la lección

OBE 11g: Gestionando la instancia Oracle

En  esta lección de "Oracle  By Example" aprenderemos lo siguiente:

Purpose
This chapter focuses on the tasks involved in managing your instance. In this chapter, you will learn how to use the property pages in the Instance region of the Administration page of Enterprise Manager.

Time to Complete
Approximately 1 hour

Summary
In this tutorial, you learned how to:

• Startup and shutdown the Oracle instance.
• Review the initialization parameters associated with the instance.
• Use the Memory Advisors page to assess the memory parameters for the instance.

Ir a la lección

OBE 11g: Configurando el ambiente de Red

En  esta lección de "Oracle  By Example" aprenderemos lo siguiente:

Purpose
This chapter helps you to configure and manage your network environment so that users can access your database.

Time to Complete
Approximately 1 hour

Summary
In this tutorial, you will learned how to:

• Log into the Net Services Administration application.
• Start and stop the listener using the lsnrctl command.
• Configure a client machine to connect to an Oracle database using Oracle Net Manager.
• Create a Local Naming entry using Enterprise Manager.

Ir a la lección

OBE 11g: Introducción a Oracle Enterprise Manager

En esta segunda lección de "Oracle By Example" aprenderemos lo siguiente: 

Purpose
This chapter introduces you to Oracle Enterprise Manager Database Control. The Oracle Universal Installer installs Oracle Enterprise Manager Database Control when you install the Oracle software. Enterprise Manager Database Control provides a Web-based interface that you can use to manage your Oracle instance and database.

Time to Complete
Approximately 1 hour

Summary
In this tutorial, you will learned how to:

• Start and verify the status of the dbconsole process.
• Log into Enterprise Manager (EM) Database Control.
• Granting administrator privileges to other users.
• Define a blackout period for you database instance.
• Set preferred credential information in EM to be used later for administrative tasks.

Ir a la lección

OBE 11G: Instalando el software de Oracle y creando una base de datos

En  esta lección de "Oracle  By Example" aprenderemos lo siguiente:

Purpose
This chapter shows you how to use the Oracle Universal Installer (OUI) to install your Oracle database software and create a starter database. You will also learn how you can use the Database Configuration Assistant (DBCA) to create additional databases.

Time to Complete
Approximately 2 hours

Summary
In this tutorial, you will learned how to:

• Install the basic version of the database.
• Install the advanced version of the database including running the Database Configuration Assistant.
• Create a database using the Database Configuration Assistant.

Ir a la lección