OraFAQ Forum: Server Administration » How to get size in MB of all objects in a Schema in Oracle?

Home » RDBMS Server » Server Administration » How to get size in MB of all objects in a Schema in Oracle? (Oracle database, sql)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get size in MB of all objects in a Schema in Oracle? [message #682354]

Mon, 19 October 2020 04:44

Vinish
Messages: 2
Registered: May 2017

Junior Member

How to get size in MB of all objects in a Schema in Oracle?

Report message to a moderator

Re: How to get size in MB of all objects in a Schema in Oracle? [message #682360 is a reply to message #682354]

Mon, 19 October 2020 09:43

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

USER/ALL/DBA_SEGMENTS

Report message to a moderator

Re: How to get size in MB of all objects in a Schema in Oracle? [message #682361 is a reply to message #682354]

Mon, 19 October 2020 09:47

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

Vinish wrote on Mon, 19 October 2020 04:44

How to get size in MB of all objects in a Schema in Oracle?

What type of objects? "all" objects could include both segments (tables, indexes, partitions) as well as packages, procedures, triggers, etc.

What is your real goal? Suppose you get the "size". What will you do with it? What decision will be made differently if the size is 10mb vs. 100GB?

If you are just interested in tables/indexes, look at DBA_SEGMENTS.

I've been managing oracle databases since v7.3 in 1995, and have _never_ needed to know the "size" of PL/SQL code.

Report message to a moderator