Return
-
Title
Unable to get Oracle Server process id for session -
Description
When trying to setup a trace in SQL Tuning, then pressing 'Validate', the following message appears:
'Unable to get Oracle Server process id for session' -
Cause
This can happen depending on which views the database user has access to.
-
Resolution
Ensure the user has access to 'V$PROCESS'
as well as V$STATNAME, V$SESSTAT, V$SESSION