Re: database slow

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 28 Nov 2004 17:02:29 +0100
Message-ID: <41a9f6ad$0$8669$636a15ce@news.free.fr>

"Kumar" <n_kselva_at_yahoo.com> a écrit dans le message de news:81bd9cbe.0411280745.50546d2e_at_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.

In v$sql_text, query is cut in pieces of 64 characters. So you get all the query text if you take all the pieces.

-- 
Regards
Michel Cadot

Received on Sun Nov 28 2004 - 10:02:29 CST