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?
select OWNER,sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments group by owner order by owner; Share via: Facebook.
V$PDBS displays information about PDBs associated with the current instance. Column. Datatype. Description. CON_ID.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With