Showing posts with label Traning. Show all posts
Showing posts with label Traning. Show all posts

Perfomance Tuning

  • Introduction to Performance Tuning

  • Introduction to Performance Tuning Features and Tools

  • Oracle Methodology

  • Understanding Investment Options

  • Understanding Scalability

  • System Architecture

  • Application Design Principles

  • Workload Testing, Modeling, and Implementation

  • Deploying New Applications

  • The Oracle Performance Improvement Method

  • Emergency Performance Methods

  • Performance Considerations for Initial Instance Configuration

  • Creating and Maintaining Tables for Good Performance

  • Performance Considerations for Shared Servers

  • Overview of Data Gathering

  • Automatic Workload Repository

  • Introduction to Database Diagnostic Monitoring

  • Automatic Database Diagnostic Monitor

  • Understanding Memory Allocation Issues

  • Configuring and Using the Buffer Cache

  • Configuring and Using the Shared Pool and Large Pool

  • Configuring and Using the Redo Log Buffer

  • PGA Memory Management

  • Understanding I/O

  • Basic I/O Configuration

  • Understanding Operating System Performance Issues

  • Solving Operating System Problems

  • Finding System CPU Utilization

  • Instance Tuning Steps

  • Interpreting Oracle Statistics

  • Wait Events Statistics

  • Idle Wait Events

  • Understanding Connection Models

  • Detecting Network Problems

  • Solving Network Problems

  • Introduction to SQL Tuning

  • Goals for Tuning

  • Identifying High-Load SQL

  • Automatic SQL Tuning Features

  • Developing Efficient SQL Statements

  • Automatic SQL Tuning Overview

  • SQL Tuning Advisor

  • Managing SQL Profiles with APIs

  • SQL Tuning Sets

  • SQL Tuning Information Views

  • Optimizer Operations

  • Choosing an Optimizer Goal

  • Enabling and Controlling Query Optimizer Features

  • Understanding the Query Optimizer

  • Understanding Access Paths for the Query Optimizer

  • Understanding Joins

  • Understanding Statistics

  • Automatic Statistics Gathering

  • Manual Statistics Gathering

  • System Statistics

  • Managing Statistics

  • Viewing Statistics

  • Understanding Index Performance

  • Using Function-based Indexes for Performance

  • Using Partitioned Indexes for Performance

  • Using Index-Organized Tables for Performance

  • Using Bitmap Indexes for Performance

  • Using Bitmap Join Indexes for Performance

  • Using Domain Indexes for Performance

  • Using Clusters for Performance

  • Using Hash Clusters for Performance

  • Understanding Optimizer Hints

  • Using Optimizer Hints

  • Using Plan Stability to Preserve Execution Plans

  • Using Plan Stability with Query Optimizer Upgrades

  • Understanding EXPLAIN PLAN

  • The PLAN_TABLE Output Table

  • Displaying PLAN_TABLE Output

  • Reading EXPLAIN PLAN Output

  • Viewing Parallel Execution with EXPLAIN PLAN

  • Viewing Bitmap Indexes with EXPLAIN PLAN

  • Viewing Partitioned Objects with EXPLAIN PLAN

  • End to End Application Tracing

  • Using the traces Utility

  • Understanding SQL Trace and TKPROF

  • Using the SQL Trace Facility and TKPROF

  • Avoiding Pitfalls in TKPROF Interpretation

  • Sample TKPROF Output

Labels:

