dbTalk Databases Forums  

Views

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc Views

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Views in the comp.databases.oracle.misc forum.



Reply
Page 3 of 3 < 1 2 3
 
Thread Tools Display Modes
  #21  
Old   
Shakespeare
 
Posts: n/a

Default Re: Views - 06-17-2008 , 03:30 AM






"Mtek" <mtek (AT) mtekusa (DOT) com> schreef in bericht
news:e0615271-0363-4abf-89cf-5b67cb8946a2 (AT) m3g2000hsc (DOT) googlegroups.com...
Quote:
On Jun 13, 2:35 pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote:
On Jun 13, 11:37 am, Mtek <m... (AT) mtekusa (DOT) com> wrote:



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 -

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




Reply With Quote
  #22  
Old   
Mtek
 
Posts: n/a

Default Re: Views - 06-17-2008 , 07:40 AM





On Jun 17, 3:30 am, "Shakespeare" <what... (AT) xs4all (DOT) nl> wrote:
Quote:
"Mtek" <m... (AT) mtekusa (DOT) com> schreef in berichtnews:e0615271-0363-4abf-89cf-5b67cb8946a2 (AT) m3g2000hsc (DOT) googlegroups.com...



On Jun 13, 2:35 pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote:
On Jun 13, 11:37 am, Mtek <m... (AT) mtekusa (DOT) com> wrote:

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 -

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

You're smart guy......thanks a bunch!!!



Reply With Quote
  #23  
Old   
Mtek
 
Posts: n/a

Default Re: Views - 06-17-2008 , 07:40 AM


On Jun 17, 3:30 am, "Shakespeare" <what... (AT) xs4all (DOT) nl> wrote:
Quote:
"Mtek" <m... (AT) mtekusa (DOT) com> schreef in berichtnews:e0615271-0363-4abf-89cf-5b67cb8946a2 (AT) m3g2000hsc (DOT) googlegroups.com...



On Jun 13, 2:35 pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote:
On Jun 13, 11:37 am, Mtek <m... (AT) mtekusa (DOT) com> wrote:

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 -

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

You're smart guy......thanks a bunch!!!



Reply With Quote
  #24  
Old   
Mtek
 
Posts: n/a

Default Re: Views - 06-17-2008 , 07:40 AM


On Jun 17, 3:30 am, "Shakespeare" <what... (AT) xs4all (DOT) nl> wrote:
Quote:
"Mtek" <m... (AT) mtekusa (DOT) com> schreef in berichtnews:e0615271-0363-4abf-89cf-5b67cb8946a2 (AT) m3g2000hsc (DOT) googlegroups.com...



On Jun 13, 2:35 pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote:
On Jun 13, 11:37 am, Mtek <m... (AT) mtekusa (DOT) com> wrote:

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 -

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

You're smart guy......thanks a bunch!!!



Reply With Quote
  #25  
Old   
Mtek
 
Posts: n/a

Default Re: Views - 06-17-2008 , 07:40 AM


On Jun 17, 3:30 am, "Shakespeare" <what... (AT) xs4all (DOT) nl> wrote:
Quote:
"Mtek" <m... (AT) mtekusa (DOT) com> schreef in berichtnews:e0615271-0363-4abf-89cf-5b67cb8946a2 (AT) m3g2000hsc (DOT) googlegroups.com...



On Jun 13, 2:35 pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote:
On Jun 13, 11:37 am, Mtek <m... (AT) mtekusa (DOT) com> wrote:

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 -

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

You're smart guy......thanks a bunch!!!



Reply With Quote
Reply
Page 3 of 3 < 1 2 3

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top