Loading...

Dynamic Oracle Performance Analytics by Roger Cornejo

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.
Popular ebooks
The Mikado Method by Ola Ellnestam Daniel Brolund(6722)
Sass and Compass in Action by Wynn Netherland Nathan Weizenbaum Chris Eppstein Brandon Mathis(5627)
Grails in Action by Glen Smith Peter Ledbrook(5276)
Management Strategies for the Cloud Revolution: How Cloud Computing Is Transforming Business and Why You Can't Afford to Be Left Behind by Charles Babcock(2983)
Kotlin in Action by Dmitry Jemerov(2344)
Learn Windows PowerShell in a Month of Lunches by Don Jones(1764)
MCSA Windows Server 2016 Study Guide: Exam 70-740 by William Panek(1575)
The Age of Surveillance Capitalism by Shoshana Zuboff(1529)
Blockchain Basics by Daniel Drescher(1524)
TCP IP by Todd Lammle(1505)
From CIA to APT: An Introduction to Cyber Security by Edward G. Amoroso & Matthew E. Amoroso(1497)
React Native - Building Mobile Apps with JavaScript by Novick Vladimir(1336)
Applied Network Security by Arthur Salmon & Michael McLafferty & Warun Levesque(1170)
The Art Of Deception by Kevin Mitnick(1166)
Owning Bitcoin: The Illustrated Guide to Security, Privacy, and Potential by Apodaca Richard(1138)
Serious Cryptography: A Practical Introduction to Modern Encryption by Aumasson Jean-Philippe(1079)
Wireless Hacking 101 by Karina Astudillo(1057)
Blockchain: Ultimate Step By Step Guide To Understanding Blockchain Technology, Bitcoin Creation, and the future of Money (Novice to Expert) by Keizer Söze(1049)
31 Days Before Your CompTIA A+ Exams (Shanette Luellen's Library) by Benjamin Patrick Conry(1047)
Networking A Beginner's Guide by Bruce Hallberg(1047)