Home » SQL & PL/SQL » SQL & PL/SQL » Package (9i)
Package [message #377041] Fri, 19 December 2008 10:09 Go to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
I seen in places that when we call a package first it will load into the memory from the server......thus further call there is no require disk input/output...........Is it correct
Re: Package [message #377043 is a reply to message #377041] Fri, 19 December 2008 10:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes unless they are swap out of the memory.

Regards
Michel
Re: Package [message #377046 is a reply to message #377043] Fri, 19 December 2008 10:54 Go to previous messageGo to next message
rputtagunta
Messages: 5
Registered: March 2008
Location: Texas, USA
Junior Member
Michel,

I am not the original poster, but, what view would you use to see if the package is in the memory or not?
Re: Package [message #377047 is a reply to message #377046] Fri, 19 December 2008 10:57 Go to previous messageGo to next message
Frank Naude
Messages: 4593
Registered: April 1998
Senior Member
You can use something like: dbms_shared_pool.sizes(200);

See Pin Objects in the Shared Pool.
Re: Package [message #377050 is a reply to message #377046] Fri, 19 December 2008 11:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
v$db_object_cache

Regards
Michel
Re: Package [message #377060 is a reply to message #377050] Fri, 19 December 2008 13:13 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
Ok Michael...........then suppose there is 2 user you and me if i call a package first time it will load into the memory from the server...........then you call the same package.......in your turn where it will take from the memory or server because you are different user.
Re: Package [message #377062 is a reply to message #377060] Fri, 19 December 2008 13:27 Go to previous messageGo to next message
rputtagunta
Messages: 5
Registered: March 2008
Location: Texas, USA
Junior Member
No it won't. Why would it compile and put it in the memory again even if it's a different user?
Re: Package [message #377063 is a reply to message #377060] Fri, 19 December 2008 13:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Codes are shared.
The second session will use the code that is in memory.

Regards
Michel
Re: Package [message #377115 is a reply to message #377063] Sat, 20 December 2008 06:29 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
Michael it means that when we run the package first time it will load the package from the server to the memory........after that any user will login and use that package it will take from the memory only not from the server..........Am i right??
Re: Package [message #377121 is a reply to message #377115] Sat, 20 December 2008 09:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 19 December 2008 17:29
Yes unless they are swap out of the memory.

Regards
Michel


[Updated on: Sat, 20 December 2008 09:15]

Report message to a moderator

Re: Package [message #377149 is a reply to message #377121] Sat, 20 December 2008 14:18 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
Thanks Michael
Re: Package [message #377150 is a reply to message #377149] Sat, 20 December 2008 14:21 Go to previous message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
Sorry..................Thanks Michel
Previous Topic: Dynamic Averages
Next Topic: UPDATING() Doubt
Goto Forum:
  


Current Time: Mon Feb 17 18:48:16 CST 2025