| || |
Identifying bottle neck
I have doubt..when i identify the process which slowdown the performance,can i find which SQL is creating problem.Like my clint wants to know in process, he has writen one PL/SQl which has many SQl statemnts like may insert,update,select
so he is aksing me to tell which SQL is slowing down.but is it possible,Can u clear my doubt.
Re: Identifying bottle neck
The easiest way would be to time each SQL statement. Start with statements with inner joins.