var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: database size and instance info
how do you find out how big your database is ?
how do you find out how many instances your database has ?
File size ???
sql> select sum(bytes) from dba_data_files; --- Tablespace data
sql> select sum(bytes) from dba_extents; -- You can add and owner =
where clause to look at specific schemas
sql> select * From v$instance;
thank you, one more question:
how do I get the total database size in MB or in GB ?
sum(bytes)/1048576 --- mg