Yet Another OCM
Home
10G OCM
10G Data Guard
10G Data Guard (01)
10G Data Guard (02)
10G Data Guard (03)
10G Data Guard (04)
10G Data Guard (05)
10G Data Guard (06)
10G Data Guard (07)
10G Data Guard (08)
10G Data Guard (09)
10G Data Guard (10)
10G Data Guard (11)
10G Data Guard (12)
10G OCM Planning
10G Services
Grid Control
NTP
10G System Builds
Botany
Miscellaneous
Padstow
Richmond Cluster
Richmond Database
RMANCAT
Missing BigBlog Links
11G OCE RAC
Section 1 - Grid Infrastructure: Clusterware and ASM
Administering Oracle Clusterware
Grid Infrastructure Installation
Making Applications Highly Available With Oracle Clusterware
Managing Clusterware
Oracle Grid Infrastructure
Troubleshooting Oracle Clusterware
System Builds
Panania1
VICTORIA
11G OCM
11G OCM Data and Data Warehouse Management
11G OCM Configure a schema to support a star transformation query
11G OCM Configure and use parallel execution for queries
11G OCM Configure Flashback Data Archive
11G OCM Create partitioned tables
11G OCM Troubleshoot fast materialized views to fast refresh and query rewrite
11G OCM Data Guard
11G OCM Configure archivelog deletion policy for the dataguard configuration
11G OCM Configure the data guard environment to reduce overheads of fast incremental backups on the primary database
11G OCM Database, RMAN, EM and Network Configuration
11G OCM Create an Archival Backup
11G OCM Create and Manage a tablespace that uses NFS mounted file system file
11G OCM Create and Manage encrypted tablespaces
11G OCM Create Base Recovery Catalog
11G OCM Install and configure EM Agent
11G OCM Performance Management
11G OCM Configure baseline templates
11G OCM Gather statistics on a specific table without invalidating cursors
11G OCM Replay a captured workload
11G OCM Set up and configure Resource Manager
11G OCM Use multi column statistics
11G OCM Use partitioned indexes
11G OCM Use Result Cache
11G OCM Use SQL Access Advisor
11G OCM Use SQL Plan Management feature
11G OCM Use SQL Tuning Advisor
11G OCM System Builds
BANKSTOWN
Data Guard
Design Overview
FREENAS
GRIDCTRL
PADSTOW
PENRITH1
PENRITH2
REDFERN
12C OCM
12C OCM System Builds
BOTANY
PADSTOW
Data and Performance Management
Configure the database to retrieve all previous versions of the table rows
Configure the Oracle Database Resource Manager
Create a plugged-in tablespace by using the transportable tablespace feature
Create partitioned tables
Create SQL Plan baselines
Administer materialized views
Perform real application testing
Tune SQL statements
Data Guard
Administer a Data Guard environment
Configure a standby database for testing
Configure a standby database to apply redo
Configure a standby database to use for reporting
Configure fast start failover
Create a physical standby database
Restore the standby database to its normal function
Design Journal
General Database and Network Administration, and Backup Strategy
Configure the network environment to allow connections to multiple databases
Create and manage database configuration files
Create and manage pluggable databases
Create and manage users, roles, and privileges
Protect the database from data loss due to failures
Grid Infrastructure and RAC
Administer Oracle Clusterware
Configure Database Services
Create a Real Application Clusters (RAC) database
Create and manage ASM instances
Create ASM Cloud File System (ACFS)
Create ASM disk groups
Install Oracle Database 12c software
Install Oracle Grid Infrastructure
12C OCP Upgrade
Section 1: New Features of Oracle Database 12c
ADR and Network Enhancements
Auditing
Backup, Recovery and Flashback for a CDB/PDB
Basics of Multitenant Container Database (CDB)
Configuring and Creating CDBs and PDBs
Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics
Enterprise Manager and Other Tools
In-Database Archiving and Valid-Time Temporal
Index and Table Enhancements
Information Lifecycle Management and Storage Enhancements
Managing CDBs and PDBs
Managing Tablespaces, Common and Local Users, Privileges and Roles
Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements
Oracle Data Redaction
Partitioning Enhancements
Privileges
Real-Time Database Operation Monitoring
Resource Manager and Other Performance Enhancements
RMAN and Flashback Data Archive
SQL Enhancements
SQL Tuning
Section 2: Key DBA Skills
Core Administration
Miscellaneous
Performance Management
Security
Storage
Database Designs
Much Ado About Nothing
Logical Design
Issues
Cloud Control Issues
Cloud Control Not Starting Automatically in OVM_EM12R2
Installation of OMA Fails with Time Zone Issue
Unable to Connect to OMS on CRONULLA
Unable to Startup OMS on CRONULLA
Linux Issues
Root Password is Unknown
Unable to Unzip Files Bigger than 2GB
Unable to Use NFS Under VirtualBox
Oracle Cloud Infrastructure (OCI) Issues
Unable to launch image in a subnet without DNS enabled
Oracle Enterprise Edition Issues
Drop Administrative User
Oracle Patching Issues
OPatch Apply of GI PSU 12.1.0.2.161018 fails
Oracle Personal Edition Issues
Got ORA-01031 when logging on remotely using SYS AS SYSDBA
OERI kql_tab_diana While Running noncdb_to_pdb
Unable to Set up Unified Auditing under 12.1.0.1
OVM Issues
ETH0 has wrong MAC Address after Upgrade to OVMS 3.2.6
OVMM Fails to Enable TCPS Connections
sudo is Missing in OVM_EM12R2
PostgreSQL Issues
Move Default Tablespace is Different from Normal Tablespace
Knowledge
Demonstrations
Analysis of Effect of O_SYNC
Help Pages
runInstaller
Oracle Utilities
ADRCI SHOW ALERT Reference
Technical Notes
Oracle Cloud Infrastructure 2024 Architect Associate
Compute
Configure Autoscaling
Configure compute instances
Describe and configure OS Management
Describe OCI compute image options
Explain Infrastructure Maintenance
Select appropriate computing choices
Identity and Access Management
Configure Dynamic Groups, Network Sources, and Tag-Based Access Control
Create and manage IAM domains, users, groups, and compartments
Explain the core concepts of Identity and Access Management
Implement IAM policies to control access to resources
Networking
Analyze Inter-Region Latency
Configure DNS and Traffic Management
Configure Local and Remote Peering
Configure Security Lists and Network Security Groups
Configure Site-to-Site VPN
Configure Traffic Management Steering Policies
Configure Virtual Cloud Network Routing and Gateways
Describe and configure Load Balancer and Network Load Balancer
Describe FastConnect
Describe Public and Private DNS zones
Describe public and private IP addresses and virtual NICs
Describe public and private subnets
Evaluate VCN connectivity options
Explain Load Balancer concepts
Implement and manage VCN connectivity
Implement and manage Virtual Cloud Networks
Implement Capture filters and Virtual test access points
Implement Network Command Center Services
Implement Network Visualizer
Implement transit routing scenarios
Implement Web Application Acceleration
Troubleshoot using Network Path Analyzer
Storage
Analyze File System usage and metering
Configure and manage Object Storage
Configure cross-region replication
Configure File Storage
Configure File System Snapshots and Clone
Configure Multipart uploads
Configure Object Storage replication
Configure Volume Groups, Backups, Clones
Deploy and manage Block Storage
Deploy Block and Boot Volumes
Describe File Storage Security
Describe Object Storage Security
Explain Block Volume performance tiers
Explain Object Storage tiers
Implement and manage File Storage
Implement File Storage replication
Implement Object Storage versioning, life cycle management and retention rules
Oracle Cloud Infrastructure 2024 Certified Networking Professional
Design and Deploy OCI Virtual Cloud Networks (VCN)
Demonstrate an understanding of IPv4/IPv6 addressing
Demonstrate mastery in applying EndPoints to a Networking Architecture
Differentiate the VCN Gateway's roles
Examine VCN/Subnets characteristics
Recognize the different Endpoints
Design for Hybrid Networking Architectures
Assess knowledge of BGP
Demonstrate command of DRG and DRG Attachments
Evaluate OCI VPN Services
Sustain multi-cloud connectivity configurations
Validate knowhow of the different FastConnect products from OCI
Implement and Operate Secure OCI Networking and Connectivity Solutions
Apply Connectivity and related IAM concepts to inter-tenancy communications
Demonstrate CloudShell functionalities
Evaluate WAF/Edge/Certificates/services in a Networking multi-tier architecture
Illustrate Network Firewall characteristics
Show different approaches for Bastion service in multi-tier architectures
Migrate Workloads to OCI
Outline optimal connectivity strategy for a cloud migration from another Cloud Service Provider
Outline optimal connectivity strategy for a cloud migration from On-Premises
Outline optimal multi-cloud scenarios
OCI Networking Best Practices
Demonstrate knowledge of Logging and Monitoring best practices
Demonstrate knowledge of Networking Architecture Design best practices
Demonstrate knowledge of Networking Connectivity best practices
Demonstrate knowledge of Networking Security best practices
Plan and Design OCI Networking Solutions and App Services
Demonstrate an understanding of OCI load-balancing offerings and related resources
Demonstrate knowledge of OCI DNS and Traffic Steering
Recognize IP Management details, select procedural steps
Transitive Routing
Interpret key aspects of transitive routing with DRG, LPG, and Network Appliance resources
Synthesize Transitive Routing Configurations
Troubleshoot OCI Networking and Connectivity Issues
Demonstrate logging expertise in OCI
Select the right products for various troubleshooting and design scenarios
Oracle Autonomous Database Cloud 2024 Professional
Autonomous Database Dedicated
Creating OCI Policies for Autonomous Dedicated
Describe ADB Dedicated and ADB Cloud@Customer workflows and functionality
Manage encryption keys
Manage maintenance scheduling (patching)
Monitor Dedicated Infrastructure
Provision Dedicated Resources
Autonomous Database Shared
Cloning
Create Autonomous Database Shared Instances - provisioning, scaling OCPU and storage, start and stop
Database Consolidation with Elastic Resource Pools
Describe Data Guard
Manage Autonomous Database Backups and Restores
Manage users
Monitor Autonomous Database instances - events and alarms
Move Autonomous Database
Autonomous Database Tools
Apply Data Insights
Create Business Model
Describe Autonomous Database Tools
Explain Data Analysis
Explain Data Transforms
Use Autonomous Database with Oracle Machine Learning, APEX and SQL Developer Web (Database actions)
Developing on Autonomous Database
Data Lake Analytics with Autonomous Database
Developing New and Extending Existing Applications with Natural Language Queries using Generative AI
Incorporate Location-based analysis (Autonomous Spatial)
Integrate Object Storage data
Use Autonomous Graph
Use Autonomous JSON Database
Use Oracle Text
Getting Started with Autonomous Database
Describe Autonomous Database architecture and integration
Describe the Different Autonomous Database offerings and license types
Explain Autonomous Database Architectural Components and Key Features
Managing and Maintaining Autonomous Database
Configure Disaster Recovery (Data Guard)
Manage Autonomous Database instances: REST APIs, OCI CLI, Patching and upgrading
Monitor ADB performance and set up service notifications
Use Access Control List (ACL) and Private End Points
Use ADB connectivity: Wallets, service handles
Use services in ADB: auto indexing, data safe, compartment quotas
Migrating to Autonomous Database
Describe the options and considerations for migrating to Autonomous Database
Migrate to Autonomous Database using Data Pump
Procedures
Create Oracle Database
Create 12.1 Container Database No OMF
Create 12c Container Database Using OMF
Create 12C Non-CDB Database Using OMF
Create 12C Non-CDB Database Without OMF
Deinstall Oracle RDBMS
Deinstall Oracle RDBMS 11.2.0.1.0
Deinstall Oracle RDBMS 12.1.0.2
Deinstall RDBMS 11.2.0.3 (Non Grid)
GIT Procedures
Set Up Work In Progress for GIT
Install Grid Infrastructure
Install 12.1.0.2 GI Standalone
Install Grid Infrastructure 11.2.0.3.3 on GRIDCTRL
Install Linux
Install Oracle Enterprise Linux 7.4
Install Oracle Enterprise Linux 7.2
Install Ubuntu 16.04 LTS Server
Install Oracle RDBMS
Install Oracle RDBMS 11.2.0.1.0 with Grid Infrastructure
Install Oracle RDBMS 11.2.0.3.0 Without Grid Infrastructure on Windows XP
Install Oracle RDBMS 11.2.0.3.0 without Grid Infrastructure
Install Oracle RDBMS 11.2.0.3.0 with Grid Infrastructure
Install Oracle RDBMS 12.1.0.2.4 Without Grid Infrastructure
Install Oracle RDBMS 12.1.0.2 With Grid Infrastructure
Install Oracle RDBMS 19.5.1.0.200114 without Grid Infrastructure
Miscellaneous
Convert XEN HVM to PV
Create New ASM Disk Group Using ASMCA
Create VNC Server under OEL8
Disable FIREWALLD
Enable DIRECTNFS for Oracle RDBMS 12.1.0.2
Install SQL Developer Data Modeler on Ubuntu 18.04
Install unixODBC Packages Under RHEL 5.4
Manually Create Cloud Control VM from Appliance
Relocate Datafile under 11.2.0.4
Setting Up X-windows to a Remote Server
Starting XTERM with White Background
Use NFS for Oracle Software
Use Pre-Installation RPM
OCI Procedures
Autonomous Database Queries
Availability Domains Queries
Compartment Queries
Compute Capacity Report Queries
Compute Image Queries
Compute Instance VNIC Queries
Compute Shape Queries
Create OCI Configuration File
Fault Domains Queries
Identity Domains Queries
Install OCI CLI
Launch Compute Instance
OCI Limits Queries
Subnet Queries
Work Requests Queries
Patch Oracle Database
Apply Oracle RDBMS 11.2.0.3.3 Patchset (Incomplete)
Apply Oracle RDBMS 11.2.0.3.4 Patchset
Apply Oracle RDBMS 12.1.0.2.190416 Patchset
Finding the 11.2.0.3.3 PSU
PostgreSQL Procedures
Backup PostgreSQL DB
Install PostgreSQL 16
Move Default Tablespace
Move Non-Default Tablespace
Upgrade PostgreSQL 14 to 16
Upgrade Oracle Database
Upgrade PRODSRVR on PENRITH from 11.2.0.1 to 11.2.0.3 on Windows XP
Upgrade REPOS to 11.2.0.3.3 from 11.1.0.7.0 on GRIDCTRL
Projects
GitHub Projects
Setting Up a Private Cloud
00 Design
01 Setting Up the Cloud Management Infrastructure
02 Setting Cloud for IaaS
03 Setting Cloud for IaaS 2
04 Setting Cloud for IaaS 3
Reading Notes
MySQL Concurrency
Ch 01: Introduction
Ch 02: Monitoring Locks and Mutexes
Ch 03: Monitoring InnoDB Transactions
Ch 04: Transactions in the Performance Schema
Ch 05: Lock Access Levels
Ch 06: High Level Locks Types
Ch 07: InnoDB Locks
Ch 08: Working with Lock Conflicts
Ch 09: Reducing Lock Issues
Ch 10: Indexes and Foreign Keys
Ch 11: Transactions
Ch 12: Transaction Isolation Levels
Ch 13: Case Study: Flush Locks
Ch 14: Case Study: Metadata and Schema Locks
Ch 15: Case Study: Record Level Locks
Ch 16: Case Study: Deadlocks
Ch 17: Case Study: Foreign Keys
Ch 18: Case Study: Semaphores
Oracle Database Transactions and Locking Revealed
Ch 02: Locking and Blocking
Ch 03: Locks, Latches, and Mutexes
Ch 04: Concurrency and Multiversioning
Ch 05: Transactions
Ch 06: Redo and Undo
Ch 07: Investigating Redo
Ch 08: Locking and Blocking
Ch 09: Troubleshooting
Oracle VM Implementation and Administration Guide
Pro Oracle Database 12c Administration
Pro SQL Server 2019 Adminstration
Part I. Installation and Configuration
Part II. Database Administrator
Part III. Security, Resilience, and Scaling Workload
Part IV. Performance and Maintenance
Resource Allocations
IP Addresses
Victoria VM Resources
System Builds
ALLAWAH
2021-02-02 Planning and Build VM
AUBURN
2018-02-21 Planning
2018-02-22 Create VM
2018-02-26 Finish Server Installation
2018-02-27 Install Ansible
2018-03-25 Install Extra Python Modules
2018-03-27 Create GIT Repository
2018-03-29 Add Extra Disk Drive
2020-01-02 Upgrade to Python3 for Ansible
2020-09-23 Upgrade to Ansible 2.10.1
2020-10-15 Upgrade to Ubuntu 20.04
CLIFTON
2016-09-07 0 Planning
2016-09-07 1 Build VM
2017-08-01 Convert to XEN
2020-01-09 Install Oracle Client
CLOUDCTL
00 Download EM12CR3 Template to VICTORIA
01 Extract Template into Seed Pool
02 Deploy EM12CR3 Template into Running Pool
03 Fix Networking Issues
04 Clean Up Seed Pool
05 Save VM UUID in Configuration File
CRONULLA
00 Design
01 Create VM
02 Fix OS Install Issues
03 Prepare to Install OMS 12.1.0.3.1
04 Install OMS 12.1.0.3.1
05 Add Extra Disk Space
06 Install OMS 12.1.0.3.1 Again
07 Complete OMS 12.1.0.3.1 Installation
08 Configure Firewall Rules
09 Additional Configuration Tasks
10 Apply WLS Patches
11 Install Guest Additions
12 Install RDA and EMDIAG Tools
13 Patch OMS to 12.1.0.3.2
14 Apply WLS Patches
15 Integrate BI Publisher into OEM
16 Upgrade OMS 12.1.0.4.0
17 Upgrade BIP
18 Patch WLS After OMS 12.1.0.4
19 Re-install as VM on Victoria
20 Install Packages
21 Install OMS 12.1.0.4
22 Replace OMR
23 Updated .bashrc for OMS and OPMN
GOLDENGATE
2014-12-03 Planning
2014-12-03 Set Up goldengate1
2021-02-04 Create XEN VM Images
2021-02-05 Start Installation
GORDON
00 Setup
01 Patch GI and DB with PSU 12.1.0.2.5
02 Create EMREPOS Database Using DBCA
03 Fix Up 12.1.0.2.5 and Recreate EMREPOS
04 Install OEM Agent
05 Disable Firewall
06 Move OMR
07 Move OMR - Second Attempt
08 Move OMR - Third Attempt
09 Move OMR - Fourth Attempt
10 Move GORDON to VICTORIA
11 Correct GORDON Network Interface
12 Patch GI with PSU 12.1.0.2.161018
13 Downgrade GORDON to OEL6U5
GRIDCTRL
00 Update DNS for REVESBY Cluster
01 Upgrade EM12CR3p1 (1)
02 Upgrade EM12CR3p1 (2)
03 Deinstall EM12CR1 and Others
04 Install DB PSU 11.2.0.4.0
05 Install EM12CR3p1
06 Set up XDCMP
07 Set Login Timeout and Login Profile
08 Performance Problems
09 Deinstall EM12103P1
10 Automate REPOS Start Up
11 Fix REPOS For OMS Install
12 Apply PSU 11.2.0.4.2 to REPOS
13 Install REPVFY
14 Change DB Parameters for OEM 12.1.0.4
15 Apply PSU 11.2.0.4.3 to REPOS
16 Apply PSU 11.2.0.4.5 to REPOS
17 Apply PSU 11.2.0.4.6 to REPOS
18 Apply Patch 17583185
MELBOURNE
00 Design
01 Create VM
02 Install OVMM 3.2.6
03 Enabling Remote Log Ins
04 Install TightVNC
OATLEY
2020-04-13 Planning and Initial Build
PERSONAL
2020-03-09 Upgrade to 19C
RANDWICK
2020-03-14 Planning
REDFERN
2014-12-23 Planning
2014-12-29 Set Up redfern1
2015-01-01 Set Up DNS and iSCSI
2015-04-04 Create REDFERN1 with OEL7
2015-04-06 Build REDFERN1 on Victoria
2015-04-06 Build REDFERN2 on Victoria
2016-04-23 Install GI 12.1.0.2
2017-11-19 Correct UDEV Settings
2017-11-25 ASM Fails to Start
2017-11-28 Recreate REDFERN Cluster on VICTORIA
2017-11-30 De-Install GI
2017-12-02 GI Installation Attempt #3
2018-02-01 Revised Planning
2018-02-02 Install OEL 7.4
2018-02-28 Ansible Playbook for GI 12.1.0.2 Install
2018-03-01 Ansible Playbook for Oracle Directories
2018-03-02 Ansible Playbook for Oracle User
2018-03-06 Ansible Playbook for GI Network
2018-03-07 Ansible Playbook for GI Storage
2018-03-11 Ansible Playbook for ASMLIB Setup
2018-03-14 Ansible Playbook for Software NFS
2018-03-15 Ansible Roles
2018-03-17 Ansible Playbook to Install GI Software
2018-03-20 Ansible Playbook for Install GI Software (2)
2018-03-24 Ansible Rearrange Variables
2018-03-27 Manage Ansible Playbook in GIT
2018-05-22 Use iSCSI
2018-06-17 NMCLI Commands
Revesby
00 Download OVM Template for DB to VICTORIA
01 Extract Template into Seed Pool
02 Set Up Networking for RAC
03 Set Up Shared Disks for RAC
04 Deploy RAC Nodes
05 Start Up Fails
Victoria
2013-12-24 0 Install OVMS 3.2.6
2013-12-24 1 Add Bridge
2013-12-24 2 Create Repository
2013-12-25 Fix Networking Issues
2014-04-26 Rebuild Victoria
2015-03-29 Install OVMS 3.3.1
2015-04-01 Set Up OVS File System
2015-04-04 Set Up XEN Network
2015-04-26 Rebuild Victoria Again
2018-01-16 Upgrade to OVMS 3.4.4
2018-02-01 Upgrade to OVMS 3.3.4 - Attempt #2
2019-11-19 Set Jumbo Frames on Bridges (1)
2019-12-28 Create CPU Pools
2020-02-17 Mount ISO Images
2021-03-28 Rebuild as 3.4.6 Server
Announcements
24 November 2006
28 February 2008
08 November 2008
12 March 2012
27 March 2012
12 April 2012
20 January 2020
09 June 2024
12 June 2024
21 June 2024
Book Reviews
OCM Questions and Answers
Home
>
12C OCM
>
Data and Performance Management
>
Tune SQL statements
Contents
1
References
References
Oracle
®
12.1 Database SQL Tuning Guide
1 Introduction to SQL Tuning
Tasks and Tools for SQL Tuning