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