Dear Readers, In this article, we wrote an automation job for Shell Script to gather stats for Stale tables. Note : 1) Please test the Shell script in Non-Prod before implementing it in Production. Script for gather stats for Stale tables #!/bin/bash function PreChks {… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Architecture. SNO Article Name Article Link 1 Startup and Shutdown modes in Oracle https://www.ktexperts.com/startup-and-shutdown-modes-in-oracle/ 2 ORACLE ARCHITECTURE -4(PHYSICAL REPRESENTATION OF DATABASE) https://www.ktexperts.com/oracle-architecture-4physical-representation-of-database/ 3 ORACLE OPTIONAL BACKGROUND PROCESSES https://www.ktexperts.com/oracle-optional-background-processes/ 4 ORACLE ARCHITECTURE -2… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Partitioning. SNO Article Name Article Link 1 Partition https://www.ktexperts.com/partition/ 2 Oracle : Partitioning using online Redefinition method which requires minimal downtime https://www.ktexperts.com/oracle-partitioning-using-online-redefinition-method-which-requires-minimal-downtime/ 3 Oracle : High Level steps for Partitioning a non… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle ASM. SNO Article Name Article Link 1 Oracle : Rename ASM Disk Label in Oracle 12c (RAC) https://www.ktexperts.com/oracle-rename-disk-label-rac/ 2 Oracle : Add ASM Disks to existing Diskgroup (RAC) https://www.ktexperts.com/oracle-add-asm-disks-to-existing-diskgroup/ 3 Oracle :… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Tablespaces. SNO Article Name Article Link 1 Tablespace Management in Oracle. https://www.ktexperts.com/tablespace-management-in-oracle/ 2 Oracle : Storage Management https://www.ktexperts.com/oracle-storage-management/ 3 Transportable Tablespace between two pluggable database(PDB’s) https://www.ktexperts.com/transportable-tablespace-between-two-pluggable-databasepdbs/ 4 ORACLE: Cross Platform Transportable Tablespace… Read More
Dear Readers, Please check the below articles to get good knowledge on RMAN (Recovery Manager). SNO Article Name Article Link 1 How to add Container database to Existing RMAN Recovery catalog https://www.ktexperts.com/how-to-add-container-database-to-existing-rman-recovery-catalog/ 2 How to Create an RMAN Recovery Catalog https://www.ktexperts.com/how-to-create-an-rman-recovery-catalog/ 3 Cloning a Standalone… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle 18c. SNO Article Name Article Link 1 Oracle 18c New Features for DBA’s https://www.ktexperts.com/oracle-18c-new-features-for-dbas/ 2 Oracle 18C new feature: Private Temporary Tables https://www.ktexperts.com/oracle-18c-new-feature-private-temporary-tables/ 3 Oracle 18C new feature: Cancel SQL instead of… Read More
Dear Readers, Please check the below articles to get good knowledge on Data Pump (Export & Import). SNO Article Name Article Link 1 How to Kill & Trace Datapunp Job https://www.ktexperts.com/how-to-kill-trace-datapunp-job/ 2 How to Generate DDL from existing dumpfile https://www.ktexperts.com/how-to-generate-ddl-from-existing-dumpfile/ 3 How to utilize PARFILE… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle DataGuard Articles. SNO Article Name Article Link 1 Step By Step Configuration of Oracle DGMGRL Utility https://www.ktexperts.com/step-by-step-configuration-of-oracle-dgmgrl-utility/ 2 Oracle Physical Standby Data guard in 11g https://www.ktexperts.com/oracle-physical-standby-data-guard-in-11g/ 3 Switchover and Switchback in Oracle… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Production Support Scripts. SNO Article Name Article Link 1 Oracle : Check Partition Summary More than N Days (60 Days) https://www.ktexperts.com/oracle-partition-check-summary-more-than-n-days-60-days/ 2 UNDO segments not Releasing Space https://www.ktexperts.com/undo-segments-not-releasing-space/ 3 Oracle : How… Read More
Dear Readers, Please check the below articles to get good knowledge on Performance Tuning. SNO Article Name Article Link 1 Autonomous Health Framework https://www.ktexperts.com/autonomous-health-framework/ 2 Oracle: Free Buffer Wait https://www.ktexperts.com/oracle-free-buffer-wait/ 3 Internal mechanism of Buffer Cache https://www.ktexperts.com/internal-mechanism-of-buffer-cache/ 4 Performance Investigation(Database / SQL) https://www.ktexperts.com/performance-investigation-database-sql/ 5 Oracle:… Read More
Dear Readers, In this article, we will see the following Create AWS EC2 Instance Using Cloud Formation. Steps to Follow : Logging to AWS Account Create a Key Pair Create Stack for creating AWS EC2 Verify EC2 Instance Graphically Connect to EC2 Instance Using Putty… Read More
Dear Readers, This article will see the following Create and configure a virtual cloud network(VCN) by using VCN Wizard. By using this option VCN will create with below-added resources by default Includes: ➸ VCN ➸ Public subnet ➸ Private subnet ➸ Internet gateway (IG) ➸… Read More
Dear Readers, This article will see the following Table Restore Depends On Time in Oracle. We receive requests from the requester stating that they have lost data of some tables and want us to restore it. As it is a time-consuming method to restore the… Read More
Dear Readers, This article will see the following Change DBID in Oracle. NID is the tool that is used to change DBID or database name. Before changing the NID safer side take the backup of the database, and related files dependent on DB. [root@detedb1 ~]$… Read More
Dear Readers, This article will see the following Create and configure a virtual cloud network(VCN). Sign in to Oracle Cloud Infrastructure Console using your cloud tenant name, user name, and password. From the OCI services menu, click Virtual Cloud Networks under Networking. Choose the appropriate… Read More
Dear Readers, This article will see the following Install SQLT and Query Slowness resolved over SQLT profile method. Installing SQLT SQLT installs under its own schemas SQLTXPLAIN and SQLTXADMIN. It does not install any objects into the application schema(s). You can install this version of SQLT in Oracle databases 10.2, 11.1,… Read More
Dear Readers, In this article, we will see the following Install Terraform in Amazon EC2 Instance. Steps to Follow : Logging to AWS Account Launch Linux Server Connect to Linux EC2 Instance by Using Putty Download and Install Terraform Set the path for terraform Start… Read More
Dear Readers, In this article, we will see the following How to Create VPC Using Cloud Formation. Steps to Follow : Logging to AWS Account Create Stack for creating VPC Very VPC Graphically 1. Logging to AWS Account First, we need to AWS Console… Read More
Dear Readers, In this article, we will see the following Install PostgreSQL 12 On RHEL 8 . Steps to Follow : Logging to AWS Account Launch MySQL Server Connect to Linux EC2 Instance by Using Putty Switch to root user Install Server Updates Install wget… Read More
