Bright DBA

ORACLE DBA – Tips and Techniques

Skip to content
  • Home
  • TrainingNew
  • DBA Monitor
    • OS
    • DATABASE
    • NETWORK
    • STORAGE
  • DB-Generic
    • DB-Install
      • Install 10g
      • Install Oracle Software in silent mode 11gR2
      • Deinstall Oracle 11gR2 Database binaries
      • Uninstall Oracle Client on Windows
      • Create database -DBCA silent mode
      • Delete database -DBCA silent mode
      • Drop Database
      • Patch Terminology
    • DB-Admin
      • How to change SQL  prompt to show connected user and database name
      • Change Archive Dest
      • Enable Archivelog
      • How to Recover Loss of DATA – (Without a Backup!)
      • Configure OEM DBConsole manually
      • Proxy User
      • Database Link
      • DBMS_SCHEDULER
      • Enable/Disable JOBS during Maintenance
      • ORA-00054
      • Blocking Sessions
      • Create Service using DBMS_SERVICE
      • Error TNS-12543
      • Store DB credentials in Oracle Wallet
      • Under Edit
  • BACKUP
    • BACKUP ORACLE HOME AND INVENTORY
    • EXP/IMP
    • Datapump
      • SCHEMA REFRESH FROM 11G TO 12C PDB
    • RMAN
      • CATALOG
      • RMAN Database Restore RAC – RAC
      • RMAN Database Restore ASM – ASM
      • RMAN Database Restore from ASM to File System
      • RMAN ACTIVE DUPLICATION ASM TO ASM
      • Backup Based RMAN Duplicate Database
  • PT
    • Tuning Stage 1
      • Statistics
      • Oracle Histograms
      • Export/Import schema statistics
      • CONTROL MANAGEMENT PACK ACCESS
      • Generate Explain Plan
      • SQL Query is really hanged or not
    • Tuning Stage 2
      • STATSPACK
      • ASH
      • AWR
      • Colored SQL_ID
      • SYSAUX Tablespace
    • Tuning Stage 3
      • Troubleshooting Long Running Queries
      • SQL Tuning Advisor
      • SQLT
        • How to Install SQLT
        • How to Run SQLT
        • How to Create Custom SQL Profile
        • Uninstall SQLT
      • Tracing
      • TRCA – Trace Analyzer
  • HA
    • DG 11g
      • CONFIGURATION
        • Active Dataguard on Non-ASM
        • Active Dataguard on ASM
        • Convert Physical Standby Database to Snapshot Standby Database
        • Convert Snapshot Standby database to Physical Standby database
        • Configure Cascading Standby Database
        • DG Broker Configuration
        • DG Broker Error – ORA-16714
        • Disable DG Broker
      • SWITCHOVER
        • Switchover Manual No-Broker
        • Switchover with Broker
      • FAILOVER
        • Failover with Broker(No Flashback)
        • Failover with No Broker (No Flashback)
        • Failover with Broker using Flashback
        • Failover with No Broker using Flashback
      • Enable Real-Time Apply
      • Apply DB PSU on Standby
      • Refresh Standby Database using RMAN Incremental SCN Backup
      • Resetlogs on Primary where Standby in place
      • Drop SRL
    • DG 12c
      • 12.2 Active Dataguard in CDB on Non-ASM
      • Create Physical Standby using RMAN Backup Without Duplicate Command
      • Create Physical Standby using RMAN Backup with Duplicate Command
      • 12c DG Broker Configuration
      • Upgrade Database to 12.2 with Physical Standby
    • ASM
      • Move ASM Spfile to diff. DiskGroup
      • ASM Commands
      • Instantiating disk: failed
      • CSSD won’t start automatically
  • RAC
    • Create users, groups and Paths for Oracle RAC
    • Configure ASMLib for Oracle ASM
    • Configure UDEV Rules for Oracle ASM
    • RAC Install
      • RAC Install 11.2.0.3
      • Upgrade GI to 11.2.0.4
      • Downgrade GI to 11.2.0.3
      • root.sh failed with ORA-29783 on RAC
      • Delete Node
      • Add Node
      • Delete Node without remove software
      • Add Node Back which was DELETED without remove software
    • RAC Admin
      • How to take OCR backup on 11.2.0.4
      • Cluster Name
      • Move/Relocate OCR
      • Restore loss of all VOTE disk
      • Cluster Startup issues
      • Add SCAN
    • RAC Tools
      • CLUVFY
      • OSWatcher
    • RAC Standby 12.2
    • Create ACFS File System on RAC
  • GG
    • GG 11g
      • GoldenGate Installation
      • Unidirectional DML Replication
      • Zero Downtime Migration
      • DDL Replication
    • GG 12C
      • GoldenGate 12C Installation
      • Integrated Capture
      • Oracle GoldenGate Heterogeneous Replication
      • Credential Store
      • ADD NEW TABLE TO AN EXISTING GOLDENGATE CONFIGURATION
    • GG 19C
      • Install Oracle GoldenGate 19C for Database 12C
      • Install Oracle GoldenGate 19C for Database 19C
  • 12c/18c/19c
    • Install 12.2 Database Binaries in silent mode
    • Upgrade DB Manually 11.2.0.4 to 12.2.0.1
    • Upgrade DB using DBUA from 11.2.0.4 to 12.2.0.1
    • CREATE PDB USING SEED
    • CREATE NEW PDB BY CLONING AN EXISTING PDB
    • CREATE PDB USING DBCA
    • DROP PDB MANUALLY
    • Configure OEM Express 12c
    • CREATE NON-CDB ON ORACLE 12C IN SILENT MODE
    • Create Non-CDB on Oracle 12c using DBCA (GUI)
    • Convert Non-CDB to PDB with DBMS_PDB
    • SCHEMA REFRESH FROM 11G TO 12C PDB
    • STARTUP/SHUTDOWN CDB AND PDB
    • Apply RU on DATABASE 12.2
    • ROLLBACK RU from DATABASE 12.2
    • How to Change MAX_STRING_SIZE on Physical Standby Environment
    • 18C
      • Install 18c
      • Deinstall Oracle 18c Database Binaries
      • 18c DB Patching
    • Install 19c GUI
    • Install 19c in silent mode
    • Oracle 19c Deinstall
    • Create DB 19C – DBCA-GUI
    • Create DB 19C – DBCA-SILENT
    • Apply Patch RU on Database 19c
    • Upgrade Oracle Database from 12.2.0.1 to 19c using DBUA
    • Upgrade Oracle Database Manually from 12.2.0.1 to 19c
    • Rolling Upgrade With an Existing Physical Standby Database
    • Upgrade TIMEZONE Version
  • Scripts
    • DBA Sheet v6.1
    • DBA Sheet v7.0
    • DBA Daily Report
    • Generate INSERT statements from the SELECT query
    • Generate INSERT statements to a flat file using a PL/SQL query
  • EM
    • Install OEM 13.2
    • Install OEM 13.3
    • Add Targets Manually on EM Cloud Control 13c
    • Upgrade OMSPatcher
    • Apply Patch on OMS 13.1
    • Apply Patch on Agent 13.1
  • Non-OracleDBA
    • MS SQL
    • MySQL/MariaDB
    • PostgreSQL
      • Install PostgreSQL 13 using yum Repository on Linux
      • Install PostgreSQL Using Source Code
      • How to START/STOP PostgreSQL 13 on Linux
      • Create Database in PostgreSQL
    • DB2
      • Install DB2 V10.5 using GUI
      • DB2 STOP and START
      • DB2 Troubleshooting Guide
  • DevOps
    • Jenkins
      • How to Install Jenkins on Linux
  • YouTube

Flow chart 1

Published on August 12, 2018 in Troubleshooting Long Running QueriesFull resolution ( × )
← Previous
About me - Rajasekhar Amudala