To add two numbers. This article describes how to add two numbers # To Add two numbers a=10 b=5 c=`expr $a + $b` echo “Sum of two numbers=$c” reference
How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN in 19c MT(Multitenant ) database To restore table after accidentally dropped /truncated /delete & commit records (table
Script for Monitoring Oracle databases. Script to monitor sessionlocks,current session and tablespace usage details on RAC database Main script calls 3 SQL queries and sends the output in a mail
Introduction to Oracle Database Administration. What is Oracle? Oracle database is a relational database management system (RDBMS) from Oracle Corporation. This article will explain a complete overview of the Oracle
Different Tools and Applications for Database Administration. For performing database administration activities from “Citrix Workspace for web” or from the remote desktop (Virtual Private Network connection), below mentioned tools are
Flashback issue while restoring the DB with restore point Issue: DB restoration failed to Guarantied Restore point which was created for Application upgrade activity in Development env. Root Cause: Flash
Oracle New Database Build Questionnaire. Before every new Oracle Database creation need to get the below details from the application team. Once we get the required details we can start
The value of Fast Recovery Area % Used for Issue : Fast Recovery Area (FRA) utilization crossed threshold value 75% EM Alert: EM Event: Critical:oprd1 – The value of Fast
Password Function in Oracle PL/SQL PL/SQL Function Purpose: To verify the password while reset the password of the user . Parameters to be passed: Total 3 1) Username ,
Trigger AFTER STARTUP ON DATABASE. Purpose:To start Pluggable databases while starting container Databases if PDBs are in MOUNT state Trigger name: “SYS”.”OPEN_PDBS” Script name: OPEN_DB.sql Purpose:To start Pluggable databases while
