Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Find Size of a Database in Oracle

Tags:

I have a database named "My_Enterprise_Data". I need to find the size that it occupies on the disk.

How do I find it out?

Is the query, SELECT sum(bytes)/1024/1024 AS "Size in MB" FROM user_segments run against the My_Enterprise_Data correct?

like image 615
Kanini Avatar asked Nov 29 '10 07:11

Kanini


People also ask

How do I find the size of a database Schema?

select OWNER,sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments group by owner order by owner; Share via: Facebook.

What is V PDBS?

V$PDBS displays information about PDBs associated with the current instance. Column. Datatype. Description. CON_ID.


1 Answers

The following will show you the data files used by oracle:

select TABLESPACE_NAME "Tablspace",    FILE_NAME "Filename",    BYTES/1024/1024 "Size MB",   MAXBYTES/1024/1024 "Maximum Size MB",   AUTOEXTENSIBLE "Autoextensible" from SYS.DBA_DATA_FILES 

You can then look for the tablespace used by the My_Enterprise_Data schema

like image 127
Neal Donnan Avatar answered Sep 21 '22 07:09

Neal Donnan