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

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Scripts

December 2, 2022 How to Get Apps Password From Backend
APPS DBAAppsDBA ScriptsInstallations/Configurations-ApplicationsOracle APPS DBAScripts

How to Get Apps Password From Backend   STEP 1.  First login to Database through Command Prompt sqlplus / as…

November 9, 2017 How to Find Request Group associated for a Program
AppsDBA ScriptsScripts

How to Find Request Group associated for a Program SELECT rg.application_id         “Request Group Application ID”,         rg.request_group_id         “Request Group – Group ID”,         rg.request_group_name,         rg.description,         rgu.unit_application_id,         rgu.request_group_id         “Request Group Unit – Group ID”,         rgu.request_unit_id,         cp.concurrent_program_id, …

November 9, 2017 How to Find Scheduled Concurrent Program
AppsDBA ScriptsScripts

How to Find Scheduled Concurrent Program Below Query will Fetch all the details for a scheduled concurrent program. SELECT a.requested_by,         a.status_code,         a.phase_code, …

October 11, 2017 How to Find Database Object and it’s Corresponding Datafiles
Database ScriptsScripts

How to Find Database Object and it’s Corresponding Datafiles SELECT DISTINCT t.ts#, t.name                AS Tablespace_name, d.name                AS DATAFILE, s.owner, s.segment_name, s.segment_type, s.bytes / 1024 / 1024 AS “MB” FROM   v$tablespace t, v$datafile d, dba_segments s WHERE  t.ts# = d.ts#…