From Serebra Learning Corporation
Oracle 8i DBA - Oracle Instance, the Start-up and Shutdown Procedure 
The course is aimed at familiarizing the learner with the
Oracle instance. It teaches you the learner about the startup and shutdown processes and the different stages of startup and shutdown. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping you the learner type in the commands
more...
Oracle 8i DBA - Data Dictionary and Database Files 
The course is aimed at familiarizing the student with the
Data Dictionary views and database files. The course enables the learner to manage log and control files. The uses and contents of control files will be discussed as well as obtaining information from control files. The planning use and troubleshooting of redo log files will also be explained. The course also provides a list of
Data more...
Oracle 8i DBA - Oracle Storage Architecture 
...DBA the necessary knowledge and skills to manage data storage. It will provide detailed information about logical structures such as tablespaces segments extents and
Oracle data blocks. The creation and management of rollback segments will also be covered. The course also provides a list of data dictionary views that help in managing these logical structures. The course initiates you the
more...
Oracle 8i DBA - Understanding Storage Allocation 
This course covers the various aspects of optimizing database objects. It discusses tables clusters and index-organized tables. This course explains the different types of tables supported by
Oracle 8i the structure of a row the different data types supported by Oracle 8i and the guidelines to create a table. Further the course covers how to create the cluster the cluster index and the tables in
more...
Oracle 8i DBA - Managing Oracle Database Security 
This course is aimed to familiarize the learner with the basic concepts of
Oracle 8i administration of security user roles and resources. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping the learner to type-in the commands to perform administrative tasks. Related
Exam:
Oracle more...
From 123-CBT Computer Based Training
Oracle9i Peformance Tuning Managing Memory and Disk I O 

...criptions. o
Identify the two parameters that allow the
DBA to limit the amount of memory used for each
Java session. o Identify the performance guidelines to reduce the activity on an overloaded disk. o Identify the methods of striping. o Identify the initialization parameter that indicates the size of read calls during full table scans. Audience The intended audience for this
more...
Oracle9i Performance Tuning Architecture Strategy 

...er process trace files. o
Identify the functions of the
DBA views used to provide data storage statistics. o
Match the dynamic performance views with the statistics they provide. o Match the V$ views used to collect system-wide statistics with their functions. o Identify the factors taken into consideration in selecting the physical structure for data. o Match the index types with
more...
Oracle9i Database Admin Perform Database Backups 

...efining a backup and recovery strategy. Match the
DBA consideration to the backup and recovery results. Multiplex control files by copying them with an operating system utility. Match the key
Oracle server file structures with their uses. Differentiate between the user and server processes for user interaction with a database. Match the key Oracle memory
more...
Oracle9i Database Admin Manage an Instance 

...res of a process commit. Identify the tasks of a
DBA and the
Oracle Enterprise Manager tools used by a DBA. Identify the
OEM console components, steps to set up these components, and the functions of the
OEM DBA tools. Identify the default DBA user accounts and set up authentication methods to validate users. Identify the parameters stored in the parameter
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention 

... of database storageunits to their definition.
Query the dba_tables to display segments with less than 10% free blocks.
Manually allocate an extent.
Choose the advantages of incorporating large extents into database design.
Identify characteristics of
Oracle data block size.
Identify characteristics of small data block and large data block sizes.
Run scripts to create and view the
more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery 

...loss of control file.
Identify the situations in which a
DBA is confronted with recovering or recreating control files.
Identify the recovery methods for a corrupted data file.
Identify the methods to recreate a lost recovery catalog.
Unit 4:
Oracle Standby Database
Duration: 2 Hour(s)
Identify the features of a standby database.
Identify the need of a standby database.
Identify
more...
Oracle 11i10 System Admin DBA Activities 

...arners will be introduced to different tasks and duties a
DBA and a system administrator perform to administer
Oracle Applications. The tasks and duties discussed in this course are
Application DBA duties, folder administration, custom program addition, help customization, and document sequencing.
Learn To:
Identify the steps for assigning resource consumer groups.
Identify features
more...
Oracle e-Business 11i System Admin Fundamentals 3 

... course focuses on the management of printers and various
DBA miscellaneous duties such as application-related duties, incorporating custom
Help files, and managing folders and document sequences.
Learn To:
Identify fundamental features of printers in an
Oracle applications environment.
Identify guidelines for defining printers.
Identify features of printing with
Pasta.
Identify
more...