Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

i want to know the size of of database

575959Oct 31 2007 — edited Oct 31 2007
hi, iam using HP-UX with oracle10G so that, i want to know the size of of database in my system, for that i can use the follwing queries is this is correct or not?
/*
1. select sum(bytes) as total_size from dba_data_files;
ANS is:
TOTAL_SIZE
----------------------
29718740992

2.select sum(bytes) as free_size from dba_free_space;
ANS is:
FREE_SIZE
----------------------
6940393472

3. select sum(bytes) as used_size from dba_segments;
ANS is:
USED_SIZE
----------------------
25215827968

i GOT like this iam not getting is this TOTAL size is 28 GB?????????????



4.select * from DBA_FREE_SPACE_COALESCED;

ANS for this ????????????????



please help me anyone......
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2007
Added on Oct 31 2007
4 comments
2,245 views