 | |
#1
 
| |||
| |||
|
Views -
06-13-2008
, 09:46 AM
#2
| |||
| |||
|
|
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 |
Post it.
David Fitzjarrell
#3
| |||
| |||
|
|
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 |
Post it.
David Fitzjarrell
#4
| |||
| |||
|
|
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 |
Post it.
David Fitzjarrell
#5
| |||
| |||
|
|
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 |
Post it.
David Fitzjarrell
#6
| |||
| |||
|
|
On Jun 13, 9:46 am, Mtek <m... (AT) mtekusa (DOT) 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 |
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;
#7
| |||
| |||
|
|
On Jun 13, 9:46 am, Mtek <m... (AT) mtekusa (DOT) 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 |
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;
#8
| |||
| |||
|
|
On Jun 13, 9:46 am, Mtek <m... (AT) mtekusa (DOT) 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 |
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;
#9
| |||
| |||
|
|
On Jun 13, 9:46 am, Mtek <m... (AT) mtekusa (DOT) 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 |
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;
#10
| |||
| |||
|
|
On Jun 13, 11:25 am, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Jun 13, 9:46 am, Mtek <m... (AT) mtekusa (DOT) 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 - |
David Fitzjarrell
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.