Oracle Rac Traning 19c


  • Oracle RAC Features

  • Oracle RAC Technology Hierarchy

  • Oracle RAC Capabilities

  • Oracle RAC Components

  • Tools for Installing, Configuring and Managing Oracle RAC

  • Cluster Overview

  • Grid Foundation Components and Architecture

  • Oracle Clusterware Components and RAC

  • Oracle Storage Subsystems

  • File Types used by a RAC Database

  • Methods used to Share Database Files across a Cluster

  • ASM Architecture

  • Create and Manage ASM Disk Groups

  • Create and Manage ASM Cluster Filesystems

  • An Overview of RAC Services

  • Network Configuration

  • Oracle RAC Pre-installation Tasks

  • Create Oracle Groups, User Accounts, and Directories

  • Validate and Prepare the Hardware and the Operating System

  • Network Configuration

  • Install the Oracle Grid Infrastructure

  • Cluster Verification Utility (CVU, CLUVFY)

  • Install Oracle Database Software and Create a Cluster Database

  • Verify the Installation

  • Post Installation Tasks

  • Configure Client Connections with Oracle Net Manager

  • Convert an Oracle Database to a RAC Database

  • Use the DBCA for Single Instance Conversion

  • Use rconfig for Single Instance Conversion

  • RAC Specific Background Processes

  • RAC Initialization Parameters

  • Manage Undo Tablespaces in a RAC Environment

  • Manage Redo Log Files and Groups in a RAC Environment

  • Oracle Enterprise Manager Cluster Database Pages

  • Start and Stop Oracle RAC Databases and Instances

  • Administer Database Storage

  • Transparent Data Encryption and Wallets in RAC

  • Manage CRS Commands

  • CRSCTL Commands to Stop, Start and Administer Clusterware

  • Backup and Recover Voting Disks

  • Add and Remove Voting Disks

  • The ocrcheck Utility

  • The ocrdump Command

  • Administer the Oracle Cluster Registry (OCR)

  • Backup and Restore OCR

  • Troubleshoot the OCR with ocrcheck

  • ASM Initialization Parameters

  • Create an ASM Instance using ASMCA

  • Start and Stop an ASM Instance using srvctl

  • Start and Stop an ASM Instance using ASMCMD

  • Start and Stop an ASM Instance Containing Cluster Files

  • Start and Stop the ASM Listener

  • Create and Delete ASM Disk Groups

  • ASM Disk Group Attributes

  • ASM Disk Group Maintenance Tasks

  • Preferred Read Failure Groups

  • ASM Disk Statistics

  • ASM Dynamic Volume Manager

  • Manage ASM Volumes

  • Create an ASM Cluster File System (ACFS)

  • Manage an ACFS File System

  • ACFS Snapshots

  • Manage ACFS with Command Line Tools

  • RAC Management Commands

  • RAC Administration with SVRCTL

  • SVRCTL Cluster Database Configuration Tasks

  • SVRCTL Cluster Database Administration Tasks

  • Check the Current Configuration

  • SVRCTL Command Summary

  • Administer Databases and Instances

  • Administer Services and Node Applications

  • Bring a Cluster Database online and offline

  • Introduction to CRS

  • Cluster Services

  • Manage the Database Workload using Services

  • Create and Administer Services in a RAC Environment

  • Services and Client Applications

  • Manage Services with Enterprise Manager and from the Command Line

  • Configure Oracle Net to Support Services

  • Configure Service Level Thresholds

  • Configure Clients for Failover

  • RAC High Availability Framework

  • Failure Detection with Cluster Services

  • Oracle RAC and Hardware Failover

  • Connection Failover

  • Transparent Application Failover (TAF)

  • Server, Client And Runtime Load Balancing

  • Fast Application Notification (FAN)

  • Server and Client Side Oracle Notification Services

  • Configure a Fast Recovery Area for use with RAC

  • Tune Instance Recovery in RAC

  • Parallel Recovery in RAC

  • Initiate Archiving

  • Configure RMAN Backup and Recovery Settings

  • Backup a RAC Database using RMAN

  • Restore and Recover a RAC Database using RMAN

  • Display Backup Reports

  • Duplicate a RAC Database with RMAN

  • Standby Database in a RAC Configuration

  • Configure Data Guard for a RAC Environment

  • Possible Combinations of Instances in the RAC Primary and Standby Databases

  • Multi-Instance Primary with a Single Instance Standby

  • Set up a Primary in a RAC Environment

  • Set up a Single Instance Standby Database

  • Set up a Multiple Instance Primary and Cluster Standby

  • Configure RAC Primary and Standby Databases

  • Data Protection Modes

  • Role Transition Switchovers and Failovers

  • Switchover Failover in an Oracle RAC Configuration

  • Monitoring and Performance Guidelines

  • RAC Monitoring Tools

  • RAC Performance Recommendations

  • Analyze Performance Issues using OS Watcher and LTOM

  • Use the Automatic Workload Repository in RAC

  • Use the Automatic Database Diagnostic Monitor in RAC

  • Use Statspack with RAC

  • Global Cache Services (GCS) Monitoring

  • V$cache_transfer Views

  • Monitor the GES Processes

  • Monitor and Tune the RAC Cluster Environment using Enterprise Manage.

  • Prepare a New Node

  • Extend the Oracle Grid Infrastructure Home to the New Node

  • Extend the Oracle RAC Home Directory

  • Add the New Node to the Cluster

  • Create an Instance on the New Node

  • Delete an Instance from the Cluster Database

  • Remove a Node from the Cluster

  • Configure the EM Patch Interface

  • Obtain Patches

  • Apply Rolling Patches to a RAC System

  • Apply a Patchset with the opatch Utility

  • Apply a Patchset with OUI

Labels:

