Instance Efficiency [message #265817] |
Fri, 07 September 2007 08:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #265824 is a reply to message #265821] |
Fri, 07 September 2007 09:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 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
|
|
|