OraFAQ Forum: Server Administration » How to unload an oracle package from memory?

Home » RDBMS Server » Server Administration » How to unload an oracle package from memory? (Oracle 11gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to unload an oracle package from memory? [message #605815]

Wed, 15 January 2014 02:26

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.

Report message to a moderator

Re: How to unload an oracle package from memory? [message #605817 is a reply to message #605815]

Wed, 15 January 2014 02:33

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, you can't "unload" it, but you can drop it.

Report message to a moderator

Re: How to unload an oracle package from memory? [message #605820 is a reply to message #605819]

Wed, 15 January 2014 02:44

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?

Report message to a moderator

Re: How to unload an oracle package from memory? [message #605821 is a reply to message #605820]

Wed, 15 January 2014 02:46

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Memory Architecture.

HTH
-g

Report message to a moderator

Re: How to unload an oracle package from memory? [message #605822 is a reply to message #605820]

Wed, 15 January 2014 03:03

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to unload an oracle package from memory? [message #605825 is a reply to message #605822]

Wed, 15 January 2014 03:05

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

LRU

Wink

Report message to a moderator

Re: How to unload an oracle package from memory? [message #605828 is a reply to message #605825]

Wed, 15 January 2014 03:17

peter21
Messages: 3
Registered: September 2013

Junior Member

okay.....thanks alot folks..will refer the Database Concepts pdf Smile

Smile

Report message to a moderator

Previous Topic:	problem in db startup
Next Topic:	OCI can't Initialized

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 23:04:40 CST 2025