Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
courses The smart course guide
Courses    
  Most popular search | Share this page  
open My list: 0 courses
refrigeration fundamentals   fundamentals of refrigeration   full free for the fundamentals of corporate finance   fundamentals of business   fundamentals of automobile air conditioning system   ms word fundamentals   fundamentals of project management   fundamentals of accounting course   fundamentals of accounting   dba, distance, uk
Homepage › IT, Computing, Telecommunications Courses › Database Administration Courses › Oracle Courses

Oracle9i DBA Fundamentals I

in PTR Associates Ltd (England)

Classes Course

Place:

Wokingham

Price:

£2,200 + VAT

Duration:

5 Days

Start:

07/12/2008 calendar
See course programme

Requirements:

Delegates should have attended either the Introduction to Oracle8i or Introduction to Oracle9i course ... see more

Request free information

Course objectives:

This course will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit ...

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
PTR Associates Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 5 Days
Method / place Contact course provider Classes in Wokingham where
Course objectives This course will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit ...
Requirements
Delegates should have attended either the Introduction to Oracle8i or Introduction to Oracle9i course or have at least six months working in an Oracle technical environment. An understanding of relational database concepts, SQL and PL/SQL programming skills are required. A solid understanding of Oracle schema is recommended.
Price £2,200 + VAT
Get direct information on how to enrol, venues and availability...

Oracle courses (from other course providers)

 
Oracle9i Database Fundamentals II 1Z0-032
We Teach You
Distance - £50 + VAT
 
Oracle9i SQL 1z0-007
Sales 101 Ltd
Online - £125 + VAT
Compare the selected courses
+ oracle Courses + Oracle Courses in Berkshire + Courses in Berkshire + PTR Associates Ltd Courses

Course programme

Oracle9i DBA Fundamentals I
Course objectives:
This course will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end. The course will also address issues for DBAs having to support Oracle8i and Oracle9i databases.

