Home » RDBMS Server » Performance Tuning » Instance Efficiency
Instance Efficiency [message #265817] Fri, 07 September 2007 08:26 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Dear techs

According to the stat report of our database the following
efficiency seems very low


Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Execute to Parse %: 31.78
Parse CPU to Parse Elapsed %: 79.41

Can anyone advice me whats the way to improve these instance efficiency.


Database informations:
----------------------

oracle 9i (9.2.0.7.0)
OS : Redhat linux 3
Re: Instance Efficiency [message #265821 is a reply to message #265817] Fri, 07 September 2007 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Change your application.
They have to use bind variables.
They have to not close the cursor they execute multiple times.

Nothing to do at database level, it is an application thing.

Regards
Michel

Re: Instance Efficiency [message #265824 is a reply to message #265821] Fri, 07 September 2007 09:08 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member


Thank you so much ,Thats right.


please help me to close the cursor for following sample procedure.

declared variables in package;

This below procedure available in package body

PROCEDURE PROC_testnet_GETESB
(SBCursor IN OUT PACK_UTILITY.Type_Cursor,
nSchedid IN NUMBER
)
IS
BEGIN

OPEN SBCursor FOR
select SB.*,rownum from
(
SELECT col1,colu2 from table ) SB;

End;

Actually i don't know how to close the cursor please help me to close the cursor for above procedure.

-Thanx.

Re: Instance Efficiency [message #265866 is a reply to message #265817] Fri, 07 September 2007 12:51 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
OPEN SBCursor;
loop
FETCH  SBCursor into sb_cursor;
EXIT when SBCursor%NOTFOUND;

YOUR CODE

END LOOP;
CLOSE SBCursor;
Re: Instance Efficiency [message #265870 is a reply to message #265824] Fri, 07 September 2007 13:02 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I said:
Quote:
They have to not close the cursor they execute multiple times.

You answer:
Quote:
please help me to close the cursor for following sample procedure

Don't you understand what I wrote?

In addition, this is the subject of another topic, don't use a topic to get answer for another one. Read the guide, this is clearly stated.

Regards
Michel
Previous Topic: Procedure Tuning
Next Topic: How can we get statistics on a table being used 24/7 in a database
Goto Forum:
  


Current Time: Sat Dec 03 20:29:36 CST 2016

Total time taken to generate the page: 0.13361 seconds