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 -> v$sqlarea doesn't show full query

v$sqlarea doesn't show full query

From: Steve Robin <ocmaman_at_gmail.com>
Date: 5 Feb 2007 23:09:56 -0800
Message-ID: <1170745796.414380.122790@v33g2000cwv.googlegroups.com> 





I saw one query doing huge physical reads. But it is not complete as
it has more characters then 1000. Now I need to tune that but I don't
have full query, only first 999 characters. We DBAs cann't contact
developers for this query. it is internally query by the software they
are using.  Is it possible to get full query from database.



Oracle Version : 9.2.0.8


Platform : Windows XP
Received on Tue Feb 06 2007 - 01:09:56 CST












Original text of this message













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