Re: Views

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 17 Jun 2008 10:30:31 +0200
Message-ID: <4857762c$0$14345$e4fe514c@news.xs4all.nl>

"Mtek" <mtek_at_mtekusa.com> schreef in bericht news:e0615271-0363-4abf-89cf-5b67cb8946a2_at_m3g2000hsc.googlegroups.com...

> On Jun 13, 2:35 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:

>> On Jun 13, 11:37 am, Mtek <m..._at_mtekusa.com> wrote:
>>
>>
>>
>> > On Jun 13, 11:25 am, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>>
>> > > On Jun 13, 9:46 am, Mtek <m..._at_mtekusa.com> wrote:
>>
>> > > > Hi,
>>
>> > > > We use TOAD as our GUI to see the database. I put in a query that
>> > > > selects from V$SQL, but I get a missing expression. The same query
>> > > > works from within SQLPLUS. Even it I change it to V_$SQL, no
>> > > > good.
>>
>> > > > Is there something special with these dictionary tables???
>>
>> > > > Thanks!
>>
>> > > > John
>>
>> > > Without seeing your query no one can answer that.
>>
>> > > Post it.
>>
>> > > David Fitzjarrell
>>
>> > select a.USERNAME,
>> > DISK_READS,
>> > EXECUTIONS,
>> > round(DISK_READS / decode(EXECUTIONS, 0, 1, EXECUTIONS))
>> > "Reads/
>> > Execs",
>> > SQL_TEXT
>> > from dba_users a, v$session, v$sqlarea
>> > where PARSING_USER_ID=USER_ID
>> > and ADDRESS=SQL_ADDRESS(+)
>> > and DISK_READS > 10000
>> > order by DISK_READS desc, EXECUTIONS desc;- Hide quoted text -
>>
>> > - Show quoted text -
>>
>> Now post the exact error displayed.
>>
>> David Fitzjarrell

>
> A query like this give a "Missing Expression" from TOAD, but works
> fine from SQLPLUS:
>
> select EXECUTIONS,
> BUFFER_GETS,
> round(DISK_READS / decode(EXECUTIONS, 0, 1, EXECUTIONS) / 400,2)
> "Gets/Execs",
> SQL_TEXT
> from sys.v_$sqlarea
> where  BUFFER_GETS / decode(EXECUTIONS,0,1, EXECUTIONS) / 400 > 10
> order  by EXECUTIONS desc;
>
> John
>

Try to replace "Gets/Execs" with get_execs (no '/', no quotes) Looks like a TOAD problem. PL/SQL Developer runs this query just fine.

Shakespeare Received on Tue Jun 17 2008 - 03:30:31 CDT