Database


11g Database

oracle Gather stats for a table
Oracle Schema gather stats
Get DDL of all tablespaces
Understanding The Oracle Sysaux Tablespace
Understanding Oracle System Tablespace
Purging/Cleaning Sysaux Tablespace In Oracle
Cloning Oracle 12c Database Using Rman Backup Based Duplication
Oracle 12c Background Process-MMAN (Memory Manager)
UNIX Shell Script To Run DataPump Jobs
Step by Step Oracle 11gR2 RAC Standby Database Manual Failover
Upgrade Oracle database from 11g to 12c using the RMAN Backup
Zero downtime database upgrade from 11g to 12c using Oracle Goldengate
Oracle Database Rolling Upgrade From 11g to 12c Using a Data Guard
Step by Step Applying PSU Patch in Oracle 11gR2 in Windows Environment
Oracle Database Security Assessment Tool (DBSAT)

12cR2 database

Understanding The Oracle Sysaux Tablespace
Understanding Oracle System Tablespace
Oracle 12c Background Process-LREG (Listener Registration)
Oracle 12c-2 Node Rac To Single Instance Standby Database Setup
Purging/Cleaning Sysaux Tablespace In Oracle
Oracle 12c Database Cloning Using Hot Backup
Cloning Oracle 12c Database Using Rman Backup Based Duplication
Oracle 12c Background Process-MMAN (Memory Manager)
Oracle 12c Background Process- CTWR (Change Tracking Writer)
Oracle 12c Background Process-MMON (Manageability Monitor)
Oracle GoldenGate vs Oracle Data Guard
Oracle Database Cloning Using Cold Backup
How To Uninstall Oracle Database 12c
Installing Oracle Client In Silent Mode Using Response File
Create Oracle Pluggable Database Manually Using SQL Prompt
Oracle 12c-Multitenant Database Backup Using Rman
Oracle-Delete Old Archives Using RMAN
Oracle Pluggable Database Automatic Startup
Oracle RMAN Backup Using Shell Script
RestAPI for Oracle DBaaS Cookbook
Oracle12c-Transparent Data Encryption (TDE) Tips And Tricks
Oracle Partitioning Tips And Tricks
Oracle 12c Database IN-Memory For Testing
Configure Oracle Database 12c In-Memory Option
Oracle 12c-Auditing Tips And Tricks
Oracle 12c Online Redefinition Tips And Tricks
Improve Performance-Oracle 12c Table Reorganization
Oracle LogMiner Tips And Tricks
Step-by-Step Applying PSU Patch in Oracle 12c For Single-Instance
Oracle Materialized View Tips And Tricks
Upgrade Oracle database from 11g to 12c using the RMAN Backup
Zero downtime database upgrade from 11g to 12c using Oracle Goldengate
Oracle Database Rolling Upgrade From 11g to 12c Using a Data Guard
Oracle Database Security Assessment Tool (DBSAT)
Step by step apply 12c Grid and DB April 2018 PSU to Oracle 12cR1 2 node RAC
Step by step Oracle EBS R12.1 Installation
Oracle Database 12cR2 Installation in RHEL 7.4

18c Database

Oracle 18c New Initialization Parameters
Oracle 18c New Feature – Finding Database Version using Oraversion Utility
oracle Gather stats for a table
Oracle Archivelog generation per hour
Oracle Database Size
Step by Step Oracle TimesTen In-Memory Database Installation On Linux
UNIX Shell Script To Run DataPump Jobs
Oracle Database Cloning Using Cold Backup
Scaling Down Autonomous Data Warehouse Database
What Is Docker?
How Does DevOps Help to Oracle DBA
What is DevOps?
RestAPI for Oracle DBaaS Cookbook
Oracle Database 18.3.0 Installation On Premises Windows
Oracle 18c Datapump-ADD_FILE Parameter
Step by Step to Configure Oracle 18c Database using DBCA Method
Step by Step Oracle 18c Installation On Linux
Available On-Premise Oracle Database 18c (18.3) for Linux x86-64
Oracle Database Security Assessment Tool (DBSAT)
Oracle 18c-Private Temporary Tables
Monitoring Oracle 18c Cloud Databases Using DBaaS Monitor Console
Scaling Up Storage for Oracle 18c Database Deployment
Administering Oracle Database Cloud Service Using dbaascli Utility
Oracle-18c Read-Only Oracle Home
Oracle-18c New Default Location of Oracle Database Password File
Creating an Oracle 18c Database Cloud Service Instance
Creating a Free Account In Oracle Cloud
Patching Oracle 18c Database Cloud Service (DBaas) instance
Oracle 18c-Online MERGE PARTITION and MERGE SUBPARTITION
Data Recovery Advisor in Oracle Database 18c
Oracle 18c new feature’s in SQL*Plus utility
Oracle 18c : MEMOPTIMIZE_POOL_SIZE in SGA
Oracle 18c – Cancel SQL Statement in a Session

19c database

Zero Downtime Database Upgrade From 12c To 19c Using Oracle Goldengate
Change Archivelog Destination In Oracle
Oracle 19c New Features Automatic Database Diagnostic Monitor (ADDM) Support for PDB Database
Dataguard Changes In Oracle Database Release 19c
Oracle 19c Database Release Update Revision 19.4.1.0.0
Release Update Patch Deinstallation on oracle 19c (Patch 30125133)
Oracle Database 19c Proactive Patch Information (Doc ID 2521164.1)
Oracle Release And Support Timeline For Oracle Database 19c
Manual Upgrades to Non-CDB Oracle Database 19c
RPM Checker when Installing Oracle Database 19c
Oracle 19c Database Upgrade Matrix.
Upgrading to Oracle Database 19c using DBUA
Oracle 19c Real Application Clusters (RAC)
Oracle19c Database Technical Architecture
Deinstallation Release Update Patch on oracle 19c (Patch 29834717)
Oracle 19c New Features-Cloning PDBs Using DBCA in Silent Mode
Oracle 19c New Features Data Pump Parameter (MAX_DATAPUMP_PARALLEL_PER_JOB)
Oracle 19c New Features Data Pump Parameter (MAX_DATAPUMP_JOBS_PER_PDB)
Oracle19c-Export Data From Physical Standby Database Using Datapump
Oracle-19c Recover a loss of all online redo log files using RMAN
Oracle 19c RPM Based Installation And Database
Oracle 19c-Creating Non-Cdb Database In Silent Mode
Oracle 19c Deinstall Database
Step by Step to configure Oracle 19c Data Guard Physical Standby (19.3.0.0)
Oracle Database 19c: How To Create The Container Database
Creating Database Using DBCA In Oracle 19c
Oracle 19c – Table Recovery Using RMAN Backup
Manually Creating an Oracle 19c Database
How To Change Archivelog mode and Destination In Oracle 19c
Step by Step Oracle 19c Installation On Linux
Oracle Database 19c Now Available on Linux
Oracle 19c Database Cloning Using Hot Backup
Step By Step install Oracle 19c Database on OEL 7.6 (64-Bit)
Oracle Database 19.2 for Exadata is now available for download
Now Available Oracle19c Database in LiveSQL