Re: Performance analysis using TOAD. ORA-02030

From: Mark A Greenhalgh <mark_greenhalgh_at_usa.net>
Date: Wed, 3 Jun 1998 10:49:55 -0400
Message-ID: <6l3nsd$1oi@news.idx.com>

V$* are just synonyms that point to v_$* views. You need to grant access to the views directly.
grant select on v_$sysstat to public;

Mark Greenhalgh
mag_at_removethispeice.gis.net

Ron Mooij wrote in message <35746386.3DF9F7B9_at_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 Wed Jun 03 1998 - 09:49:55 CDT