Oracle 10g Administration
Computer
Comprehensive, hands-on class focusing on the day-to-day tasks a DBA will perform to create, maintain and manage an Oracle 10g Database such as security, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data Dictionary and Oracle 10g architecture; Administrative Users; Instances; Initialization Parameter Files; creating and managing Users; Password management; Auditing; Security; creating & managing Tablespaces, Heap Tables and Constraints; B-Tree Tables; managing Undo, Redo Logs and Control Files; backup and recovery with Oracle RMAN; SQL*Loader; an introduction to Oracle Networking and a comprehensive overview of creating an Oracle 10g database. Time-permitting, optional topics include Automatic Storage Management (ASM), Partitioning, other Table types, and Logical Backups with Original Export/ Import Utilities.
This training course has been completely updated for Oracle10g. This includes training on Data Pump, Server-Generated Alerts, Advisors, Automatic Statistics Collection and Auditing Enhancements. Working examples are included throughout the course. Students have access to electronic versions of all examples, sample scripts and lab solutions. Approximately 50 of class time is spent on hands-on exercises.
LEARNING OBJECTIVES
Describe the major architectural components of Oracle10g, including the SGA, background processes and files that make up the physical database.
Use the Oracle data dictionary to to determine the structure and status of the database. This includes gaining a solid understanding of the purpose and content of many V$ and DBA-level views.
Create administrative users, including granting and using the SYSDBA privilege. Understand the purpose of Oracle supplied users SYS and SYSTEM.
Connect to the Oracle database as SYSDBA, both from a host server or - via the use of password files - over a network.
Start and stop an Oracle database, including the use of various shutdown modes such as IMMEDIATE, TRANSACTIONAL and ABORT.
View and alter initialization parameter values, create and startup with secondary parameter files. This includes training on the use of the Server Parameter File, introduced with Oracle9i.
Create new Oracle users, provide tablespace quota and grant them the system or object privileges necessary to perform their work, including the use of roles. Secure the default users provided with database installation.
Implement the Oracle user password management features such as password expiration, account locking, password reuse prevention and password complexity enforcement.
Implement Oracle database auditing to track SYSDBA activity and general user activity. Also, code simple triggers to audit table data changes.
Create and manage locally managed tablespaces including monitoring space usage and adding space
Implement Automatic Segment Space Management to efficiently manage free and used space within extents.
Using the Oracle Managed Files feature to control placement of and name the underlying datafiles.
Manage storage for Oracle objects with disk striping and buffer pool assignment.
Use Automatic Storage Management (ASM) to control file allocation, placement, striping and mirroring (this is an optional lesson)
Describe the different types and typical uses of Oracle tables, including heap, index-organized and clustered tables.
Create and manage heap-tables, including managing concurrency with the INITTRANS and MAXTRANS parameters, moving tables, using DBMS_STATS to collect statistics and increasing and measuring the performance benefits of NOLOGGING and table compression.
Describe the different types of Oracle indexes including B-tree, bitmap and reverse key.
Create simple B-Tree indexes on tables. This includes understanding the fundamental rules for when and where to create and when to avoid using indexes. Also implement index options such as NOLOGGING.
Create constraints on tables including the use of options such as NOVALIDATE to allow existing legacy data with constraint violations.
Describe the techniques for managing undo, including the Oracle9i Automatic Undo Management feature.
Implement Automatic Undo Management including creating and enabling new undo tablespaces and monitoring for space-related problems. Use the Oracle10g Undo Advisor to assist with undo management.
Manage the database redo logs including archiving, multiplexing and adding additional logs. Also, ensure that the database is recoverable by checking the archive log status of the database. Use the Oracle10g Redo Log Advisor to obtain log size advice.
Understand the role and importance of control files. Add additional control files. Backup and recreate control files.
Use the basic features of Recovery Manager to perform simple backup and recovery operations in the event of a lost or corrupted datafile.
Use the 10g Data Pump utility perform logical backups or move or copy objects.
Use the SQL*Loader utility to load data into the database.
Configure Oracle Net (SQL*Net) to connect to and listen for connections. Manage the database listener with the listener control utility.
Create a new database with the Database Configuration Assistant.
Optional lessons include: Introduction to Partitioning, Other Table Types and Original Import / Export Utility
This training course contains a lot of information, sometimes too much for 5 days. The pre-existing knowledge of the student(s) will dictate how many days of instructor-led training are required. For example, if the students have no prior administration experience with a relational database, we recommend either allocating 8 days, or deleting some lessons from the lesson plan. However, if the students are veteran DB2 or Sybase administrator's, it is quite possible that all topics can be covered in 5 days.
Prerequisites: You must have experience working with Oracle to successfully master the information in this course. Specifically, you must have solid Oracle SQL experience and familiarity with SQL*Plus and PL/ SQL. You can obtain this training in STA's classes Introduction Oracle 10g SQL and Introduction to Oracle10g PL /SQL.
Audience: Database administrators and System Administrators
This training course has been completely updated for Oracle10g. This includes training on Data Pump, Server-Generated Alerts, Advisors, Automatic Statistics Collection and Auditing Enhancements. Working examples are included throughout the course. Students have access to electronic versions of all examples, sample scripts and lab solutions. Approximately 50 of class time is spent on hands-on exercises.
LEARNING OBJECTIVES
Describe the major architectural components of Oracle10g, including the SGA, background processes and files that make up the physical database.
Use the Oracle data dictionary to to determine the structure and status of the database. This includes gaining a solid understanding of the purpose and content of many V$ and DBA-level views.
Create administrative users, including granting and using the SYSDBA privilege. Understand the purpose of Oracle supplied users SYS and SYSTEM.
Connect to the Oracle database as SYSDBA, both from a host server or - via the use of password files - over a network.
Start and stop an Oracle database, including the use of various shutdown modes such as IMMEDIATE, TRANSACTIONAL and ABORT.
View and alter initialization parameter values, create and startup with secondary parameter files. This includes training on the use of the Server Parameter File, introduced with Oracle9i.
Create new Oracle users, provide tablespace quota and grant them the system or object privileges necessary to perform their work, including the use of roles. Secure the default users provided with database installation.
Implement the Oracle user password management features such as password expiration, account locking, password reuse prevention and password complexity enforcement.
Implement Oracle database auditing to track SYSDBA activity and general user activity. Also, code simple triggers to audit table data changes.
Create and manage locally managed tablespaces including monitoring space usage and adding space
Implement Automatic Segment Space Management to efficiently manage free and used space within extents.
Using the Oracle Managed Files feature to control placement of and name the underlying datafiles.
Manage storage for Oracle objects with disk striping and buffer pool assignment.
Use Automatic Storage Management (ASM) to control file allocation, placement, striping and mirroring (this is an optional lesson)
Describe the different types and typical uses of Oracle tables, including heap, index-organized and clustered tables.
Create and manage heap-tables, including managing concurrency with the INITTRANS and MAXTRANS parameters, moving tables, using DBMS_STATS to collect statistics and increasing and measuring the performance benefits of NOLOGGING and table compression.
Describe the different types of Oracle indexes including B-tree, bitmap and reverse key.
Create simple B-Tree indexes on tables. This includes understanding the fundamental rules for when and where to create and when to avoid using indexes. Also implement index options such as NOLOGGING.
Create constraints on tables including the use of options such as NOVALIDATE to allow existing legacy data with constraint violations.
Describe the techniques for managing undo, including the Oracle9i Automatic Undo Management feature.
Implement Automatic Undo Management including creating and enabling new undo tablespaces and monitoring for space-related problems. Use the Oracle10g Undo Advisor to assist with undo management.
Manage the database redo logs including archiving, multiplexing and adding additional logs. Also, ensure that the database is recoverable by checking the archive log status of the database. Use the Oracle10g Redo Log Advisor to obtain log size advice.
Understand the role and importance of control files. Add additional control files. Backup and recreate control files.
Use the basic features of Recovery Manager to perform simple backup and recovery operations in the event of a lost or corrupted datafile.
Use the 10g Data Pump utility perform logical backups or move or copy objects.
Use the SQL*Loader utility to load data into the database.
Configure Oracle Net (SQL*Net) to connect to and listen for connections. Manage the database listener with the listener control utility.
Create a new database with the Database Configuration Assistant.
Optional lessons include: Introduction to Partitioning, Other Table Types and Original Import / Export Utility
This training course contains a lot of information, sometimes too much for 5 days. The pre-existing knowledge of the student(s) will dictate how many days of instructor-led training are required. For example, if the students have no prior administration experience with a relational database, we recommend either allocating 8 days, or deleting some lessons from the lesson plan. However, if the students are veteran DB2 or Sybase administrator's, it is quite possible that all topics can be covered in 5 days.
Prerequisites: You must have experience working with Oracle to successfully master the information in this course. Specifically, you must have solid Oracle SQL experience and familiarity with SQL*Plus and PL/ SQL. You can obtain this training in STA's classes Introduction Oracle 10g SQL and Introduction to Oracle10g PL /SQL.
Audience: Database administrators and System Administrators
|
|
||||||||||||||||
Training
Provided by Software Training Academy, Inc
- G asked: Dear Sir/ Madam, Please send the Oracle g Administration I, II explanation guide with examples. Thanks in advance, Regards,
Oracle 10g Administration
1. A DBA's Introduction to the Oracle Data Dictionary
Introduction
What is the Dictionary?
Static Views
Common DBA Views
Example: DBA_USERS
Example: DBA_SYS_PRIVS
Dynamic Performance Views
Example: V$PARAMETER
Miscellaneous Views
DICTIONARY View
Data Dictionary Workshop
2. Oracle10g Architecture, Part I
Database and Instance
Database Files
Segments and Extents
Query DBA_DATA_FILES
Query DBA_SEGMENTS
Redo Log Files
Control Files
Temp Files
Parameter Files
Password Files
Architecture: Files Workshop
3. Oracle10g Architecture, Part II
The Processes
Query V$BGPROCESS
Database Block Writer
Log Writer - LGWR
System Monitor - SMON
Process Monitor - PMON
Checkpoint - CKPT
Archiver - ARCn
Miscellaneous Processes (10g Enhancements)
Architecture: Processes Workshop
4. Oracle10g Architecture, Part III
PGA and UGA
The Oracle10g SGA
Size of SGA Areas
Shared Pool
Impact of Automatic Workload Repository (10g)
Library Cache
Library Cache Retention
SQL Statement Processing
Data Dictionary Cache
Buffer Cache
Database Block Size
Non-Standard DB Size
Keep and Recycle Caches
Redo Log Buffer
Large Pool / Java Pool / Streams Pool
Architecture: Memory Areas Workshop
5. Oracle10g Administrative Users
The SYS User
The SYSTEM User
SYSDBA Privilege
DBA Role
Local Connections
Remote Connections
Creating a Password File
Password File Entries
Create New Administrators
Administrative Users Workshop
6. Starting and Stopping an Oracle Instance
STARTUP Procedures
SQL*Plus for Startup
Connecting for STARTUP
10g Connect String Enhancements (10g)
Startup/ Shutdown Basics
Startup Basics Workshop
Stages Of STARTUP
STARTUP Command
ALTER DATABASE
Startup MOUNT Workshop
Restricted Access
Shutting Down
Shutdown Workshop
7. Oracle10g Initialization Parameter Files
Review: Parameter Files
Text Parameter File
Introduction to SPFILE
Benefits of SPFILE
Creating an SPFILE
CREATE SPFILE Notes
Using SPFILE
Parameter Overrides
Am I Using SPFILE?
Helpful Dictionary Views
Export & Backup
Modifying Parameters
SCOPE Clause
Dynamic Parameters
Server Parameter Files Workshop
8. Creating and Managing Users
Creating New Users
Intro to User Privileges
Default and Temporary Parameters
Default Permanent Tablespace (10g)
Querying the Data Dictionary
Altering a User
Dropping a User
Terminating a User Session
User Basics Workshop
Introduction to Quota
Providing Quota
Unlimited and Zero Quota
Query Existing Quotas
User Space Used
Installation Users
Secure Installation Users
User Quota & Account Status Workshop
9. Oracle10g Password Management
Password Aging
Manual Password Expiration
Account Locking
Password History
Password Complexity
User Passwords Workshop
10. Introduction to Oracle10g Auditing
Auditing Technique Overview
Enabling the Audit Trail
Auditing SYSDBA
AUDIT Statement
Auditing Logons
Monitoring Logon Attempts
Audit System Grants
Monitor System Grants
Object-Level Auditing
Monitoring Object Activity
10g Enhancements - Additional Data Capture (10g)
The SYSAUD$ Table
Auditing with Triggers
Fine Grained Auditing
Create FGA Policy
Display FGA Activity
Fine Grained Auditing of DML (10g)
Auditing Workshop
11. Managing Security in Oracle10g
Security Basics
Privilege Types
System Privileges
ANY-Type Privileges
PUBLIC Keyword
ADMIN OPTION
Revoking System Privileges
SESSION_PRIVS
DBA_SYS_PRIVS
System Privileges Workshop
Object Privileges
Grant Object-Level Privileges
Insert / Update Privileges
WITH GRANT OPTION
Revoking Object Privileges
DBA_TAB_PRIVS
Object Privileges Workshop
Role Concepts
Predefined Roles
Giving Privileges To Roles
WITH ADMIN OPTION
Granting Role to Role
Role Privileges
PL/ SQL and Roles
Revoking Roles
Dropping Roles
Data Dictionary Summary
Miscellaneous Role Topics
Roles Workshop
12. Creating and Managing Oracle10g Tablespaces
What is a Tablespace?
Data Dictionary
Why Tablespaces?
Locally Managed Tablespaces
Tablespace Basics Workshop
Tablespace Parameter
System-Managed LMT
Uniform LMT's
Bigfile Tablespaces (10g)
Automatic Segment Space Management
Oracle Managed Files
OMF Key Points
Configuration and File Location
Striping Overview
Non-Standard Blocksize
Benefits of Non-Standard Blocksize
Monitoring Free Space
Adding Space
Offline Tablespace
Read-Only Tablespace
Dropping Tablespaces
Managing the SYSTEM Tablespace
Managing the SYSAUX Tablespace (10g)
Temporary Tablespace and Temporary Tablespace Groups (10g)
Tablespaces Workshop
13. Proactive Maintenance with Server-Generated Alerts (10g)
Concepts and Alert Architecture
Threshold-Based Alerts
Default Thresholds
Setting Custom Thresholds
Enterprise Manager Notifications
Display Alert Data in the Data Dictionary
Workshop
14. Creating and Managing Oracle10g Heap Tables
Types of Tables
CREATE TABLE Statement
Column Definition
Character and Numeric Datatypes
Date and Time Datatypes
Binary Datatypes
ANSI and Miscellaneous Datatypes
Table Create Workshop
Create Table As Subquery
CTAS Options
CTAS Workshop
Collecting Statistics
Oracle10g Automatic Statistics Collection (10g)
GATHER_SCHEMA_STATS
Gather Database Stats
Table MONITORING
Additional STATS Features
DBMS_STATS Workshop
Managing Table Storage
INITRANS & MAXTRANS
NOLOGGING
Mini-Workshop
Table Compression
Table Compression Workshop
ALTER TABLE MOVE
CTAS Nologging
DROP Column
Renaming Tables
Renaming Columns
Where To Go From Here
15. B-Tree Indexes
Indexes: What and Why
Index Structures
B-Tree Organization
Unique Index Scan
AUTOTRACE
Important Points
CREATE INDEX
NOLOGGING
Statistics Collection
Indexes Workshop
Composite Indexes
Which Column First?
Index Key Compression
Descending Keys
Index Coalesce
Choosing Index Columns
Calculating Selectivity
Where to Look Next
Composite Index Workshop
16. Creating and Managing Constraints
Introduction to Constraints
Inline Syntax
Out-of-Line Syntax
Constraint Name
Violating Constraint
Constraints Workshop
Referential Integrity
Alter to Add Constraint
Identifying Exceptions
Constraint Exceptions Workshop
NOVALIDATE Option
Primary Key Index
USING INDEX Option
Modify State
Drop Constraint
Rename Constraint
Data Dictionary
Constraint Indexes Workshop
17. Managing Undo in Oracle10g
What is Undo?
Where is Undo Kept?
Why Not Rollback Segments?
Why AUM?
Implementing AUM
Find Undo Tablespace
Create Undo Tablespace
Guaranteed Retention (10g)
Initialization Parameters
Switching Undo Tablespace
Dropping Undo Tablespace
Data Dictionary Views
Tuning AUM
Adding Space
Using the Oracle10g Undo Advisor (10g)
Resources
Automatic Undo Management Workshop
18. Managing Redo Logs
Review: Concepts
DBAs Responsibilities
Archiving Status
Enabling Archiving
Archiving Workshop
Multiplexing Archive Logs
Multiplex Archive Logs Workshop
Log Switch Delays
Adding Log Files
Using the 10g Redo Log Advisor (10g)
Review of OMF
Adding Log Files - OMF
Multiplexing Online Logs
Add Redo Log Workshop
19. Managing Control Files
Control File Review
DBA Responsibilities
Adding Control Files
Add Control File Workshop
Backing Up Control File
Recreating Control File
Optional Create Control File Workshop
20. Oracle10g Backup and Recovery Basics - Introduction to RMAN
What is RMAN?
RMAN Components
Starting and Connecting
Common RMAN Commands
Backup Concepts
Full Backup
Full Tablespace Backup
Datafile Backup
Incremental Backup
Change Tracking (10g)
Backups - Where to go from here
RESTORE Command
RECOVER Command
Complete Recovery - Database
Recover Tablespace
Reporting
Report Need Backup
Show Stored Settings
What Else is There?
Getting More Information
RMAN Workshop
21. Importing and Exporting with DataPump (10g)
Data Pump Concepts
Data Pump Modes
Data Pump Access Methods
Parallel Processing
Export Example
Import Example
Data Pump Features
Network Export / Import
Network Import Example
DBMS_DATAPUMP
Data Pump Dictionary
Datapump Resources
Affect on External Tables
Workshop
22. SQL*Loader
Introduction
Executing SQL*Loader
The Control File
Variable Format Data
Fixed Format Data
LOG File
Conditional Loads
SQL*Loader Workshop
23. Introduction to Oracle Networking
Introduction to Oracle Net
Configuration Files
TNSNAMESORA
Introduction to the Listener
Listener Control Utility
Stopping the Listener
Listener Password
LISTENER. ORA
Resources
Oracle Net Workshop
24. Creating a new Oracle Database
Major Steps
What We Need to Know
The Oracle SID
Windows Services
Seeing the Active Threads
Listing Active Instances
Stopping Active Instances
Database Configuration Assistant
Step 1: Select Operation
Step 2: Select Template
Step 3: Database ID
Step 4: Database Features
Step 5: Database Connection Options
Step 6: Init Parameters
Step 7: Database Storage
Step 8: Create Options
The BAT File
ORADIM
CREATEDB Script
Create New Database Workshop
25. Optional: Automatic Storage Management (10g)
Introducing ASM
The ASM Instance
Starting the ASM Instance
ASM Disks
ASM Diskgroups
Creating Diskgroup
Altering Diskgroup
Working in the Database Instance
Tablespace Management in ASM
Workshop
26. Optional: Introduction to Oracle Partitioning
Partitioning History
Range Partitioning
MAXVALUE and NULLs
Partition Storage Attributes
Multiple-Column Partitioning
Hash Partitioning
Composite Partitioning
List Partitioning
Composite Range-List Partitioning
Subpartition Template
IOT and Hash Partitioning
Global Indexes and Partitioning Maintenance
Row Movement
Maintenance: Rolling In
Maintenance: Rolling Out
Merge Partitions
Other Maintenance Operations
Data Dictionary Implications
Finding the Partitioning Key
Finding the Partitioning Bounds
Explicit Referencing
Table Partitioning Restrictions
27. Optional: Introduction to Other Table Types
Index Organized Tables
Temporary Tables
Concepts
Temporary Tables Management
Creating Temporary Tables
Index Clustered Tables
Hash Clustered Tables
Sorted Hash Clusters (10g)
Nested Tables
Object Tables
28. Optional : Logical Backups with Original Export/ Import Utilities
Introduction
Export Modes
User-Mode Export
Export Features
Import
Using Import
Resources
Logical Backups Workshop
Introduction
What is the Dictionary?
Static Views
Common DBA Views
Example: DBA_USERS
Example: DBA_SYS_PRIVS
Dynamic Performance Views
Example: V$PARAMETER
Miscellaneous Views
DICTIONARY View
Data Dictionary Workshop
2. Oracle10g Architecture, Part I
Database and Instance
Database Files
Segments and Extents
Query DBA_DATA_FILES
Query DBA_SEGMENTS
Redo Log Files
Control Files
Temp Files
Parameter Files
Password Files
Architecture: Files Workshop
3. Oracle10g Architecture, Part II
The Processes
Query V$BGPROCESS
Database Block Writer
Log Writer - LGWR
System Monitor - SMON
Process Monitor - PMON
Checkpoint - CKPT
Archiver - ARCn
Miscellaneous Processes (10g Enhancements)
Architecture: Processes Workshop
4. Oracle10g Architecture, Part III
PGA and UGA
The Oracle10g SGA
Size of SGA Areas
Shared Pool
Impact of Automatic Workload Repository (10g)
Library Cache
Library Cache Retention
SQL Statement Processing
Data Dictionary Cache
Buffer Cache
Database Block Size
Non-Standard DB Size
Keep and Recycle Caches
Redo Log Buffer
Large Pool / Java Pool / Streams Pool
Architecture: Memory Areas Workshop
5. Oracle10g Administrative Users
The SYS User
The SYSTEM User
SYSDBA Privilege
DBA Role
Local Connections
Remote Connections
Creating a Password File
Password File Entries
Create New Administrators
Administrative Users Workshop
6. Starting and Stopping an Oracle Instance
STARTUP Procedures
SQL*Plus for Startup
Connecting for STARTUP
10g Connect String Enhancements (10g)
Startup/ Shutdown Basics
Startup Basics Workshop
Stages Of STARTUP
STARTUP Command
ALTER DATABASE
Startup MOUNT Workshop
Restricted Access
Shutting Down
Shutdown Workshop
7. Oracle10g Initialization Parameter Files
Review: Parameter Files
Text Parameter File
Introduction to SPFILE
Benefits of SPFILE
Creating an SPFILE
CREATE SPFILE Notes
Using SPFILE
Parameter Overrides
Am I Using SPFILE?
Helpful Dictionary Views
Export & Backup
Modifying Parameters
SCOPE Clause
Dynamic Parameters
Server Parameter Files Workshop
8. Creating and Managing Users
Creating New Users
Intro to User Privileges
Default and Temporary Parameters
Default Permanent Tablespace (10g)
Querying the Data Dictionary
Altering a User
Dropping a User
Terminating a User Session
User Basics Workshop
Introduction to Quota
Providing Quota
Unlimited and Zero Quota
Query Existing Quotas
User Space Used
Installation Users
Secure Installation Users
User Quota & Account Status Workshop
9. Oracle10g Password Management
Password Aging
Manual Password Expiration
Account Locking
Password History
Password Complexity
User Passwords Workshop
10. Introduction to Oracle10g Auditing
Auditing Technique Overview
Enabling the Audit Trail
Auditing SYSDBA
AUDIT Statement
Auditing Logons
Monitoring Logon Attempts
Audit System Grants
Monitor System Grants
Object-Level Auditing
Monitoring Object Activity
10g Enhancements - Additional Data Capture (10g)
The SYSAUD$ Table
Auditing with Triggers
Fine Grained Auditing
Create FGA Policy
Display FGA Activity
Fine Grained Auditing of DML (10g)
Auditing Workshop
11. Managing Security in Oracle10g
Security Basics
Privilege Types
System Privileges
ANY-Type Privileges
PUBLIC Keyword
ADMIN OPTION
Revoking System Privileges
SESSION_PRIVS
DBA_SYS_PRIVS
System Privileges Workshop
Object Privileges
Grant Object-Level Privileges
Insert / Update Privileges
WITH GRANT OPTION
Revoking Object Privileges
DBA_TAB_PRIVS
Object Privileges Workshop
Role Concepts
Predefined Roles
Giving Privileges To Roles
WITH ADMIN OPTION
Granting Role to Role
Role Privileges
PL/ SQL and Roles
Revoking Roles
Dropping Roles
Data Dictionary Summary
Miscellaneous Role Topics
Roles Workshop
12. Creating and Managing Oracle10g Tablespaces
What is a Tablespace?
Data Dictionary
Why Tablespaces?
Locally Managed Tablespaces
Tablespace Basics Workshop
Tablespace Parameter
System-Managed LMT
Uniform LMT's
Bigfile Tablespaces (10g)
Automatic Segment Space Management
Oracle Managed Files
OMF Key Points
Configuration and File Location
Striping Overview
Non-Standard Blocksize
Benefits of Non-Standard Blocksize
Monitoring Free Space
Adding Space
Offline Tablespace
Read-Only Tablespace
Dropping Tablespaces
Managing the SYSTEM Tablespace
Managing the SYSAUX Tablespace (10g)
Temporary Tablespace and Temporary Tablespace Groups (10g)
Tablespaces Workshop
13. Proactive Maintenance with Server-Generated Alerts (10g)
Concepts and Alert Architecture
Threshold-Based Alerts
Default Thresholds
Setting Custom Thresholds
Enterprise Manager Notifications
Display Alert Data in the Data Dictionary
Workshop
14. Creating and Managing Oracle10g Heap Tables
Types of Tables
CREATE TABLE Statement
Column Definition
Character and Numeric Datatypes
Date and Time Datatypes
Binary Datatypes
ANSI and Miscellaneous Datatypes
Table Create Workshop
Create Table As Subquery
CTAS Options
CTAS Workshop
Collecting Statistics
Oracle10g Automatic Statistics Collection (10g)
GATHER_SCHEMA_STATS
Gather Database Stats
Table MONITORING
Additional STATS Features
DBMS_STATS Workshop
Managing Table Storage
INITRANS & MAXTRANS
NOLOGGING
Mini-Workshop
Table Compression
Table Compression Workshop
ALTER TABLE MOVE
CTAS Nologging
DROP Column
Renaming Tables
Renaming Columns
Where To Go From Here
15. B-Tree Indexes
Indexes: What and Why
Index Structures
B-Tree Organization
Unique Index Scan
AUTOTRACE
Important Points
CREATE INDEX
NOLOGGING
Statistics Collection
Indexes Workshop
Composite Indexes
Which Column First?
Index Key Compression
Descending Keys
Index Coalesce
Choosing Index Columns
Calculating Selectivity
Where to Look Next
Composite Index Workshop
16. Creating and Managing Constraints
Introduction to Constraints
Inline Syntax
Out-of-Line Syntax
Constraint Name
Violating Constraint
Constraints Workshop
Referential Integrity
Alter to Add Constraint
Identifying Exceptions
Constraint Exceptions Workshop
NOVALIDATE Option
Primary Key Index
USING INDEX Option
Modify State
Drop Constraint
Rename Constraint
Data Dictionary
Constraint Indexes Workshop
17. Managing Undo in Oracle10g
What is Undo?
Where is Undo Kept?
Why Not Rollback Segments?
Why AUM?
Implementing AUM
Find Undo Tablespace
Create Undo Tablespace
Guaranteed Retention (10g)
Initialization Parameters
Switching Undo Tablespace
Dropping Undo Tablespace
Data Dictionary Views
Tuning AUM
Adding Space
Using the Oracle10g Undo Advisor (10g)
Resources
Automatic Undo Management Workshop
18. Managing Redo Logs
Review: Concepts
DBAs Responsibilities
Archiving Status
Enabling Archiving
Archiving Workshop
Multiplexing Archive Logs
Multiplex Archive Logs Workshop
Log Switch Delays
Adding Log Files
Using the 10g Redo Log Advisor (10g)
Review of OMF
Adding Log Files - OMF
Multiplexing Online Logs
Add Redo Log Workshop
19. Managing Control Files
Control File Review
DBA Responsibilities
Adding Control Files
Add Control File Workshop
Backing Up Control File
Recreating Control File
Optional Create Control File Workshop
20. Oracle10g Backup and Recovery Basics - Introduction to RMAN
What is RMAN?
RMAN Components
Starting and Connecting
Common RMAN Commands
Backup Concepts
Full Backup
Full Tablespace Backup
Datafile Backup
Incremental Backup
Change Tracking (10g)
Backups - Where to go from here
RESTORE Command
RECOVER Command
Complete Recovery - Database
Recover Tablespace
Reporting
Report Need Backup
Show Stored Settings
What Else is There?
Getting More Information
RMAN Workshop
21. Importing and Exporting with DataPump (10g)
Data Pump Concepts
Data Pump Modes
Data Pump Access Methods
Parallel Processing
Export Example
Import Example
Data Pump Features
Network Export / Import
Network Import Example
DBMS_DATAPUMP
Data Pump Dictionary
Datapump Resources
Affect on External Tables
Workshop
22. SQL*Loader
Introduction
Executing SQL*Loader
The Control File
Variable Format Data
Fixed Format Data
LOG File
Conditional Loads
SQL*Loader Workshop
23. Introduction to Oracle Networking
Introduction to Oracle Net
Configuration Files
TNSNAMESORA
Introduction to the Listener
Listener Control Utility
Stopping the Listener
Listener Password
LISTENER. ORA
Resources
Oracle Net Workshop
24. Creating a new Oracle Database
Major Steps
What We Need to Know
The Oracle SID
Windows Services
Seeing the Active Threads
Listing Active Instances
Stopping Active Instances
Database Configuration Assistant
Step 1: Select Operation
Step 2: Select Template
Step 3: Database ID
Step 4: Database Features
Step 5: Database Connection Options
Step 6: Init Parameters
Step 7: Database Storage
Step 8: Create Options
The BAT File
ORADIM
CREATEDB Script
Create New Database Workshop
25. Optional: Automatic Storage Management (10g)
Introducing ASM
The ASM Instance
Starting the ASM Instance
ASM Disks
ASM Diskgroups
Creating Diskgroup
Altering Diskgroup
Working in the Database Instance
Tablespace Management in ASM
Workshop
26. Optional: Introduction to Oracle Partitioning
Partitioning History
Range Partitioning
MAXVALUE and NULLs
Partition Storage Attributes
Multiple-Column Partitioning
Hash Partitioning
Composite Partitioning
List Partitioning
Composite Range-List Partitioning
Subpartition Template
IOT and Hash Partitioning
Global Indexes and Partitioning Maintenance
Row Movement
Maintenance: Rolling In
Maintenance: Rolling Out
Merge Partitions
Other Maintenance Operations
Data Dictionary Implications
Finding the Partitioning Key
Finding the Partitioning Bounds
Explicit Referencing
Table Partitioning Restrictions
27. Optional: Introduction to Other Table Types
Index Organized Tables
Temporary Tables
Concepts
Temporary Tables Management
Creating Temporary Tables
Index Clustered Tables
Hash Clustered Tables
Sorted Hash Clusters (10g)
Nested Tables
Object Tables
28. Optional : Logical Backups with Original Export/ Import Utilities
Introduction
Export Modes
User-Mode Export
Export Features
Import
Using Import
Resources
Logical Backups Workshop
About The Training Provider: Software Training Academy, Inc
Software Training Academy, Inc - Software Training Academy is company based in Seattle, WA (USA) and Toronto, ON (Canada) and it offers highly customized IT Training.
Our portfolio includes Java, .NET, Web Development (PHP, Ruby on Rails, etc), Databases (Oracle, SQL Server, MySQL, DB2, etc) and Advanced courses for Microsoft Office.
We deliver courses either onsite or in class throughout North America and Europe, and...
