Home » RDBMS Server » Server Administration » How to get size in MB of all objects in a Schema in Oracle? (Oracle database, sql)
How to get size in MB of all objects in a Schema in Oracle? [message #682354] Mon, 19 October 2020 04:44 Go to next message
Vinish
Messages: 2
Registered: May 2017
Junior Member
How to get size in MB of all objects in a Schema in Oracle?
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67572
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

USER/ALL/DBA_SEGMENTS

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 Go to previous messageGo to next message
EdStevens
Messages: 1285
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.
Re: How to get size in MB of all objects in a Schema in Oracle? [message #682362 is a reply to message #682361] Mon, 19 October 2020 10:09 Go to previous messageGo to next message
Vinish
Messages: 2
Registered: May 2017
Junior Member
Ok

[Updated on: Mon, 19 October 2020 10:20]

Report message to a moderator

Re: How to get size in MB of all objects in a Schema in Oracle? [message #682365 is a reply to message #682362] Mon, 19 October 2020 16:12 Go to previous message
EdStevens
Messages: 1285
Registered: September 2013
Senior Member
Vinish wrote on Mon, 19 October 2020 10:09
Ok
???

That certainly provides a lot of feedback .....
Previous Topic: SGA used
Next Topic: Oracle Database Cross Platform Migration from 9i to 11g
Goto Forum:
  


Current Time: Sat Dec 05 06:27:36 CST 2020