© Kim Berg Hansen 2020
K. Berg HansenPractical Oracle SQLhttps://doi.org/10.1007/978-1-4842-5617-6_20

20. Finding Abnormal Peaks

Kim Berg Hansen1 
(1)
Middelfart, Denmark
 

In many cases there’s sequential data (often chronological) that’s supposed to have a fairly steady value or increasing/decreasing at a fairly steady rate. If there are spots in the data where it is not fairly steady, you want to know about it. Or in other words, if you graphically represent the data, you want to find the abnormal peaks and spikes.

As a database professional, an obvious case of this situation is tablespace storage usage. Normally the number of GBs grows approximately the same rate each day/week/month – any excessive growth rate is indicative of an abnormal workload, ...

Get Practical Oracle SQL: Mastering the Full Power of Oracle Database now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.