OraFAQ Forum: Server Administration » "Exectution" field not updated in V$SQLAREA

Home » RDBMS Server » Server Administration » "Exectution" field not updated in V$SQLAREA

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

"Exectution" field not updated in V$SQLAREA [message #285765]

Wed, 05 December 2007 09:07

neilsoncarlos
Messages: 2
Registered: December 2007
Location: sp

Junior Member

Hello folks,

I´m execution a query in a piece of Java code and I´m not using "binds", i.e., I´m doing the following:

stmt = myConn1.prepareStatement(new_query1 + "'" + custcodeSQL + "'" + new_query2);

But I don´t know why the "Executions" field in sys.v_$sqlarea doesn´t not increment as I execute the code more the once. "Executions" field is "1" no matter how many times I execute the query. It should happen when I use binds, right?

Does anyone know why it´s happening?

thanks a lot!

Neilson

Report message to a moderator

Re: "Exectution" field not updated in V$SQLAREA [message #285767 is a reply to message #285765]

Wed, 05 December 2007 09:13

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you prepare and execute several queries with different values then they are different queries, so you execute each one only once.

Regards
Michel

Report message to a moderator

Re: "Exectution" field not updated in V$SQLAREA [message #285769 is a reply to message #285767]

Wed, 05 December 2007 09:25

neilsoncarlos
Messages: 2
Registered: December 2007
Location: sp

Junior Member

but all Executions should go to V$SQLAREA, right?
That´s not happening...
if I change the value, It sould appear a new line in V$SQLAREA or increment the number of Executions... did I misunderstand it?
thanks for replying Michel Smile

Report message to a moderator

Re: "Exectution" field not updated in V$SQLAREA [message #285771 is a reply to message #285769]

Wed, 05 December 2007 09:43

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe Oracle choose to remove your query from the SGA because it needed space.

Regards
Michel

Report message to a moderator

Previous Topic:	Grid concept
Next Topic:	strange objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:14:06 CDT 2024