Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: database slow

Re: database slow

From: Kumar <n_kselva_at_yahoo.com>
Date: 28 Nov 2004 07:45:40 -0800
Message-ID: <81bd9cbe.0411280745.50546d2e@posting.google.com> 





Hi Kenneth and Howard,



Thanks very much for your valuable tips and time. I have one more
question.



How do i find the text of a top sql text. I checked the v$sqlarea
(sql_text varchar2(1000) ) and hence the query being cut.or v$sql_text
varchar2(64).


i picked this query from statspack.



thanks.



Regards,


Kumar.
Received on Sun Nov 28 2004 - 09:45:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US