Learn how to read the ALERT file to be informed of any unknown problems with the database such as, not enough space in the rollback segment or the maximum extent reached in a table, etc. - Manuscript

Hands-On 05 (Changing the database mode)

Learn how to change the database mode for database maintenance purposes. - Manuscript

Hands-On 06 (Server Parameter File-SPFILE)

Learn how to change memory size allocations while the database is on. - Manuscript

Hands-On 07 (Configure the database to the archive mode)

Learn how to change a database mode from no archive log to archive log and how to maintain online redo-log files. - Manuscript

Hands-On 08 (Maintaining and Relocating the Redo Log files)

Learn how to maintain and relocate the Redo Log file in order to distribute data among multiple hard disks to increase I/O performance. - Manuscript

Hands-On 09 (Multiplexing and Maintaining the Online Redo Log files)

Learn how to maintain multiple Online Redo log files to protect your organization of a possible loss of data due to media failure. - Manuscript

Hands-On 10 (Maintaining Tablespace and Datafiles)

Learn how to maintain tablespaces and datafiles due to the growth of a user’s database. - Manuscript

Hands-On 11 (Maintaining a TEMPORARY tablespace)

Learn how to maintain a TEMPORARY tablespace due to a user’s big transaction sorting. - Manuscript

Manuscripts for Oracle Fundamentals I Case Study

Hands-On Oracle Fundamentals I-CD#02 (Database Administrator-DBA)

Hands-On 12 (Maintaining a Tablespace)

Learn how to maintain tablespaces and datafiles due to a user’s usage of the tablespace. How to change the tablespace mode to the READ ONLY mode, relocate the tablespace to a new not busy disk. - Manuscript

Hands-On 13 (Managing Storage Structures)

Learn how to manage a table storage structure due to performance problems or a spacing issue. - Manuscript

Hands-On 14 (Maintaining and Configuring UNDO tablespace)

Learn how to maintain UNDO tablespaces due to an users’ database transactions, how to use UNDO_MANAGEMENT, UNDO_TABLESPACE, UNDO_RETENTION parameters. - Manuscript

Hands-On 15 (Maintaining and Configuring an UNDO tablespace manually)

Learn how to maintain UNDO tablespaces manually due to an users’ database transactions. - Manuscript

Hands-On 16 (Creating and Maintaining a TEMPORARY table)

Learn how to create and maintain a TEMPORARY table due to your organization’s developer requirements (transactional or session). - Manuscript

Hands-On 17 (Detecting ROW Migration and Chaining)

Learn how to detect row migration and chaining. - Manuscript

Hands-On 18 (Monitoring an object usage)

Learn how to monitor newly created indexes. - Manuscript

Hands-On 19 (EXCEPTIONS INTO EXCEPTIONS)

Learn how to use the advantages of the EXCEPTIONS clause. - Manuscript

Hands-On 20 (Maintaining user’s account and profile)

Learn how to maintain user accounts due to the growth of the organization. Learn how to create a profile to limit a group of users from using the database resources. - Manuscript

Hands-On 21 (Auditing a database)

Learn how to audit the database due to a suspicious transaction on certain table - Manuscript

Hands-On 22 (Creating a new database)

Learn how to create a new database. - Manuscript

Manuscripts for Oracle Fundamentals II Case Study

Hands-On Oracle Fundamentals II-CD#01 (User-Managed Backup and Recovery)

Hands-On 01 (Memory Space Allocation on the Fly)

Learn how to monitor and change a memory space allocation of your organization’s database in case of performance problems. - Manuscript

Hands-On 02 (Oracle Background Processes)

Learn how to to monitor and understand the functions of the Oracle background processes. - Manuscript

Hands-On 03 (Multiplexing the Control File)

Learn how to multiplex controlfiles to protect your organization from a possible and unexpected loss of controlfiles, due to media failure. - Manuscript

Hands-On 04 (Configuring the Database Archive mode)

Learn how to change a database mode from no archive mode to archive mode to recover any failures to a point of failure and also to perform your backup while in an online status. - Manuscript

Hands-On 05 (Maintaining Redo Log files)

Learn how to maintain and relocate the Redo Log files in order to distribute data among multiple hard disks to increase I/O performance. - Manuscript

