Re: v$sqlarea doesn't show full query

On Feb 6, 12:09 pm, "Steve Robin" <ocma..._at_gmail.com> wrote:
> 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

hi
this is vinit garchar from gujarat
and plz help me on my folling problem

in oracle report 6i how we can use %
means i suppose in one table there r 50 records now i want to use % in parameter means suppose 80% then i can saw 80% records out of 50 record

if possible then help me
my addrees is above
waiting 4 ur goood responce

---vinit Received on Tue Feb 06 2007 - 05:03:29 CST