|
DBA
Build
your schema to work on iSelfSchooling's Hands-On
In order
to practice the iSelfSchooling's case studies, you need to create a
user named iself with all its necessary tables. There is a script
named "create_tables.sql." If you want you can click here
to download the script on to your c:\ directory. Then sign on to
system/manager user and run the script. ex: SQL> start
c:\create_tables.sql
This
script will create a user named "iself" with password
"schooling" and all its tables. Don't forget that after
downloading any file from anywhere, virus check the file. Good
luck with your setup. --iSelfSchooling.com
SELF-How to Build your "ISELF" Schema
ISELF Schema
Script here
Hands-On Oracle9i Database: Fundamentals I
DBA001-The most important Dictionary Views
DBA002-Startup and Shutdown the database
DBA003-Multiplexing controlfiles
DBA004-Reading the ALERT file
DBA005-Changing the database mode
DBA006-Server Parameter File-SPFILE
DBA007-Configure the database to the archive mode
DBA008-Maintainiing and Relocating the Redo Log files
DBA009-Multiplexing and Maintaining the Online Redo Log files
DBA010-Maintaining Tablespace and Datafiles
DBA011-Maintaining a TEMPORARY tablespace
DBA012-Maintaing a Tablespace
DBA013-Managing Storage Structures
DBA014-Maintaining and Configuring UNDO tablespace
DBA015-Maintaining and Configuring an UNDO tablespace manually
DBA016-Creating and Maintaining a TEMPORARY table
DBA017-Detecting ROW Migration and Chaining
DBA018-Monitoring an object usage
DBA019-EXCEPTIONS INTO EXCEPTIONS
DBA020-Maintaining user's account and profile
DBA021-Auditing a database
DBA022-Creating a new database |
Hands-On Oracle9i Database: Fundamentals II
|
DBAx01-Memory Space Allocation on the fly
DBAx02-Oracle Background Processes
DBAx03-Multiplexing the Control Files (Advanced)
DBAx04-Configuring the Database Archive mode (Advanced)
DBAx05-Maintaining Redo Log Files (Advanced)
DBAx06-Duplexing Archived Online Redo Log Files (Advanced)
DBAx07-User Managed COLD or OFFLINE Backup
DBAx08-User Managed HOT or ONLINE Backup
DBAx09-User Managed Tablespaces and Datafiles Backup
DBAx10-User Managed Tablespace Recovery
DBAx11-User Managed Logical Backup and Recovery
DBAx12-RMAN Managed user and repository (Oracle9i)
DBAx13-Use of the RMAN commands
DBAx14-Configuration of the RMAN tool
DBAx15-Using the RMAN backup utility
DBAx16-RMAN Managed Tablespace Recovery
DBAx17-RMAN Managed Complete Backup
DBAx18-RMAN Managed incomplete database recovery scenario
DBAx19-RMAN Managed incomplete database recovery
DBAx20-RMAN Managed the LIST and REPORT commands
DBAx21-Configuring a LISTENER using the Net Manager Tool
DBAx22-Configuring a Service Name using the Net Manager Tool |
Hands-On Training Performance Tuning
|
PRF001-Why tuning
PRF002-Memory Space Allocation
PRF003-Sizing the Shared Pool
PRF004-Sizing the Buffer Cache
PRF005-Measuring the Buffer Cache Hit Ratio
PRF006-Monitor and size the Redo Log Buffer
PRF007-Database I/O Problem
PRF008-Optimizing Sort Operations
PRF009-Diagnosing Contention for Latches
PRF010-Tuning Rollback or UNDO Segment
PRF011-Monitoring and Detecting Lock Contention
PRF012-Optimizing a SQL Statement
PRF013-Diagnostic and Tuning Tools
(STATSPACK) |
Hands-On Training Oracle Enterprise Manager (OEM)
|
OEM001-Discovering a Server Node
OEM002-Managing Users
OEM003-Managing Roles
OEM004-Managing Profiles
OEM005-Managing Tablespaces and Datafiles
OEM006-Obtaining a database structure
OEM007-Managing Database Objects
OEM008-Optimizing a SQL statement
OEM009-Managing Groups and Events
OEM010-Obtaining a Database Information
OEM011-Obtaining a Memory Statistical
OEM012-Obtaining a SQL Statement Information
OEM013-Detecting a session lock problem
OEM014-Obtaining Disk I/Os
OEM015-Scheduling a database backup
OEM016-Performing a logical backup and restore |
|