Category Archives: Oracle

How to check datapump job status

How to check Export/Import data pump job status Monitor export/Import with the data pump views – The main view to monitor Export/Import jobs are dba_datapump_jobs and dba_datapump_sessions. set line 190… Read more »

Check free space in UNDO Tablespace

How to check free space in UNDO tablespace select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB – USAGEMB) FREEMB from (select sum(bytes) / 1024 / 1024 SIZEMB, b.tablespace_name from dba_data_files a, dba_tablespaces b where… Read more »