Hi All,
I am calling a function for my select query . for one query it works fine but for another query similar function taking time . the query which takes time has additional two tables than the less time query but it doesn't related to the function . Another important information is when i run the function , it has multiples entries in my v$session . I am really sorry for not able to publish my code as code is very big .
Why a same function takes time for one query while it doesn't take time for another similar query . Also why it is having lot of entries in V$SESSION . Am i missing something here? Apart from code if you need any details please apprise me . I am really sorry as i thought sharing a sample code wont looks good so i didnt write my sample code .
Regards,
Udayasoorian