[Oracle] Common SQL Rollup

Create user

Create user username identified by password default tablespace temporary tablespace temporary table space;

View table Space Size

Select Tablespace_name, sum (bytes)/1024/1024 from Dba_data_files Group by Tablespace_name;

View table space and utilization

Select A.tablespace_name, Total, free, total-free as used from
(select Tablespace_name, sum (bytes)/1024/1024 as total from Dba_data_files Group by Tablespace_name) A,
(select Tablespace_name, sum (bytes)/1024/1024 as free from Dba_free_space Group by Tablespace_name) b
where a.tablespace_name = B.tablespace_name;

View temporary tablespace and utilization

Select Tablespace_name, tablespace_size/1024/1024 as Total, allocated_space/1024/1024 as used, free_space/1024/1024 as free from Dba_temp_free_space;

Viewing temporary tablespace information

SELECT * from Dba_temp_files;

View index information for a table

SELECT * FROM user_indexes WHERE table_name = ' table name '

View column information for a table

SELECT * from user_tab_columns where table_name= ' table name '

[Oracle] Common SQL Rollup