Performance analysis using TOAD. ORA-02030

From: Ron Mooij <Ron.Mooij_at_gironet.nl>
Date: Tue, 02 Jun 1998 22:41:42 +0200
Message-ID: <35746386.3DF9F7B9@gironet.nl>

I found a great <FREEWARE> tool for Oracle Developers at Tool for Oracle Application Developers - SQL - TOAD

I do have a small problem however.

In order to use the Sql Trace/optimizaton i need to issue the following grants

  grant select on v$sysstat  to public;
  grant select on v$system_event   to public;
  grant select on v$librarycache to public;
  grant select on v$STATNAME to public;

(According to TOAD's help file)

When I run these grants under SYS i get "ORA-02030: can only select from fixed tables/views"

Can anyone help me?
I'm running personal Oracle 7.3.3.0.0 on Windows 95.

Ron Mooij Received on Tue Jun 02 1998 - 15:41:42 CDT