Re: need help on statspack report, Parse CPU to Parse Elapsd %

From: Joe <yung103_at_netvigator.com>
Date: Tue, 9 Mar 2004 21:41:43 +0800
Message-ID: <c2khir$3v123@imsp212.netvigator.com>

Srivenu,

thanks a lots

Joe

"srivenu" <srivenu_at_hotmail.com> ???
news:1a68177.0403072237.7c720258_at_posting.google.com ???...
> Joe,
> This SQL can help you find out the Enqueue for which most waits have
happended.
> SELECT ksqsttyp "Lock",
> ksqstget "Gets",
> ksqstwat "Waits"
> FROM X$KSQST
> where KSQSTWAT>0
> order by 3
>
> regards
> Srivenu
Received on Tue Mar 09 2004 - 07:41:43 CST

This message: [ Message body ]
Next message: Carsten Meiselbach: "Access denied on loading DLLs with PHP 4.3.4, Oracle 9i and IIS 5"
Previous message: Toby Brown: "SQL Trace Output - Query vs Disk - Are they mutually exclisive?"
In reply to: srivenu: "Re: need help on statspack report, Parse CPU to Parse Elapsd %"
Next in thread: VC: "Re: need help on statspack report, Parse CPU to Parse Elapsd %"
Reply: VC: "Re: need help on statspack report, Parse CPU to Parse Elapsd %"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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