Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Stewie Kurra Bewarse Username: Stewie Post Number: 3885 Registered: 03-2011 Posted From: 104.245.210.36 Rating: N/A Votes: 0 Posted on Monday, March 21, 2016 - 5:21 pm:    SELECT target_name, TRUNC (collection_timestamp, 'hh24') + (TRUNC (TO_CHAR (collection_timestamp, 'mi') / 15) * 15) / 24 / 60 FROM mgmt$metric_details WHERE collection_timestamp > SYSDATE - 1 AND metric_label = 'Load' AND column_label LIKE 'CPU in User Mode%' AND REGEXP_LIKE (target_name, '^abc|^xyz|^lmn|^opq|^viv') group by target_name, TRUNC (collection_timestamp, 'hh24') + (TRUNC (TO_CHAR (collection_timestamp, 'mi') / 15) * 15) / 24 / 60 ORDER BY 3 DESC; A Famous Quote starts with a... and ends with this.