It appears that every time i call a stored procedure , there is a parse =
on a call to the stored procedure .
I can see it in the output of TKPROF .
In the example below i called the procedure "update_usr_all" 11 times =
and the call to the procedure has been parsed=20
all the 11 times although the procedure is pinned into the shared_pool .

There is another problem that i'm facing .
Let's say that i call an SQL SELECT statement ( with bind variables) =
100 times .
It appears in TKPROF output file that there are 1 parse , 100 executions =
and 100 fetches for the statement .
But should there really be an execution for each SELECT call .