Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

AppsDBA CV Download CV Contact Me

Month: August 2017

August 2, 2017 Query to Monitor RMAN Backups
AppsDBA ScriptsDatabase ScriptsScripts

SELECT Count(*)  FROM   v$backup_async_io  WHERE  status = ‘IN PROGRESS’; 

August 2, 2017 Query to Check Oracle Database Growth
AppsDBA ScriptsDatabase ScriptsScripts

This Query Calculate the Datafile Growth on a Yearly Basis

August 1, 2017 Find the Org and Organization mappings
AppsDBA ScriptsScripts

  SELECT   ood.organization_code Warehouse_code,   ood.organization_name Warehouse,   ood.operating_unit OU_ID,   hou.name OU_Name,   hle.name Legal_entity,   hle.set_of_books_id,   gsob.name SOB FROM   org_organization_definitions ood,…

August 1, 2017 How to add System administrator responsibility from backend
APPS DBAAppsDBA ScriptsOracle APPS DBAScripts

Syntax: fnd_user_pkg.addresp(username => v_user_name ,resp_app => ‘SYSADMIN’ ,resp_key => ‘SYSTEM_ADMINISTRATOR’ ,security_group => ‘STANDARD’ ,description => ‘Auto Assignment’ ,start_date => SYSDATE…