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 … Read more

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, … Read more

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, … Read more

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# … Read more