Manuscripts
for Oracle
Fundamentals I Case Study
Hands-On
Oracle Fundamentals I-CD#01 (Database
Administrator-DBA)
Hands-On
01 (The most important Dictionary Views)
Learn how to obtain the most
important dictionary views. - Manuscript
Hands-On
02 (Startup and Shutdown the database)
Learn how to start-up and shut-down
the database. - Manuscript
Hands-On
03 (Multiplexing controlfiles)
Learn how to multiplexing control files.
- Manuscript
Hands-On
04 (Reading the ALERT file)
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
Go
To INDEX
|