1) Go to system administrator > Concurrent > Program > Define.
Search for the program name and copy the executable name.
2) Use below query and paste the executable name.
SELECT APPLICATION_NAME,'$'||BASEPATH||'/'||'reports/US' Reports_Path,EXECUTION_FILE_NAME FROM APPS.FND_EXECUTABLES_VL A, APPS.FND_APPLICATION_VL B WHERE EXECUTION_METHOD_CODE='P' AND A.APPLICATION_ID=B.APPLICATION_ID AND EXECUTION_FILE_NAME like '%&RDF_NAME%';
SELECT
owner,
segment_name AS table_name,
ROUND(SUM(bytes) / 1024 / 1024 / 1024, 2) AS size_gb
FROM
dba_segments
WHERE
segment_type = 'TABLE'
AND segment_name in ('FV_GTAS1_PERIOD_BALANCES_V_BKPSK','FV_DACT_PERIOD_BALANCES_V_BKPSK','FV_DACT_ENDING_BALANCES_BKPSK','FV_GTAS_ENDING_BALANCES_BKPSK')
AND owner = ('HHSBKP')
GROUP BY
owner, segment_name;
Size of the objects in Tablespace
SELECT
owner,
segment_name,
segment_type,
tablespace_name,
ROUND(SUM(bytes) / 1024 / 1024/1024, 2) AS size_GB
FROM
dba_segments
WHERE
tablespace_name = 'UFMSD'
GROUP BY
owner, segment_name, segment_type, tablespace_name
ORDER BY
size_GB DESC;
Include Total and Used Space for That Tablespace:
SELECT
df.tablespace_name,
ROUND(df.total_space_mb, 2) AS total_space_mb,
ROUND(NVL(fs.free_space_mb, 0), 2) AS free_space_mb,
ROUND(df.total_space_mb - NVL(fs.free_space_mb, 0), 2) AS used_space_mb,
ROUND((NVL(fs.free_space_mb, 0) / df.total_space_mb) * 100, 2) AS free_percent
FROM
(SELECT
tablespace_name,
SUM(bytes) / 1024 / 1024 AS total_space_mb
FROM
dba_data_files
WHERE
tablespace_name = 'YOUR_TABLESPACE_NAME'
GROUP BY
tablespace_name) df
LEFT JOIN
(SELECT
tablespace_name,
SUM(bytes) / 1024 / 1024 AS free_space_mb
FROM
dba_free_space
WHERE
tablespace_name = 'YOUR_TABLESPACE_NAME'
GROUP BY
tablespace_name) fs
ON
df.tablespace_name = fs.tablespace_name;
SELECT name, total_mb/1024, free_mb/1024, usable_file_mb/1024, offline_disks
FROM v$asm_diskgroup
WHERE name = 'DATAC1';
SELECT type, SUM(bytes)/1024/1024/1024 AS size_gb
FROM v$asm_file
WHERE group_number = (SELECT group_number FROM v$asm_diskgroup WHERE name = 'DATAC1')
GROUP BY type;