Core DBA Traning 19c


  • What is DBA?

  • Why a Company needs a DBA?

  • Roles & Responsibilities of DBA

  • Oracle Architecture

  • Physical and Logical Phase of Database

  • Types of files(Control file, Redolog file and Datafile)

  • Different types of Datafiles

  • Instance

  • SGA(System Global Area) and Background Process

  • Different Startup Modes

  • Different Shutdown Modes

  • Types of Database Creation

  • Manual Method of Creation

  • Introduction to Table space

  • Types of Table space(BIG & SMALL)

  • Temporary Table space

  • Altering/Renaming a Table space

  • Renaming a data file

  • Temporary Groups

  • Table space Encryption(11g)

  • What are segments?

  • What are extents?

  • What is Blocks?

  • Oracle Blocks

  • Estimation of Extents

  • Dictionary Managed Table space

  • Locally Managed Table space

  • Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

  • Who are Database Users?

  • Why to create a User?

  • Creation of Users

  • Assigning Privileges

  • Creating and granting Roles

  • Allocating table space Quotas to Users

  • Assigning default table space for the Users

  • Setting Profiles for the Users

  • Levels of Authentication

  • Schema Management(11g)

  • Security(11g)

  • What is Undo?

  • Why Undo required?

  • Pending offline status

  • Brief idea about Rollback segments

  • Flashback Features

  • Flashback Table

  • Flashback query

  • Flashback Version query

  • What is spfile?

  • Difference between spfile and pfile

  • Advantages of spfile

  • What is OMF?

  • Advantages of OMF

  • Files conventions of OMF

  • Introduction to Oracle Networking

  • Network default location

  • Editing Network file

  • Tnsnames.ora

  • Introduction to Database Links

  • Types of Database Links

  • Introduction to Materialized views

  • Advantages of Materialized view

  • Refresh Modes

  • Introduction to Redo log

  • Status of Redo logs

  • Multiplexing the Redo log files

  • Re-creation of Control file

  • Renaming the Database

  • Multiplexing the Control file

  • What is a logical backup

  • Why it is required

  • Export/import Utility

  • Data Pump

  • Difference between Data Pump and Traditional Export/import

  • Impdp/expdp

  • Transportable Table spaces

  • Introduction to Physical backup

  • Types of Physical backup

  • Cold & Hot backup

  • Recovery scenarios

  • RMAN backup

  • RMAN Point in time recovery

  • RMAN 11g new features

  • What is Performance Tuning?

  • Why Tuning required?

  • Types of Tuning

  • Database Tuning

  • Tuning

  • SQL Tuning

  • Memory Tuning

  • Network Tuning

  • Partitioning and Indexes

  • Partitioning Enhancements

  • AWR/ASH/ASMM/ADDM

  • RAT(Real Application Testing)(11g)

  • SQL Performance Analyses (11g)

  • Row Chaining and Row migration

  • Resemble Table spaces


Labels:

Goldengate/Veridata Traing With Microservices

  • Introduction to Oracle GoldenGate

  • Oracle GoldenGate Architecture

  • Understanding Oracle GoldenGate Replication Solutions for Live Reporting, Real-Time Data Warehousing, Live Standby Database, and High Availability.

  • Supported databases and platforms

  • Advantages of Oracle GoldenGate

  • Downloading the software

  • Installing Oracle GoldenGate

  • Explaining Subdirectories

  • Enabling supplemental logging

  • Understanding GoldenGate Components: Processes and Files

  • Process Data Flow

  • GoldenGate Architecture

  • Design Considerations

  • Configuring the Manager process

  • Describing the Manager Parameters

  • Starting the Manager process

  • Configuring GLOBALS file

  • Configure Initial Load

  • Overview of Data Definitions File

  • When to use Data Definitions Files

  • Types of Data Definitions File

  • Configuring Data Definitions File

  • Preparing a source database for transaction capture

  • Describing the high-level configuration steps

  • Explaining change capture and delivery with a data pump

  • Explaining change capture and delivery without a data pump

  • Comparing batch and online operation

  • Explaining Oracle GoldenGate Checkpoints

  • Describing the Extract process

  • Configuring and starting an Extract process

  • Adding local and remote trails

  • Configuring and starting a data pump

  • Explaining the Replicate process

  • Configuring a Replicate process

  • Starting a Replicate process

  • Describing GGSCI commands

  • Describing Extract trails and files

  • Overview of DDL synchronization

  • Preparing a source database for transaction capture

  • Describing the high-level configuration steps

  • Configuring Extract and Replicate for DDL replication

  • Running GoldenGate commands from the GGSCI prompt

  • Running GoldenGate commands from the obey files

  • Running GoldenGate commands from the OS shell

  • Identifying the types of GGSCI commands available

  • Managing trail files

  • Automating process startup

  • Using reporting and statistics

  • Using message, trail and password encryption

  • Controlling command permissions – CMDSEC file

  • Overview of data mapping and manipulation

  • Deciding where data mapping and conversion will take place Data Selection and Filtering

  • Data Transformation


Labels: