SQL Joins

Dear Readers, In this article, we will see the SQL Joins. Joins A join is a query that combines rows from two or more tables Join Conditions Most join queries contain WHERE clause conditions that compare two columns, each from a different table. Such a… Read More

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

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