Home » SQL & PL/SQL » SQL & PL/SQL » Size of Packege/Procedure
Size of Packege/Procedure [message #248456] Fri, 29 June 2007 02:09 Go to next message
kumarn
Messages: 13
Registered: June 2007
Location: London
Junior Member

Hi,

Can anyone tell me how can I see 'How much space/size has been occupied by a Package/Procedure'?

Regards,
Kumar
Re: Size of Packege/Procedure [message #248475 is a reply to message #248456] Fri, 29 June 2007 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Precise your question.
Source? Compiled object? In database? In memory? Where? When?

Regards
Michel


Re: Size of Packege/Procedure [message #248476 is a reply to message #248456] Fri, 29 June 2007 02:48 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Used when? When it's executed?

MHE
Re: Size of Packege/Procedure [message #248482 is a reply to message #248476] Fri, 29 June 2007 02:58 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
and why?
Are you not going to execute it if it is too large?
Are you going to split it? If so, apparently it is not modular enough and you should split it anyway.
What wisdom would that knowledge bring you?
Re: Size of Packege/Procedure [message #248488 is a reply to message #248482] Fri, 29 June 2007 03:25 Go to previous messageGo to next message
kumarn
Messages: 13
Registered: June 2007
Location: London
Junior Member
My question is relevent to the size occupied by a compiled object in database.

Actually I want to migrate some selected procedure/packages/functions/tables to a new schema(not created yet) and my administrator asked me about the approx. size required for the new schema.

I want to know how much space is being occupied by the compiled packages/procedure/functions and tables.

I am using Oracle 8i.

Regards,
Kumar
Re: Size of Packege/Procedure [message #248490 is a reply to message #248488] Fri, 29 June 2007 03:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> desc DBA_OBJECT_SIZE
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 OWNER                            NOT NULL VARCHAR2(30)
 NAME                             NOT NULL VARCHAR2(30)
 TYPE                                      VARCHAR2(13)
 SOURCE_SIZE                               NUMBER
 PARSED_SIZE                               NUMBER
 CODE_SIZE                                 NUMBER
 ERROR_SIZE                                NUMBER

Regards
Michel
Re: Size of Packege/Procedure [message #248499 is a reply to message #248456] Fri, 29 June 2007 03:59 Go to previous messageGo to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
Hi michel,

select banner from v$version

BANNER
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Prod
PL/SQL Release 10.1.0.4.0 - Production
CORE 10.1.0.4.0 Production
TNS for Linux: Version 10.1.0.4.0 - Production
NLSRTL Version 10.1.0.4.0 - Production


when i give the
Quote:
desc DBA_OBJECT_SIZE
in my system

The Error Shows like:
Quote:
To describe an object, type

DESCRIBE < object name > in the command pane
...

why its happend?
Re: Size of Packege/Procedure [message #248502 is a reply to message #248499] Fri, 29 June 2007 04:17 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do as your tool says it.
I used SQL*Plus.

Regards
Michel
Previous Topic: How to detect the special characters in string
Next Topic: Days between two dates excluding saturday and sunday
Goto Forum:
  


Current Time: Sun Dec 04 16:22:28 CST 2016

Total time taken to generate the page: 0.32944 seconds