Concentrika poppy

About us

Oracle 10Gfor DBAs: Part 2

Oracle 10G DBA training is spread across two closely linked 4 day courses.
Part 1 – the basics
Part 2 – data management and networking
Our customers typically book their staff in for the part 1 training, with part 2 to follow a few weeks later, when attendees have had a chance to consolidate their learning with experience in the workplace.

The basics

About the course
The course is intended for those who need to find out how to administer an ORACLE database, be this from the viewpoint of DBA, project manager, developer, or as support staff. Throughout the course, the training follows a pattern of firstly how and why ORACLE works as it does, followed by how to engineer changes, hands-on. Lastly, as the course moves on and the delegate acquires more skills, business based workshops are introduced. These require you to decide how the database should be built, deployed and managed, as well as drawing upon the hands-on skills needed to effect an actual outcome based on your decisions.
A real-world view of the training is adopted, to take the delegate past the training lab and into the world of business computing. Your contribution to the labs is highly valued in this respect. Feel free to discuss issues relating to your own businesses, especially where the class as a whole would benefit from seeing what problems, and options to solve them, exist outside the lab.
Should you need examples to help you get started with individual commands or collections of actions, a resource for DBA delegates has been provided in the form of a classroom CBT web site.
Please feel free to take this away with you on floppy disk, for your own personal use. Routines are included to facilitate the complete reconstruction of the classroom environment on a machine at work that you may wish to practice on.
Please note the course is a general DBA course. Should you require training in more detail in any aspect of Oracle DBA, we are able to provide you with dedicated training in specialist areas such as backup and recovery, database security, performance management, and networking databases.


Audience

  • Progression path to specialist Oracle DBA
  • First and second line support
  • Oracle developers wishing to know more about the underlying RDBMS
  • Those seeking an introduction to Oracle DBA
  • The content is suitable for DBAs managing earlier releases of Oracle


Prequisites
Delegates must be familiar with Oracle. This is essential. Ideally you should have received the introductory course and had some months direct experience with Oracle in the workplace subsequently. There is a great deal of information to take in over the time we are together and the pace of the course is necessarily brisk. The more previous Oracle experience you have had, the more you will get out of the course. If you have used Oracle SQL for some time and are familiar with the terminology used by Oracle specialists, you will be able to take this course in your stride.


Duration 4 days

1. Introducing database administration


Responsibilities of a DBA
Elements of an RDBMS
Client server considerations
Database administrative tools
Enterprise Manager

5. Creating a database


Instance management
Components of a database
Creating and deleting a database
Startup and shutdown
Loading the catalogue
Easy database creation using OMF
System parameters
Alter system, alter database, alter session
Database i/o control
Multiple block sizes
The ASM instance

2. Installing Oracle

6. Localised resilience mechanisms


Undo management
Flashback query
10G extended flashback functions
Resumable space management

3. The System Global Area and Background Processes

  • Memory structures
  • Background processes
  • Data dictionary
  • Oracle 10G data dictionary specifics

7. Problems with data storage

  • Fragmentation of blocks and extents
  • Deleted rows fail to release space
  • Chained rows
  • List partitioning
  • Constraints
  • External tables
  • Extracting definitions –
  • DBMS_METADATA

4. Tablespaces

  • ORACLE Optimal Flexible Architecture (OFA)
  • Storage strategies
  • Managing the tablespace system object
  • Moving a tablespace
  • Monitoring tablespace growth
  • Oracle managed datafiles (OMF)
  • Logical organisation within datafiles
  • Rollback segments (supported, but deprecated since Oracle 9i)
    • Temporary tablespace groups
    • Rename tablespace
    • Bigfile tablespace
    Cross-platform transportable tablespaces
    SYSAUX tablespace

8. Users and Security

  • User management strategies
  • Managing the user object
  • Limiting consumption of resources
    - user profiles
    - resource management
  • Managing security
  • permission and privilege
    role

    trusted login to ORACLE

    operating system privileges

    OSOPER,

  • OSDBA

  • The audit subsystem
  • Fine grained access control (FGAC)
  • Fine grained auditing (FGA)
Courses
schedule
Contact us