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

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

--- 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...

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