20 lines
294 B
SQL
20 lines
294 B
SQL
SELECT * FROM (
|
|
SELECT
|
|
dsc.kcbwhdes,
|
|
sw.why0,
|
|
sw.why1,
|
|
sw.why2,
|
|
sw.other_wait
|
|
FROM
|
|
x$kcbwh dsc,
|
|
x$kcbsw sw
|
|
WHERE
|
|
dsc.indx = sw.indx
|
|
AND sw.why0 + sw.why1 + sw.why2 + sw.other_wait > 0
|
|
ORDER by
|
|
-- dsc.kcbwhdes
|
|
sw.why0 + sw.why1 + sw.why2 ASC
|
|
)
|
|
--WHERE rownum <= 10
|
|
/
|