Sql Server 2019 Compatibility

COMPUT Clause is not allowed in Database Compatibility 110 Issue Details- Impact- The COMPUTE clause generates totals that appear as additional summary columns at the end of the result set…. Read more »

Query to check tablespace size and freespace

select b.tablespace_name, tbs_size SizeGb, a.free_space FreeGb from (select tablespace_name, round(sum(bytes)/1024/1024/1024 ,2) as free_space from dba_free_space group by tablespace_name) a, (select tablespace_name, sum(bytes)/1024/1024/1024 as tbs_size from dba_data_files group by tablespace_name UNION… Read more »

Tablespace usage monitoring script

set feedback off set pagesize 70; set linesize 2000 set head on COLUMN Tablespace format a25 heading ‘Tablespace Name’ COLUMN autoextensible format a11 heading ‘AutoExtend’ COLUMN files_in_tablespace format 999 heading… Read more »