Vi ste ovdje
Overview/Description
To discuss the new installation and configuration features of Oracle 10g
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 10g: New Installation and Configuration Features
identify the products and components of the Oracle 10g grid computing infrastructure.
identify the installation improvements to Oracle...
Overview/Description
To identify the new resource, scheduling, and task-management features of Oracle 10g
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
3.2
Lesson ObjectivesOracle Database 10g: New Resource, Scheduling, and Task-Management Features
use the new resource-plan timeout and session mapping features of Resource Manager in Oracle Database 10g.
use the...
Overview/Description
To identify the new space management features of Oracle 10g
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 10g: New Space Management Features
identify the new features of undo management and their functions in Oracle Database 10g.
set tablespace space usage thresholds in Oracle Database 10g.
set a space...
Overview/Description
To identify the new storage features of Oracle Database 10g
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
3.0
Lesson ObjectivesOracle Database 10g: New Storage Features
use the tools to manage the SYSAUX tablespace and its occupants in Oracle Database 10g.
rename a tablespace and define a default permanent tablespace in Oracle Database 10g....
Overview/Description
To use Oracle 10g's new tuning, performance-monitoring, and analysis features
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
3.0
Lesson ObjectivesOracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features
identify how to use the new optimizer statistics in Oracle Database 10g.
use the SQL Tuning Advisor in a given scenario...
Overview/Description
To provide an overview of Oracle Net Services and Shared Server
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
2.8
Lesson ObjectivesOracle Database 10g: Oracle Net Services and Shared Servers Release 2
recognize how to create and configure an Oracle Net listener in Oracle Database 10g.
recognize how to monitor Oracle Net Services using the Listener Control utility.
create and configure an Oracle Net Listener.
configure local name...
Overview/Description
To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
2.0
Lesson ObjectivesOracle Database 10g: The SQL*Loader and PL/SQL Release 2
identify the function of the SQL*Loader and the files it uses.
recognize how to load data using the SQL*Loader.
load data using the SQL*Loader.
identify the characteristics of PL/SQL objects, functions, and procedures....
Overview/Description
To explain how to manage users, implement security, and audit database activity on an Oracle 10g database
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
3.3
Lesson ObjectivesOracle Database 10g: Users and Security Release 2
recognize how to create user accounts and profiles.
recognize how to grant privileges and assign quotas to users.
recognize how to create a role and assign it to a user.
administer user accounts on an Oracle 10g...
Overview/Description
To recognize Oracle 10g's Flashback technology and use Flashback features
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 10g: Using Flashback
recognize flashback technology and its features.
use Flashback Database in a given scenario.
use Enterprise Manager to flash back a dropped table in a given scenario...
Overview/Description
To use Oracle-supplied packages
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
2.8
Lesson ObjectivesOracle-Supplied Packages and DBMS_SCHEDULER
use the DBMS_OUTPUT package to send a message...