Re: Performance analysis using TOAD. ORA-02030

i think u dont have the DBA role granted to your user.....i was getting the same message and then i granted my user the DBA role and all was fine...i havent had time to find out which specific privilege does the trick!

Umar Farooq

Ron Mooij wrote:

>
>
> 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 - 00:44:58 CDT