4e7683aee2
Grosse mise à jour : - style moderne des tableaux et code - code structuré et factorisé - sql et sh affinés
41 lines
725 B
SQL
41 lines
725 B
SQL
prompt <h2>Sessions Aggregate per Module and Action</h2>
|
|
|
|
WITH X AS (
|
|
select /* db-html-report */
|
|
COUNT(*),
|
|
--con_id,
|
|
MODULE,
|
|
ACTION,
|
|
INST_ID,
|
|
TYPE,
|
|
SERVER,
|
|
STATUS,
|
|
STATE
|
|
FROM
|
|
GV$SESSION
|
|
GROUP BY
|
|
--con_id,
|
|
MODULE,
|
|
ACTION,
|
|
INST_ID,
|
|
TYPE,
|
|
SERVER,
|
|
STATUS,
|
|
STATE
|
|
)
|
|
SELECT
|
|
X.*
|
|
--,c.name con_name
|
|
FROM
|
|
X
|
|
--LEFT OUTER JOIN v$containers c ON c.con_id = x.con_id
|
|
ORDER BY
|
|
1 DESC,
|
|
--x.con_id,
|
|
X.MODULE,
|
|
X.ACTION,
|
|
X.INST_ID,
|
|
X.TYPE,
|
|
X.SERVER,
|
|
X.STATUS,
|
|
X.STATE; |