Online Trace Files eLearning Training
From Serebra Learning Corporation
Optimizing Database Performance in Oracle 10g
To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors Oracle database administrators and database operators
more...
From 123-CBT Computer Based Training
Oracle9i Performance Tuning Architecture Strategy

...e different methods available for generating user 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
more...
Oracle9i Database Admin Manage an Instance

... of trace and alert files, the parameters controlling the trace files, and the contents of alert files. Identify the character-encoding schemes and the reasons for choosing the national character sets for the database. Identify the database initialization parameters, the derived NLS parameters, and the way to control the sort sequence. Retrieve the data dictionary
more...
Oracle8i Network Administration Net8 Additional Config Troubleshooting

...ant utility with appropriate information from the log and trace files. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315), and the first part in this series, Oracle8i Network
more...
Oracle8i Performance Tuning Architecture Strategy

...ocation and usefulness of the background and user process trace files. Identify different types of events and manage the event system using OEM. Collect statistics using the dynamic troubleshooting and performance views. Diagnose statistics using the UTBSTAT/UTLESTAT output report. Identify appropriate OEM tuning tools. Use the available data access methods to tune the logical design
more...
Oracle8 Performance Tuning Strategies and Techniques

...ocation and usefulness of the background and user process trace files.
Identify different types of events and manage the event system using OEM.
Collect statistics using the dynamic troubleshooting and performance views.
Diagnose statistics using the UTBSTAT/UTLESTAT output report.
Identify appropriate Oracle Enterprise Manager (OEM) tuning tools.
Use the available data access
more...
Oracle8 Network Administration Net8 Configuration and Troubleshooting

...ant utility with appropriate information from the log and trace files. C ontent Emphasis Skills-Based A udience Network administrators, database administrators, technical support analysts, system administrators, application developers, and MIS managers. Participants should be familiar with Oracle8 database administration, or have taken courses 61311, 61312, 61313, 61314, and
more...
Oracle8 Database Administration - Manage an Instance

...ce file.
Specify the parameters that are used to control trace files.
Identify the information stored in a given alert file.
Unit 4: National Language Support (NLS)
Duration: 2 Hour(s)
Identify the features of NLS.
Match the Oracle character encoding scheme classes with their descriptions.
Identify the reasons for choosing a national character set that is specified in a CREATE
more...
Oracle Database 10g Administration Workshop II Part 2

...u to configure alerts.
Identify key concepts related to trace files.
Identify the impact of losing non-critical files.
Sequence the tasks that enable you to recover temporary and index tablespaces.
Sequence the steps to recreate a control file when the original file is lost or corrupted.
Identify features of control file autobackups.
Identify considerations for dropping redo log
more...
