Re: Views

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;