Home » SQL & PL/SQL » SQL & PL/SQL » Procedure Loading in to memory
Procedure Loading in to memory [message #237339] Mon, 14 May 2007 03:38 Go to next message
caliguardo
Messages: 107
Registered: February 2007
Location: Chennai
Senior Member

While calling procedure from package, what will be loaded in to memory? Complete Package or only the called procedure?.
If complete package is loaded,then there is a real performance issue.How this can be overcome?

Can anybody help me on this?
Re: Procedure Loading in to memory [message #237343 is a reply to message #237339] Mon, 14 May 2007 03:46 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Think about it. A package got state, there can be global variables in it etc. It _has_ to be the package that gets loaded.
Why do you think this is a performance issue?
Re: Procedure Loading in to memory [message #237352 is a reply to message #237343] Mon, 14 May 2007 04:11 Go to previous messageGo to next message
caliguardo
Messages: 107
Registered: February 2007
Location: Chennai
Senior Member

While calling a specific Procedure, We may not need other procedures in that package which consumes a lot of memory. So does it not take too much of memory when a package is loaded when only a procedure is needed?
Re: Procedure Loading in to memory [message #237353 is a reply to message #237339] Mon, 14 May 2007 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle loads objects.
Package is an object.
Stand-alone procedure is an object.
Procedure in a package is not an object.

Regards
Michel
Re: Procedure Loading in to memory [message #237357 is a reply to message #237353] Mon, 14 May 2007 04:25 Go to previous messageGo to next message
caliguardo
Messages: 107
Registered: February 2007
Location: Chennai
Senior Member

Thank you for all the replies. NOw things are clear
Re: Procedure Loading in to memory [message #237376 is a reply to message #237339] Mon, 14 May 2007 05:21 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Quote:
While calling a specific Procedure, We may not need other procedures in that package
Then the answer to that may be that those procedures do not belong together in the same package.
Re: Procedure Loading in to memory [message #237410 is a reply to message #237376] Mon, 14 May 2007 07:19 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
pablolee wrote on Mon, 14 May 2007 12:21
Quote:
While calling a specific Procedure, We may not need other procedures in that package
Then the answer to that may be that those procedures do not belong together in the same package.

very bold...
So you say you always use each and every procedure in a package once you call one? Wink
I do agree with the idea of your remark though..
Re: Procedure Loading in to memory [message #237413 is a reply to message #237339] Mon, 14 May 2007 07:31 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Hence the "May Be" Smile I was trying to imply (it might have been more sensible and helpful if I had actually just said...) that the OP might want to look at the sub-programs in the package and possibly re-organise them into more useful groupings.
Previous Topic: Query date range
Next Topic: how to give hint in view
Goto Forum:
  


Current Time: Sun Dec 04 22:34:01 CST 2016

Total time taken to generate the page: 0.06617 seconds