Home » RDBMS Server » Server Administration » How to unload an oracle package from memory? (Oracle 11gR2)
icon4.gif  How to unload an oracle package from memory? [message #605815] Wed, 15 January 2014 02:26 Go to next message
peter21
Messages: 3
Registered: September 2013
Junior Member
Hi all,
I wanted to know how to unload a package from the memory after it has been loaded. I have finished using the package and I am sure that I do not want to use the package anymore.Is it possible to remove it from memory to make efficient use of memory? Thanks in adv. for your reply.


Regards.
Re: How to unload an oracle package from memory? [message #605817 is a reply to message #605815] Wed, 15 January 2014 02:33 Go to previous messageGo to next message
Michel Cadot
Messages: 58947
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You don't need to do that.
Why do you think or what make you think you need it?

[Updated on: Wed, 15 January 2014 02:35]

Report message to a moderator

Re: How to unload an oracle package from memory? [message #605819 is a reply to message #605817] Wed, 15 January 2014 02:37 Go to previous messageGo to next message
Littlefoot
Messages: 19535
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, you can't "unload" it, but you can drop it.
Re: How to unload an oracle package from memory? [message #605820 is a reply to message #605819] Wed, 15 January 2014 02:44 Go to previous messageGo to next message
peter21
Messages: 3
Registered: September 2013
Junior Member
Will it not make memory space available for other activities if I free the space occupied by the package which I am sure I am not going to use?
Re: How to unload an oracle package from memory? [message #605821 is a reply to message #605820] Wed, 15 January 2014 02:46 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
Memory Architecture.

HTH
-g
Re: How to unload an oracle package from memory? [message #605822 is a reply to message #605820] Wed, 15 January 2014 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 58947
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Oracle will unload it when it will need some space if the package has not been used.
All these points are explained in Database Concepts

Re: How to unload an oracle package from memory? [message #605825 is a reply to message #605822] Wed, 15 January 2014 03:05 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
LRU Wink
Re: How to unload an oracle package from memory? [message #605828 is a reply to message #605825] Wed, 15 January 2014 03:17 Go to previous message
peter21
Messages: 3
Registered: September 2013
Junior Member
okay.....thanks alot folks..will refer the Database Concepts pdf Smile
Previous Topic: problem in db startup
Next Topic: OCI can't Initialized
Goto Forum:
  


Current Time: Mon Sep 01 06:50:03 CDT 2014

Total time taken to generate the page: 0.06115 seconds