Expert Oracle Posts

Couple of Oracle Application Concurrent Manager related scripts which we use frequently. A) UNDER WHICH MANAGER THE REQUEST WAS RUN SELECT b.user_concurrent_queue_name FROM fnd_concurrent_processes a…

Below are some of the useful scripts related to Oracle Applications database

–FIND DATABASE SIZE

 select 'DATA_n_INDEX: ' || sum(bytes)/1024/1024/1024 || ' GBytes' DATABASE_SIZE from dba_data_files
union
select 'TEMP: ' || sum(bytes)/1024/1024/1024 || ' GBytes' from dba_temp_files
union
select 'REDO LOGS: ' || sum(bytes)/1024/1024/1024 || ' GBytes' from v$log
union
select 'CONTROLFILE: ' || sum(FILE_SIZE_BLKS*BLOCK_SIZE)/1024/1024 || ' MBytes' from v$controlfile;