| Instance Efficiency [message #265817] |
Fri, 07 September 2007 08:26  |
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  |
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 |
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 |
 |
Michel Cadot
Messages: 68665
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
