Home » SQL & PL/SQL » SQL & PL/SQL » Query on Oracle JVM (Oracle 11g)
Query on Oracle JVM [message #678889] Tue, 21 January 2020 00:12 Go to next message
IshwaryaMurali
Messages: 7
Registered: January 2020
Junior Member
Hi All,

The query is,

"When we create a java stored procedure in oracle 11g, will JVM load the java program each time or it will load only once when it is created". May i know how to confirm the same.

Thank you in advance Smile
Re: Query on Oracle JVM [message #678891 is a reply to message #678889] Tue, 21 January 2020 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 67288
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It is loaded the first time it is used and after each time it has been removed from the memory due to lack of space.

Re: Query on Oracle JVM [message #678892 is a reply to message #678889] Tue, 21 January 2020 01:56 Go to previous messageGo to next message
John Watson
Messages: 8315
Registered: January 2010
Location: Global Village
Senior Member
By "load" do you mean read into memory? Stored Java procedures are cached in the library cache of the shared pool, as are SQL statements and stored PL/SQL. THe library cache is managed by an LRU (Least Recently Used) algorithm. You can see what is cached right now by querying v$db_object_cache.
Re: Query on Oracle JVM [message #678915 is a reply to message #678891] Wed, 22 January 2020 04:50 Go to previous messageGo to next message
IshwaryaMurali
Messages: 7
Registered: January 2020
Junior Member
Hi,

Thank you for your response. The information was so helpful
Re: Query on Oracle JVM [message #678916 is a reply to message #678892] Wed, 22 January 2020 04:51 Go to previous message
IshwaryaMurali
Messages: 7
Registered: January 2020
Junior Member
Hi,

Thank you for your response. The information was so helpful
Previous Topic: ORA-00604 & ORA-28003 - Even when not trying to change password
Next Topic: XMLQUERY: ORA-01427: single-row subquery returns more than one row
Goto Forum:
  


Current Time: Thu Aug 06 16:24:16 CDT 2020