RE: RE: to much time to execute query
Hi Sony ! Thanks ! guess i missed out the join. & no it did'nt damage my brain . ;) Regards Tc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Re: to much time to execute query
> >Thanx Jared. That query waz pretty fast (0.78 >secs). Next time i wuld avoid using nested queries >where joins can do the job. > >regards >Tc > Wrong conclusion. Jared gave you the best and simplest solution, but Sony implicitly pointed to your error. Missing join condition. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: to much time to execute query
Thanx Jared. That query waz pretty fast (0.78 secs). Next time i wuld avoid using nested queries where joins can do the job. regards Tc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: to much time to execute query
Hi damage brain, What about this, select sum(value)/1024||' KB' as Kilo,b.name from v$sesstat a,v$statname b where a.statistic# in (select b.statistic# from v$statname where b.name like '% uga %') anda.statistic# = b.statistic# group by b.name wish it is not damage your brain. Rgrds, Sony > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 7:09 AM > To: Multiple recipients of list ORACLE-L > Subject: to much time to execute query > > Hello list, > > This query is taking to much time (26 secs). What can be the problem ? Is > the query not written properly ? All other queries involving v$sesstat amd > v$statname do not take this much time. > > ---> > select sum(value)/1024||' KB' as Kilo,b.name from v$sesstat a,v$statname b > where a.statistic# in (select b.statistic# from v$statname where b.name > like '% uga %') group by b.name; > > > TIA > > Tc > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: to much time to execute query
try: select sum(value)/1024||' KB' as Kilo,b.name from v$sesstat a,v$statname b where b.name like '% uga %' and a.statistic# = b.statistic# group by b.name / [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/28/2003 04:09 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:to much time to execute query Hello list, This query is taking to much time (26 secs). What can be the problem ? Is the query not written properly ? All other queries involving v$sesstat amd v$statname do not take this much time. ---> select sum(value)/1024||' KB' as Kilo,b.name from v$sesstat a,v$statname b where a.statistic# in (select b.statistic# from v$statname where b.name like '% uga %') group by b.name; TIA Tc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
