Course (3-1) Oracle 11g
- 1.A Pragmatic Introduction to Oracle
- 1.1. Introducing a New Kind of Database Management
- 1.2. Pooling Resources with Grid Computing
- 1.3. Anticipating Technology and Development Trends
- 1.4. Meeting Oracle in the Real World
- 1.5. Making the Oracle Decision
- 2. Understanding Oracle Database Architecture
- 2.1. Defining Databases and Instances
- 2.2. Deconstructing the Oracle Architecture
- 2.3. Walking Down Oracle Memory Structures
- 2.4. Trotting around the System Global Area
- 2.4.1. Shared pool
- 2.4.2. Database buffer cache
- 2.4.3. Redo log buffer
- 2.4.4. Large pool
- 2.4.5. Java pool
- 2.5. Program Global Area
- 2.6. Managing Memory
- 2.6.1 Managing memory automatically
- 2.7. Following the Oracle Processes
- 2.7.1. Background processes
- 2.7.2. User and server processes
- 2.8. Getting into Physical Structures
- 2.9. Getting Physical with Files
- 2.9.1. Data files: Where the data meets the disk
- 2.9.2. Control files
- 2.9.3. Redo log files
- 2.9.4. Moving to the archives
- 2.9.5. Server and initialization parameter fi les
- 2.10. Applying Some Logical Structures
- 2.10.1. Tablespaces
- 2.10.2. Segments
- 2.10.3. Extents
- 2.10.4. Oracle blocks
- 3. Preparing to Implement Oracle in the Real World
- 3.1. Understanding Oracle Database Deployment Methodology
- 3.1.1. Client-server applications
- 3.1.2. Muli-tier applications
- 3.1.3. Component confi gurations
- 3.2. Checking on the Requirements
- 3.2.1. User and directory requirements
- 3.2.2. Hardware requirements
- 3.2.3. Software requirements
- 3.2.4. Storage requirements
- 3.2.5. Other requirements
- 3.1. Understanding Oracle Database Deployment Methodology
- 4. Creating an Oracle Database
- 4.1. Feeling at Home in Your Environment
- 4.1.1. Finding the Oracle software owner
- 4.1.2. Oracle versions
- 4.1.3. Getting to home base
- 4.1.4. ORACLE_BASE
- 4.1.5. ORACLE_HOME
- 4.1.6. ORACLE_SID
- 4.1.7. PATH
- 4.2. Sticking with the Oracle Universal Installer and oraenv
- 4.3. Confi guring an Instance
- 4.3.1. Using PFILE and SPFILES
- 4.3.2. Setting parameters in the pfi le and spfi le
- 4.4. Creating Your Oracle Database
- 4.5. Bossing the Database Confi guration Assistant (DBCA)
- 4.5.1. Taking database control
- 4.5.2. Taking the DBCA steps
- 4.5.3. Sharing (a) memory
- 4.6. Feeling the Post-Confi guration Glow
- 4.1. Feeling at Home in Your Environment
- 5. Connecting to and Using an Oracle Database
- 5.1. Starting and Stopping the Database
- 5.1.1. Environmental requirements
- 5.1.2. Starting the database
- 5.1.3. Stopping the database
- 5.2. Connecting to the Database Instance
- 5.2.1. Local versus remote connections
- 5.2.2. Communication fl ow
- 5.2.3. Setting up tnsnames.ora
- 5.2.4. Confi guring the database listener with listener.ora
- 5.2.5. Starting and stopping the database listener
- 5.2.6. Testing the connection
- 5.2.7. Oracle Net Confi guration Assistant
- 5.3. Sidestepping Connection Gotchas
- 5.1. Starting and Stopping the Database
- 6. Speaking the SQL Language
- 6.1. Using SQL in Oracle
- 6.2. Sharpening the SQL*Plus Tool
- 6.3. Using SQL Connection Commands
- 6.4. SQL*Plus Profi le Scripts glogin.sql and login.sql
- 6.4.1. SQL*Plus buffer and commands
- 6.4.2. SQL*Plus commands
- 6.5. Getting Help from SQL*Plus
- 6.5.1. SQL language elements
- 6.5.2. Using the Oracle Data Dictionary
- 6.6. Getting a PL/SQL Overview
- 6.6.1. Blocking PL/SQL
- 7. Populating the Database
- 7.1. Creating Tablespaces
- 7.2. Creating Users and Schemas
- 7.3. Creating Database Objects
- 7.3.1. Object types
- 7.3.2. Object creation methods
- 8. Protecting Your Oracle Database
- 8.1. Assessing Database Threats
- 8.1.1. Instance failure
- 8.1.2. Oracle code tree
- 8.1.3. Dropped objects
- 8.1.4. Media failure
- 8.1.5. Corruption
- 8.1.6. User error
- 8.2. Getting Your Oracle Recovery Manager
- 8.2.1. Starting RMAN
- 8.2.2. Configuring RMAN
- 8.2.3. RMAN catalog
- 8.3. Putting It in the Archives
- 8.3.1. Turning archiving on and off
- 8.3.2. Archive logs
- 8.3.3. Enabling archiving
- 8.3.4. Enabling the Flash Recovery Area
- 8.4. Backup File Types with RMAN
- 8.4.1. Backing up with backup sets
- 8.4.2. Making copies
- 8.5. Maintaining the Archives
- 8.6. Viewing Backup Information
- 8.7. Recovering Your Oracle Database
- 8.7.1. Verifying the problem
- 8.7.2. Complete recovery
- 8.7.3. Incomplete recovery
- 8.7.4. Recovering your database with copies
- 8.1. Assessing Database Threats
- 9. Protecting Your Oracle Data
- 9.1. Authentication
- 9.1.1. User authentication
- 9.1.2. Password authentication
- 9.1.3. Operating system authentication
- 9.2. Granting the Privileged Few
- 9.2.1. System privileges
- 9.2.2. Object privileges
- 9.3. Role Playing
- 9.3.1. Oracle-supplied roles
- 9.3.2. The SYSDBA role
- 9.4. Virtual Private Database Concept
- 9.5. Auditing Oracle’s Big Brother
- 9.5.1. Getting ready to audit
- 9.5.2. Enabling and disabling audits
- 9.5.3. Auditing system privileges
- 9.5.4. Auditing objects
- 9.5.5. Verifying an audit
- 9.5.6. Viewing audit information
- 9.5.7. Turning off audits
- 9.6. Encrypting a Database
- 9.1. Authentication
- 10. Keeping the Database Running
- 10.1. Doing Your Chores
- 10.1.1. Making way, checking space
- 10.1.2. Monitoring space in your segments
- 10.1.3. Growing and shrinking: Tricky tables
- 10.1.4. Checking users
- 10.1.5. Audit records
- 10.1.6. System logs
- 10.2. Automating Jobs with the Oracle Scheduler
- 10.2.1. Scheduler objects
- 10.2.2. Creating your fi rst scheduler job
- 10.3. Using Oracle Data Pump
- 10.3.1. Data Pump Export
- 10.3.2. Data Pump Import
- 10.4. Creating Oracle Directories
- 10.5. Using Data Pump with a Parameter File
- 10.1. Doing Your Chores
- 11. Tuning an Oracle Database
- 11.1. Evaluating Tuning Problems
- 11.2. Tuning Your Database
- 11.3. Gathering Performance Information with Automatic Workload Repository
- 11.3.1. SQL*Plus method
- 11.3.2. Database Control method
- 11.4. Using the Automatic Database Diagnostic Monitor (ADDM)
- 11.5. Improving Queries with SQL Tuning
- 11.5.1. Explain plan
- 11.5.2. Active Session History (ASH)
- 11.5.3. SQL Access Advisor
- 11.5.4. SQL Tuning Advisor
- 11.5.5. SQL Profi ling and Plan Management
- 11.5.6. 10046 trace event
- 12. Troubleshooting an Oracle Database
- 12.1. Troubleshooting with System Methodology
- 12.1.1. Identifying the real problem
- 12.1.2. Performing basic system checks
- 12.1.3. Performing basic database checks
- 12.1.4. Analyzing error messages
- 12.1.5. Developing and applying a solution
- 12.2. Troubleshooting Using Oracle Database Logs
- 12.2.1. Database log infrastructure
- 12.2.2. Database alert log
- 12.2.3. Trace and dump fi les
- 12.2.4. Listener log
- 12.3. Benefi ting from Other Diagnostic Utilities
- 12.3.1. Oracle Enterprise Manager
- 12.3.2. Remote Diagnostic Agent
- 12.3.3. Diagnostic database scripts
- 12.1. Troubleshooting with System Methodology
- 13. Monitoring and Managing with Enterprise Manager
- 13.1. Tasting Oracle Enterprise Manager Flavors
- 13.1.1. OEM Java Console
- 13.1.2. OEM Database Control
- 13.1.3. OEM Grid Control
- 13.2. Confi guring Enterprise Manager with the DBCA
- 13.3. Creating and Managing Database Control Users
- 13.4. Working with Metrics and Policies
- 13.5. Setting Up Notifi cations
- 13.6. Setting Up User Notifi cations
- 13.7. Navigating Database Control’s Main Page
- 13.7.1. Inspecting the Database Control main page
- 13.7.2. Accessing other targets
- 13.1. Tasting Oracle Enterprise Manager Flavors
- 14. Flashing Back and Replaying: Advanced Features
- 14.1. Rolling Back with Flashback Database
- 14.1.1. Confi guring and enabling a fl ash back
- 14.1.2. Using restore points
- 14.1.3. Flashing back your database
- 14.2. Using Flashback Data Archive
- 14.2.1. Using database replay
- 14.2.2. Replaying the workload
- 14.1. Rolling Back with Flashback Database
- 15. Using High-Availability Options
- 15.1. Gathering Real Application Clusters
- 15.2. Exploring RAC Architecture
- 15.2.1. Hardware considerations for RAC
- 15.2.2. Software considerations for RAC
- 15.3. Preparing for a RAC Install
- 15.3.1. Tools for managing a RAC installation
- 15.3.2. Oracle RAC application for high availability
- 15.4. Defending Oracle Data Guard
- 15.4.1. Data Guard architecture
- 15.4.2. Physical standby database
- 15.4.3. Logical standby database
- 15.4.4. Performing switchover and failover operations
- 16. Top Ten Oracle Installation Do’s
- 16.1. Read the Documentation
- 16.2. Observe the Optimal Flexible Architecture
- 16.3. Configure Your Profi le
- 16.4. Running the Wrong Bit
- 16.5. Set umask
- 16.6. Become Oracle
- 16.7. Stage It
- 16.8. Patch It
- 16.9. Mind the User and Group IDs
- 16.10. Back It Up
- 17. Top Ten Database Design Do’s
- 17.1. Using Oracle’s Built-In Constraints
- 17.2. Spreading Out Your IO
- 17.3. Knowing Data Normalization
- 17.4. Using Naming Conventions
- 17.5. Setting Up Roles and Privileges Properly
- 17.6. Keeping Ad-Hoc Queries to a Minimum
- 17.7. Enforcing Password Security
- 17.8. Limiting the Number of DBAs
- 17.9. Storing Code in the Database
- 17.10. Testing Your Recovery Strategy
Online LIVE Training Programming Course offered by INCAPROG ONLINE - www.incaprog.com - contacto@incaprog.com - Phone : (954) 727-3141