Dynamic Oracle Performance Analytics by Roger Cornejo

Author:Roger Cornejo
Language: eng
Format: epub
ISBN: 9781484241370
Publisher: Apress

when upper(metric_name) like 'DB TIME' then 'cpu'

when upper(metric_name) like '%CPU%' then 'cpu'

-- ...

when upper(metric_name) like '%SQL*NET%' then 'network'

when upper(metric_name) like '%NETWORK%' then 'network'

-- ...

when upper(metric_name) like '%LIMIT%' then 'db'

when upper(metric_name) like '%ROLLBACKS%' then 'db'

-- ...

else 'any'

end as category

, case when stat_source = 'dba_hist_system_event' then 'wait'

when upper(metric_name) like '%WAIT%' then 'wait'

-- ...

when upper(metric_name) like '%READ%' then 'read'

-- ...

when upper(metric_name) like '%WRITE%' then 'write'

when upper(metric_name) like '%CHECKPOINT%' then 'write'

-- ...

when upper(metric_name) like '%PARSE%' then 'parse'

-- ...

when upper(metric_name) like '%CURSORS%' then 'cursors'

-- ...

when upper(metric_name) like '%REDO%' then 'recovery'

when upper(metric_name) like '%UNDO%' then 'recovery'

-- ...

when upper(metric_name) like '%PARALLEL%' then 'parallel'

when upper(metric_name) like '%PX%' then 'parallel'

-- ...

when upper(metric_name) like '%ENQUEUE%' then 'concurrency'

when upper(metric_name) like '%CONCURRENCY%' then 'concurrency'

-- ...

else 'any'

end as sub_category

from (select distinct stat_source, metric_name from metrics )

/* "metrics" is the set of all normalized metrics */

-- ...

union ALL

-- ...

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.