Cursor cache
Hello All,
DB :- 12.1.0.2
Is there a way to identify the user/session detail that executed a specific SQL ID where the SQL was executed through a EBS form. The query is in Cursor cache. I tried to find out the detail from v$session view with where condition for specific SQL_ID, but it showing now rows, then same way if I check either v$sql or v$sqlarea view, I could see the specific SQL_ID.
I want to now the session details for specific sql_id, Is there any way to find it out like join the query v$session and v$sql.? If anybody have the SQL query, please share it.