View previous topic :: View next topic
|
Author |
Message |
srinivas_naikk
New User
Joined: 23 Jul 2007 Posts: 26 Location: India
|
|
|
|
Hi All,
I need to find out the size of all the objects in the database.The size should include all the objects (tables, indexes etc) .
Let me know how to find out the size and if there is any query to find the size.
Thanks in advance
Regards,
Srinivas |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Srinivas,
Check the quick formula posted by Anuj in here
Sushanth |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
So, finally people are searching |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
I don't think OP was trying to find out a formula for the tablespace size. More like, what is currently occupied space by a table and associated objects (indexes etc.) all together.
@OP,
Could you explain more about your question? An example would be great. |
|
Back to top |
|
|
|