Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database slow
n_kselva_at_yahoo.com (Kumar) wrote in message 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.
It is a good idea to learn how to do all these things from the command line. But for actual quick information, don't forget about OEM. You can see what it does, too.
jg
-- @home.com is bogus. Naw, I don't think things are better: http://www.signonsandiego.com/news/nation/terror/20041130-1628-bush-cabinet.htmlReceived on Tue Nov 30 2004 - 19:45:54 CST