4e7683aee2
Grosse mise à jour : - style moderne des tableaux et code - code structuré et factorisé - sql et sh affinés
11 lines
276 B
SQL
11 lines
276 B
SQL
prompt <h2>Dictionary Stats / Fixed Objects Stats</h2>
|
|
|
|
select /* db-html-report */
|
|
TO_CHAR(MAX(END_TIME), 'dd/mm/yyyy hh24:mi') LATEST,
|
|
OPERATION
|
|
FROM
|
|
DBA_OPTSTAT_OPERATIONS
|
|
WHERE
|
|
OPERATION IN ('gather_dictionary_stats', 'gather_fixed_objects_stats')
|
|
GROUP BY
|
|
OPERATION; |