oracle tablespace usage

Solutions on MaxInterview for oracle tablespace usage by the best coders in the world

showing results for - "oracle tablespace usage"
Sofia
21 May 2019
1SELECT T1.TABLESPACE_NAME,
2       T1.BYTES / 1024 / 1024   as                        "bytes_used (Mb)",
3       T2.BYTES / 1024 / 1024   as                        "bytes_free (Mb)",
4       T2.largest / 1024 / 1024 as                        "largest (Mb)",
5       round(((T1.BYTES - T2.BYTES) / T1.BYTES) * 100, 2) percent_used
6FROM (
7         select TABLESPACE_NAME,
8                sum(BYTES) BYTES
9         from dba_data_files
10         group by TABLESPACE_NAME
11     ) T1,
12     (
13         select TABLESPACE_NAME,
14                sum(BYTES) BYTES,
15                max(BYTES) largest
16         from dba_free_space
17         group by TABLESPACE_NAME
18     ) T2
19where T1.TABLESPACE_NAME = T2.TABLESPACE_NAME
20order by ((T1.BYTES - T2.BYTES) / T1.BYTES) desc;
Jose
04 Sep 2019
1-- Size and usage of tablespaces
2SELECT T1.TABLESPACE_NAME,
3       T1.BYTES / 1024 / 1024   as                        "bytes_used (Mb)",
4       T2.BYTES / 1024 / 1024   as                        "bytes_free (Mb)",
5       T2.largest / 1024 / 1024 as                        "largest (Mb)",
6       round(((T1.BYTES - T2.BYTES) / T1.BYTES) * 100, 2) percent_used
7FROM (
8         select TABLESPACE_NAME,
9                sum(BYTES) BYTES
10         from dba_data_files
11         group by TABLESPACE_NAME
12     ) T1,
13     (
14         select TABLESPACE_NAME,
15                sum(BYTES) BYTES,
16                max(BYTES) largest
17         from dba_free_space
18         group by TABLESPACE_NAME
19     ) T2
20where T1.TABLESPACE_NAME = T2.TABLESPACE_NAME
21order by ((T1.BYTES - T2.BYTES) / T1.BYTES) desc;
Delilah
17 Feb 2020
1CREATE TABLESPACE
2TBS_NOME_TABLESPACE
3DATAFILE 'NOME_DATAFILE.dbf' SIZE 40M ONLINE;
Silvana
18 Jan 2020
1CREATE TABLE TB_NOME_TABELA
2(
3CODIGO NUMBER(38)
4)TABLESPACE TBS_NOME_TABLESPACE;
queries leading to this page
tablespace oracleavailable tablespace in oraclehow to check tables size in oraclecreate user pdv interface identified by juno 2020 default tablespace dadostable spaceoracle see tablespacestable and tablespace in oracle19coracle how to get tablespaceoracle system tablespace fulltablespace free size in oracleoracle 9i tablespace usagetablespaces size oraclecheck freespace in tablespace oracleoracle tablespace dataoracle select size all tablespacepermanent tablespace in oracleoracle tablespace size in gbselect all tablespace from database oracletablespace usage script oracleview tablespaces oraclesystem tablespace in oracle fullselect tablespace oracleextents in oracle tablespaceoracle table size queryoracle tablespacesoracle tablespace usagetablespaces in oracleoracle show size of tablespacecheck size of tablespace in oracleoracle tablespace tables listoracle what is a tablespaceoracle how to create tablespacesize of a table oracleoracle tablespace list sqlcheck tablespace in oraclewhy tablespace is required in oracletablespaces oracleoracle tablespace usage queryoracle get tablespace sizeget tablespace size oracleoracle list tablespacesadvantage of using tablespace oracleview tablespace size oracleoracle tablespace sizeoracle disk space table size querytablespace management in oraclemodify tablespace size oraclewho use system tablespace in oracleselect tablespace size oraclewhat are the tablespaces in oracleoracle tablespace usage by objecttablespace usage in oracletablespaces oracle queryselect 2a tablespace oracleoracle get current tablespace usagecheck all tablespace and the size in oracletablespace in oracletablespace size in oracledrop tablespace oracletable and tablespace in oracletablespace oracle size checktablespace with example in oracle19cget tablespace in oracleoracle sql developer create tablechange tablespace size oracleoracle tablespace queryliquibase oracle tablespacewhat is a tablespace in oracleselect tablespace in oracleoracle get tablespace infooracle tables in tablespacesize of oracle tabletablespace history usage oracleoracle table sizecheck tablespace size in oraclewhat is tablespace in oracletablespacetablespace oracle d c3 a9finitionoracle select tablespacetablespace free size in oracleoracle list tablespacetablespace structure oracletablespace size oracle querycheck tablespace size oraclewhat is an oracle tablespacewhy to use tablespace oraclewhat is sysaux tablespace in oracleoracle free tablespaceoracle tablespacetable size in oraclewhen tablespace created in oracleoracle tablespace usage