SELECT a.tablespace_name, round( a.bytes/ (1024 * 1024*1024), 2 ) total, round( (b.bytes * 100) / a.bytes, 2 ) "% USED " FROM sys.sm$ts_avail a, sys.sm$ts_used b WHERE a.tablespace_name = b.tablespace_name and a.tablespace_name = 'BLSEA'
Select * FROM DBA_DATA_FILES where tablespace_name = 'BLSEA' ;
ALTER TABLESPACE "BLSEA" ADD DATAFILE '/u02/app/ora11g/users03.dbf' SIZE 32G;
exec dbms_stats.gather_table_stats(ownname => 'BLSEA',tabname => 'KAFKA_COMM',estimate_percent => 10,method_opt=> 'for all indexed columns', degree=>32);