Cannot See Traceid
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Cannot See Traceid

  1. #1
    Join Date
    Jan 2007
    Posts
    5

    Cannot See Traceid

    Hello,
    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 ?

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    You could create a view against the TRACEID column in V$PROCESS and grant privileges to PUBLIC or just reset the TRACEFILE_IDENTIFIER.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width