I connect as TEST user in Oracle 10g.I can alter the session and set the TRACEFILE_IDENTIFIER='GOOD'.
But I cannot acces the V$ process from the user to see the TraceID.It says " Table or view does not exist".
I connect as SYS and can acess V$process but the SYS user does not show the TRACEID of TEST user.
I tried granting select on V$process from SYS account to TEST user.But says " can grant only on fixed tables/views"
Any idea on how to see the TRACEID ?