SQL Performance (MOSC)

MOSC Banner

Cursor cache

edited Jun 22, 2020 8:30AM in SQL Performance (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center