Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Beginner
Mar 27, 2001

Determining the Size of an Oracle Database


The size of the database is the total size of the datafiles that make up the tablespaces of the database. These details are found in the dba_extents view. Type the following lines at the SQL-PLUS prompt:
 
select sum(bytes/1048576)
from   dba_extents;

This will give the total number of Mb used by your database.
Shiv Gupta
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap