SELECT ABBREVIATION,              NAME,              TYPE,              CODELEVEL,              BASELINE        FROM AD_TRACKABLE_ENTITIES ...

--DEFRAGMENT ---Defragment the tables periodically to reclaim unused space / improve performance alter table APPLSYS.FND_CONCURRENT_REQUESTS...

SELECT * FROM dba_network_acls; -- Create ACL and privilege begin   dbms_network_acl_admin.create_acl (     acl         => 'utl_mail....

select * from mtl_material_transactions where costed_flag = 'E'; select *    from org_acct_periods where acct_period_id=13481    --w...

SELECT x.process_type "Name",   DECODE(   (SELECT '1' FROM fnd_concurrent_requests cr,     fnd_concurrent_programs_vl cp, ...

--- Concurrent Request ran in 24 Hours SELECT fcr.request_id "Request ID",        fcp.user_concurrent_program_name "Program...

select CONC.USER_CONCURRENT_PROGRAM_NAME,        CONC.CONCURRENT_PROGRAM_NAME,        CONC.ENABLED_FLAG,        stat.LAST_RUN_DATE,        s...

/* Checking  concurrent programs running currently with Details of Processed time and Start Date */ SELECT DISTINCT          c.USER_CONCURRE...

TEST f60gen module=/u5/applupg2/uatappl/au/11.5.0/forms/US/APXINWKB.fmb userid=APPS/APPS output_file=/u5/applupg2/uatappl/ap/11.5.0/forms/US...

==================================================================== REM REM FILENAME REM   cmclean.sql REM DESCRIPTION REM   Clean out the ...

--To check database locks----[Kill Inactive Session] ---------------------------------------------------- SELECT * FROM dba_locks WHERE bloc...

--How to Cancel a Concurrent Request Stuck in the Queue? [ID 749748.1] --CCM.sql Diagnostic Script for Concurrent Manager [ID 171855.1] --CM...

BEGIN fnd_user_pkg.addresp (username => UPPER ('MUQTHIYAR.PASHA'), resp_app => 'FND', resp_key => 'APPLICATION_...

select * from V$LOG_HISTORY select * from V$ARCHIVE_DEST select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from...