|
Re: How to find db size, blah blah... [message #7723 is a reply to message #7721] |
Thu, 03 July 2003 01:49 |
Deepa
Messages: 269 Registered: November 2000
|
Senior Member |
|
|
one way to find ur dbsize is
export the whole db.
check out the size of the dmp file u get the db size :)
Overall size.. then
calculate the size of the datafiles,redologfiles etc...
regards,
Deepa
|
|
|
|
Re: How to find db size, blah blah... [message #7734 is a reply to message #7724] |
Thu, 03 July 2003 06:27 |
Deepa
Messages: 269 Registered: November 2000
|
Senior Member |
|
|
U can always search the net for these things.u will get a plenty of info
U have the data dictionary tables which will hold the usedblocks in tablespaces.
From that, u can calculate allocated - used
regards,
Deepa
|
|
|
Re: How to find db size, blah blah... [message #7735 is a reply to message #7721] |
Thu, 03 July 2003 07:48 |
ctg
Messages: 146 Registered: July 2002
|
Senior Member |
|
|
1) tells you total space allocated in each tablespace
SELECT tablespace_name, sum(bytes)
FROM dba_segments
GROUP BY tablespace_name;
2) tells you total freed space (unallocated) in each tablespace
SELECT tablespace_name, sum(bytes)
FROM dba_free_space
GROUP BY tablespace_name;
|
|
|