Home » SQL & PL/SQL » SQL & PL/SQL » How to Calculate the size of Database ,function,Procedure,Package etc.
How to Calculate the size of Database ,function,Procedure,Package etc. [message #378821] Fri, 02 January 2009 00:52 Go to next message
sonalir
Messages: 6
Registered: October 2007
Location: mumbai
Junior Member

Hi Experts,
I want to know the query ,
How to calculate the size of
--DataBase?
--Function?
--Procedure?
--Package?

Thanks ,
SonaliR
Re: How to Calculate the size of Database ,function,Procedure,Package etc. [message #378837 is a reply to message #378821] Fri, 02 January 2009 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1/ Database: query dba_data_files, dba_temp_files, v$log
2/ Code: what is your definition size of code?

Regards
Michel
Re: How to Calculate the size of Database ,function,Procedure,Package etc. [message #378841 is a reply to message #378837] Fri, 02 January 2009 01:32 Go to previous messageGo to next message
Frank Naude
Messages: 4590
Registered: April 1998
Senior Member
For 2, this may help:

SELECT sum(length(text)) "Bytes" 
FROM user_source 
WHERE name = ...
Re: How to Calculate the size of Database ,function,Procedure,Package etc. [message #378850 is a reply to message #378841] Fri, 02 January 2009 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Or DBA_OBJECT_SIZE where it is already aggregated and give other kind of size depending on your need.

Regards
Michel
Re: How to Calculate the size of Database ,function,Procedure,Package etc. [message #378871 is a reply to message #378821] Fri, 02 January 2009 03:56 Go to previous message
sonalir
Messages: 6
Registered: October 2007
Location: mumbai
Junior Member

Thank you very much. Smile
Previous Topic: code practice
Next Topic: How to get the value
Goto Forum:
  


Current Time: Sun Feb 09 22:30:50 CST 2025