Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

My function in select statement taking time and have multiple entries in v$session

Uday_NJan 12 2021

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

This post has been answered by Billy Verreynne on Jan 12 2021
Jump to Answer

Comments

Post Details

Added on Jan 12 2021
4 comments
584 views