Grosse mise à jour : - style moderne des tableaux et code - code structuré et factorisé - sql et sh affinés
9 lines
204 B
SQL
9 lines
204 B
SQL
prompt <h2>SYSAUX Occupants</h2>
|
|
|
|
select /* db-html-report */ /*+ NO_MERGE */
|
|
V.*,
|
|
ROUND(V.SPACE_USAGE_KBYTES / POWER(10, 6), 3) SPACE_USAGE_GBS
|
|
FROM
|
|
V$SYSAUX_OCCUPANTS V
|
|
ORDER BY
|
|
1; |