Hands-On 06 (Duplexing Archived Online Redo Log files)

Learn how to duplex archived Online Redo log files in order to protect the organization from a loss of or a case of corrupted archived files. - Manuscript

Hands-On 07 (User-Managed COLD or OFFLINE backup)

Learn how to backup the database and restore the data in case of a loss of data due to media failure. Learn how to use the COLD or OFFLINE backup process. - Manuscript

Hands-On 08 (User-Managed HOT or ONLINE backup)

Learn how to backup the database and restore the data in case of a loss of data due to media failure. Learn how to use the HOT or ONLINE backup process. - Manuscript

Hands-On 09 (User-Managed Tablespaces and Datafiles Backup)

Learn how to backup the tablespace or datafile and restore the data to the point of failure in case of a loss of data due to a media hard disk crash. - Manuscript

Hands-On 10 (User-Managed Tablespace Recovery)

Learn how to recover the database to the point of failure due to a loss of data and media failure. - Manuscript

Hands-On 11 (User-Managed Logical Backup and recovery)

Learn how to perform a logical backup using the EXP and IMP tools. Learn also how to use the IMP tool to restore data to the same or a different destination. - Manuscript

Manuscripts for Oracle Fundamentals II Case Study

Hands-On Oracle Fundamentals II-CD#02

(RMAN-Managed Backup and Recovery along with Network Configurations)

Hands-On 01 (RMAN-Managed user and repository)

Learn how to create the RMAN repository and use the RMAN tool to perform a backup and recovery of your organization’s database. - Manuscript

Hands-On 02 (Use of the RMAN commands)

Learn how to register a database, synchronize a database, and back-up a database. - Manuscript

Hands-On 03 (Configuration of the RMAN tool)

Learn how to configure the RMAN repository, perform an image copy, connect to the target and catalog databases, etc. - Manuscript

Hands-On 04 (Using the RMAN backup utility)

Learn how to perform backups of a database, perform incremental backups, and use the formatted defined output name. - Manuscript

Hands-On 05 (RMAN-Managed Tablespace Recovery)

Learn how to recover a tablespace due to a loss of data from a media system crash. - Manuscript

Hands-On 06 (RMAN-Managed Complete Backup)

Learn how to perform a complete backup using the RMAN tool. - Manuscript

Hands-On 07 (RMAN-Managed incomplete database recovery scenario)

Learn how to recover a table to a point in time due to user failure (Scenario only). - Manuscript

Hands-On 08 (RMAN-Managed incomplete database recovery)

Learn how to recover a table to a point in time due to user failure. - Manuscript

Hands-On 09 (RMAN-Managed the LIST and REPORT commands)

Learn how to obtain backup information using the LIST and REPORT commands. - Manuscript

Hands-On 10 (Configuring a Listener using the “Net Manager” tool)

Learn how to configure a listener using the “Net Manager” tool. - Manuscript

Hands-On 11 (Configuring a Service Name using the “Net Manager” tool)

Learn how to configure a Service Name using the “Net Manager” tool. - Manuscript

Manuscripts for Oracle Performance Tuning Case Study

Hands-On Oracle Performance Tuning-CD#01

Hands-On 01 (Why tuning and what is Granule unit)

Learn where to start investigating a performance problem and then solve it. - Manuscript

Hands-On 02 (Memory Space Allocation on the Fly)

Learn how to monitor and change memory space allocation of your organization’s database in case of a performance problem. - Manuscript

Hands-On 03 (Sizing the Shared Pool)

Learn how to monitor and change the memory space allocation for the Shared Pool in the SGA memory in case of performance problems. - Manuscript

Hands-On 04 (Sizing the Buffer Cache)

Learn how to monitor and change the memory space allocation for the Buffer Cache in the SGA memory in case of performance problems. - Manuscript

Hands-On 05 (Measuring the Buffer Cache Hit Ratio)

Learn how to monitor and calculate the Buffer Cache Hit Ratio in the SGA memory in case of performance problems. - Manuscript

Hands-On 06 (Monitor and size the Redo Log buffer)

Learn how to monitor and resize the Redo Log buffer in the SGA memory in case of performance problems. - Manuscript

Hands-On 07 (Database I/O problem)

Learn how to monitor and detect I/O problems of your organization’s database in case of performance problems. - Manuscript

