Oracle : Important ASM Commands

Dear Readers, In this article, we will see the following Important ASM Commands. Tab Name : asm_free

Tab Name : ASMCMD>find file find +DATA01 undo* Tab Name : WhatInstances

Tab Name : Rebalance_status

Tab Name : ASM_Candidate

Tab… Read More

Installation of Oracle Database 19c On Windows

Dear Readers, In this article, we will see the following Installation of Oracle Database 19c On Windows. Step-1: 👉 Download the Oracle Database Software Download the Oracle Database 19c software (Windows Version) by the below link. https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c Oracle software will be downloaded in zip format … Read More

Transfer Files from One Server to Another Server Using SFTP

Dear Readers, In this article, we will see the following Transfer Files from One Server to Another Server Using SFTP. Login as root and install sshpass package :

Create text file and Create .sh file Create text file :

Create .sh file :… Read More

Oracle : Check Partition Summary More than N Days (60 Days)

Dear Readers, In this article, we will see the following Check Partition Summary More than N Days (60 Days). Script :

Out Put :

  Thank you for giving your valuable time to read the above information. Follow us on  Website     … Read More

Oracle : TableSpace Menu Bar in SecureCRT

Dear Readers, In this article, we will see TableSpace Menu Bar in SecureCRT . TBS_FREE :

Out Put :

TBS_FILE :

SEGMENTBYNAME :

DBSIZE :

Seg_With_Highest_IO_Reads :

Out Put :

Seg_With_Highest_IO_Writes :… Read More

Log Miner Configuration for Oracle Database

Dear Readers, In this article, we will see the following Log Miner Configuration for Oracle Database. We can easily track history of activity on a database from archived redolog files using log miner. 1.  ENABLE SUPPLEMENTAL LOGGING FOR THE DATABASE

2. CHECK THE… Read More