Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    6

    Unanswered: problem with TKPROF UTILITY-

    HI friends,
    I have a problem using the TKPROF UTILITY.
    this is what I get on running the plustrce.sql.
    SQL> @d:/oracle/sqlplus/admin//plustrce.sql; @d:/oracle/rdbms/admin/plustrce.sql;

    SQL> grant select on v_$sesstat to plustrace;
    grant select on v_$sesstat to plustrace
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist


    SQL> grant select on v_$statname to plustrace;
    grant select on v_$statname to plustrace
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist


    grant select on v_$session to plustrace
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    How do i get rid of this. Can any one help!!!!!!!!!.
    Thanks,
    Avinash

  2. #2
    Join Date
    Jun 2002
    Location
    Indianapolis
    Posts
    21
    Make sure that you are logged in as sys.

Posting Permissions

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