Hands-On 08 (Optimize Sort Operations)

Learn how to optimize sort operations of your organization’s database in case of performance problems. - Manuscript

Hands-On 09 (Diagnosing Contention for Latches)

Learn how to diagnose any latch contentions in the Shared Pool area in case of performance problems. - Manuscript

Hands-On 10 (Tuning rollback or undo segment)

Learn how to tune rollback or undo segments in case of performance problems. - Manuscript

Hands-On 11 (Monitoring and Detecting Lock Contention)

Learn how to monitor and detect a lock contention in case of a performance problem. - Manuscript

Hands-On 12 (Optimizing a SQL statement)

Learn how to optimize a SQL statement using the EXPLAIN PLAN statement in case of performance problems. - Manuscript

Hands-On 13 (Diagnostic and Tuning Tools)

Learn how to use and read the STATSPACK tool in a case of a performance problem. - Manuscript

Oracle Enterprise Manager Case Study

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

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

Learn how to add databases to the Oracle Enterprise Manager. Learn how to discover the node to your OEM and how to start and shut down a database. - Manuscript

Hands-On 02 (Managing Users using OEM)

Learn how to manage (create, drop, and maintain) an Oracle user account using OEM tool. - Manuscript

Hands-On 03 (Managing Roles using OEM)

Learn how to manage (create, drop, and maintain) an Oracle role using OEM tool. - Manuscript

Hands-On 04 (Managing Profiles using OEM)

Learn how to manage (create, drop, and maintain) an Oracle profile using OEM tool. - Manuscript

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

Learn how to manage (create, drop, and maintain) an Oracle tablespace and datafile using OEM tool. - Manuscript

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

Learn how to obtain database structure information such as control files, redo log files, and archived redo log files. - Manuscript

Hands-On 07 (Managing Database Objects using OEM)

Learn how to manage database objects such as creating a table, adding columns and datatypes, changing column attributes, defining a default storage parameter, creating a public synonym, and obtaining SQL statement syntaxes. - Manuscript

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

Learn how to optimize a SQL statement. Learn how to use the top session tool, select a target database, obtain information about a SQL Statement, browse a SQL Statement in the memory, run the EXPLAIN PLAN statement, obtain table access information. - Manuscript

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

Learn how to manage a group’s item and an event’s item. You will learn how to create a Group, obtain a background picture, assign databases to a group, create an Oracle Event, Assign Access Privileges of an Event, assign target database to an Event, test a created event, schedule a frequent run of an Event, notify users, register an Event, add an Event to the Repository Library, refresh the CONSOLE, and obtain a Red Flag. - Manuscript

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

Learn how to obtain database information. You will learn how to obtaining the “Disk space used by tables” report, select a target database, obtain the “Instance” report, obtain “SGA” information, obtain the “Security” report, obtain user information, obtain profile information, obtain role information, obtain the “Storage” report, obtain tablespace information, obtain datafile information, obtain rollback segment information, and obtain redo log and archive log information. - Manuscript

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

Learn how to obtain statistical information about the memory for performance and tuning purposes. You will learn how to use the Diagnostics Pack Tool, select a target database, obtain Session CPU Activity, obtain Session Memory Use, obtain Session Efficiency, obtain Memory Size, obtain I/O statistics, obtain Session Identification, obtain detailed session information, and obtain SQL statements. - Manuscript

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

Learn how to obtain SQL statement information for performance tuning purposes. You will learn how to select a target database, obtain the “Disk Reads Per Execution” output, obtain the “Buffer Gets Per Execution” output, obtain the “Execution” output, obtain the “Disk Reads” output, obtain the “Buffer Gets” output, and obtain the “Hit Ratio” output. - Manuscript

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

Learn how to detect a session lock problem. You will learn how to use the “Lock Monitor” tool, select a target database, identify the Lock Session, obtain locked users, obtain a user’s lock mode, resolve lock contentions. - Manuscript

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

Learn how to obtain disk I/Os for performance tuning purposes. - Manuscript

Hands-On 15 (Scheduling a Database backup)

Learn how to schedule a Database backup for your organization’s database. - Manuscript

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

Learn how to perform a logical backup and restore (using export and import tools) of your organization’s database in case of a disaster. - Manuscript