OraFAQ Forum: SQL & PL/SQL » Query on Oracle JVM

Home » SQL & PL/SQL » SQL & PL/SQL » Query on Oracle JVM (Oracle 11g)

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

Query on Oracle JVM [message #678889]

Tue, 21 January 2020 00:12

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

Report message to a moderator

Re: Query on Oracle JVM [message #678891 is a reply to message #678889]

Tue, 21 January 2020 00:48

Michel Cadot
Messages: 68264
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.

Report message to a moderator

Re: Query on Oracle JVM [message #678892 is a reply to message #678889]

Tue, 21 January 2020 01:56

John Watson
Messages: 8738
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.

Report message to a moderator

Re: Query on Oracle JVM [message #678915 is a reply to message #678891]

Wed, 22 January 2020 04:50

IshwaryaMurali
Messages: 7
Registered: January 2020

Junior Member

Hi,

Thank you for your response. The information was so helpful

Report message to a moderator

Re: Query on Oracle JVM [message #678916 is a reply to message #678892]

Wed, 22 January 2020 04:51

IshwaryaMurali
Messages: 7
Registered: January 2020

Junior Member

Hi,

Thank you for your response. The information was so helpful

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 17 23:13:38 CDT 2022