Category Archives: Scripts

How to check if tablespaces are autoextend

How to check if tablespaces datafiles are autoextend col FILE_NAME for a60 select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from dba_Data_files where TABLESPACE_NAME like ‘Tablespace_Name’; _________________________________________________________________________________________________________________________ col FILE_NAME for a60 select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from… Read more »

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 »