Course content:
Understanding the Oracle9i Server Architecture
  • Responsibilities of a DBA
  • Changing DBA Environments
  • What is an Oracle Server?
  • Oracle Versioning
  • Server Architectural Overview
  • Operating System Environment
  • Important Subdirectories in ORACLE_HOME
  • Oracle Product Subdirectories
  • Oracle Instance Components
  • Database, Control, and Redo Log Files
  • Logical Storage Structures
  • Oracle Block Sizes
  • Blocks, Extents, and Segments
  • Different Types of Segments
  • Tablespaces
  • Logical Structural Design
  • System Change Numbers
  • Different Versions of Oracle
  • Oracle8.0 - The Object-Relational Release
  • Oracle Ceilings
  • Additional Database Limits
  • Oracle8i - The Internet Release
  • Oracle9i Release 1- The eBusiness Database
  • Oracle9i Release 2- The Object-Relational OLAP Database
  • Oracle Products and Architectures
  • DBA Management Pack
  • Understanding your Oracle Server Layout
    Oracle Memory Structures and Processes
  • Oracle Instance Review
  • Database Buffer Cache
  • The LRU and Dirty Lists
  • Server Processes and the Buffer Cache
  • DBWR and the Buffer Cache
  • MTTR and Checkpoint intervals
  • Checkpoints
  • V$INSTANCE_RECOVERY View
  • MTTR Advisor
  • Minimal I/O Recovery
  • Defining Multiple DB Cache Buffer Pools
  • Defining the Database Buffer Pools (Oracle8i style)
  • Database Buffer Pool Parameters (Oracle8i style)
  • The Buffer Pool Parameter
  • Defining Storage for Buffer Pools
  • Calculating the Hit Ratio for Buffer Pools and Buffer Pool Sizes
  • Latch Contention
  • Caching Tables
  • Calculating Cache Usage of Schema Objects
  • Redo Log Buffer Cache
  • Shared and Large Pool Area
  • Java Pool Size
  • The Oracle JVM
  • Impacting Server Process Memory
  • Background and Required Background Processes
  • Additional Background Processes
  • Listing Processes
    Server Processes and Executing SQL
  • Server Processes
  • Program and User Global Areas
  • Dedicated and Shared Server Architecture
  • Deprecated and Shared Server Parameters
  • The Parse Phase
  • Execution Plan Phase
  • Execution and Fetch Phase
  • Processing DML Statements
  • Rule-based and Cost-based Optimizers
  • Tuning Parallel Query
  • Parallel DML
    Using the Data Dictionary
  • What is the Oracle Data Dictionary?
  • Base Tables, Static Views, and Dynamic Views in the Data Dictionary
  • ALL_% Static Views
  • DBA_% Static Views
  • USER_% Static Views
  • USER_% Static Views
  • V$ Dynamic Views
  • GV$ Dynamic Views
  • GV$ Dynamic Views
  • Database Data Dictionary Views
    Starting and Shutting Down an Oracle Server
  • Database Utilities
  • The Server Manager Tool (Obsolete in Oracle9i)
  • SQL PLUS Features and Commands
  • Additional Commands
  • The Parameter File
  • Oracle Universal Installer
  • The Database Configuration Assistant
  • Setting up a Parameter File
  • Important Parameters for Database Creation
  • Starting an Oracle Server
  • The STARTUP command
  • Startup and Shutdown Privileges
  • The SHUTDOWN Command
  • ALTER DATABASE Command
  • Alert and Trace Files
  • Working with Data Dictionary Views
  • Dynamic versus Static Parameters
    Server Parameter File
  • Definition of the Server Parameter File (SPFILE)
  • Operation of the SPFILE
  • Creating an SPFILE
  • Changing Parameters in the SPFILE
  • Backing up the SPFILE
  • Gathering Information About Parameters
  • SPFILE FAQs
    Dynamic Memory Management
  • Setting up SQL Work Areas
  • Defining Automatic PGA Memory Management
  • SQL Work Areas versus the PGA Aggregate Target
  • Setting the PGA Target Memory Size
  • Displaying Workarea Information
  • Using a PGA Workarea
  • Dynamic SGA
  • Granules
  • Changing the Database Buffer Cache
  • V$BUFFER_POOL
  • Changing the Shared Pool Size
  • Database Buffer Cache Parameters
  • Multiple Database Buffer Caches
  • Deprecated and Advisory Parameters
  • V$DB_CACHE_ADVICE
    Managing Tablespaces and Data Files
  • Review Logical and Physical Structure Relationships
  • The SYSTEM Tablespace
  • CREATE TABLESPACE
  • Locally-Managed Tablespaces
  • Temporary Tablespaces
  • Temporary Segments
  • Database Default Temporary Tablespace
  • Creating a Default Temporary Tablespace
  • Read-only Tablespaces
  • Viewing Active Transactions
  • Coalescing Dictionary Managed Tablespaces
  • Using the ALTER TABLESPACE command
  • Taking Tablespaces ONLINE and OFFLINE
  • Renaming a Data File
  • Adding More Space to a Database
  • Autoextending a Data File
  • DROP TABLESPACE Command
  • Dictionary-Managed Tablespaces
  • Dictionary versus Locally Managed Tablespaces
  • Converting Dictionary and Local Tablespaces
  • Migrating the Tablespace Management Type
  • Data Dictionary Views
    Managing Rollback Segments
  • Managing Before-Image Data
  • Rollback Segments
  • Private versus Public Rollback Segments
  • Second Rollback Segment in SYSTEM
  • Sizing Rollback Segments
  • The OPTIMAL Parameter
  • CREATE ROLLBACK SEGMENT Command
  • ALTER/DROP ROLLBACK SEGMENT Commands
  • Using the SET TRANSACTION Command
  • Data Dictionary Views for Rollback Segments
    Tablespace Management
  • Automatic Undo Management
  • Creating an Undo Tablespace
  • Automatic Mode for Managing Undo Space
  • Automatic Undo Initialization Parameters
  • The UNDO_RETENTION Parameter
  • Defining an Undo Tablespace When Creating a Database
  • Determining the Size of the Undo Tablespace Data File
  • Dropping an Undo Tablespace
  • Switching Undo Tablespaces
  • Data Dictionary Views for Undo Information
  • Undo versus Rollback Segments
  • Multiple Block Size Support
  • Setting up Multiple Block Sizes
    Segment Management
  • High Throughput Systems
  • Automatic Segment-Space Management
  • Space Management
  • Creating Objects in Automatic Segment-Space Managed Tablespaces
  • Space Deallocation With Automatic Segment-Space Management
  • The DBMS_SPACE Package
  • The SPACE_USAGE Parameters
  • Space Deallocation Statements
  • Viewing Space Usage Information
    Managing Tables
  • Creating Tables
  • Create the SALE_TAB Table
  • ROWIDs
  • Creating Segments in Tablespaces
  • Column Datatypes
  • Global Temporary Tables
  • Clustered Tables
  • Database Block
  • Block Utilization Parameters
  • Row Migration and Chaining
  • Storage Clause Options and Parameters
  • Managing Extent Growth
  • Moving, Renaming, and Redefining Tables
  • Removing Data From Tables
  • Modifying Column Definitions
  • Defining Columns to be Unused
  • Dropping Columns
  • Segment High Water Mark and Segment Header
  • Calculate the HWM of a Segment
  • Online Table Redefinitions
  • DBMS_REDEFINITION Package
  • Validate Structure Online
  • The TRUNCATE Command
  • Data Dictionary Views for Tables
    Managing Indexes
  • Index Types
  • B
    • see the full course programme

    on request

    get more information on the programme directly from PTR Associates Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Venues and dates



    Where Wokingham, 21a Peach Street see map
    When Start: 07/12/2008 Finish: 11/12/2008 See calendar
     
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users

    opinions

    from users who have attended
    this course.
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...
     

    Most searched for in Oracle

    Courses IT, Computing, Telecommunications | Courses Database Administration | Courses Oracle | Courses Oracle 10g | Courses Oracle database 10g | Courses PL/SQL |
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina
    Words related to the courses viewed: oracle warehouse builder 10g database design database architecture
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights