26 lines
548 B
SQL
26 lines
548 B
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
SELECT * FROM (
|
|
SELECT
|
|
dsc.kcbwhdes,
|
|
why.why0,
|
|
why.why1,
|
|
why.why2,
|
|
sw.other_wait
|
|
FROM
|
|
x$kcbuwhy why,
|
|
x$kcbwh dsc,
|
|
x$kcbsw sw
|
|
WHERE
|
|
why.indx = dsc.indx
|
|
AND why.why0 + why.why1 + why.why2 + sw.other_wait > 0
|
|
AND dsc.indx = sw.indx
|
|
AND why.indx = sw.indx
|
|
ORDER by
|
|
-- dsc.kcbwhdes
|
|
why.why0 + why.why1 + why.why2 ASC
|
|
)
|
|
--WHERE rownum <= 10
|
|
/
|