| Author |
Message |
    
Stewie
Kurra Bewarse
Username: Stewie
Post Number: 3885
Registered: 03-2011
Posted From: 104.245.210.36
| | 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.
|
Prasanth
Censor Bewarse
Username: Prasanth
Post Number: 77047
Registered: 03-2004
Posted From: 59.144.58.33
| | Posted on Monday, March 21, 2016 - 5:16 pm: |
|
nee avesam k... ni kc...D...
telugu biDDa (staying in bangalore and from vijayawada)
|
Proofdada
Bewarse Legend
Username: Proofdada
Post Number: 145901
Registered: 03-2004
Posted From: 71.170.93.71
| | Posted on Monday, March 21, 2016 - 5:13 pm: |
|
hoo cheppada thupak... |
Proofdada
Bewarse Legend
Username: Proofdada
Post Number: 145900
Registered: 03-2004
Posted From: 71.170.93.71
| | Posted on Monday, March 21, 2016 - 4:54 pm: |
|
15 mins interval ku koncham time isthe cheputha |
Proofdada
Bewarse Legend
Username: Proofdada
Post Number: 145899
Registered: 03-2004
Posted From: 71.170.93.71
| | Posted on Monday, March 21, 2016 - 4:54 pm: |
|
select t_name, avg(value), timestamp from ...... group by t_name, timestamp |
Prasanth
Censor Bewarse
Username: Prasanth
Post Number: 77046
Registered: 03-2004
Posted From: 59.144.58.33
| | Posted on Monday, March 21, 2016 - 4:44 pm: |
|
ayte lepeyna 
telugu biDDa (staying in bangalore and from vijayawada)
|
Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa
Post Number: 23493
Registered: 03-2008
Posted From: 204.14.239.75
| | Posted on Monday, March 21, 2016 - 4:42 pm: |
|
dobbey cheppadu , please ignore this thread for now |
Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa
Post Number: 23492
Registered: 03-2008
Posted From: 204.14.239.75
| | Posted on Monday, March 21, 2016 - 4:06 pm: |
|
select target_name, value, collection_timestamp 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') order by 3 desc;
paina query vundhi
this is returning all the results that I want
collection_timestamp - date column
basic gaa naaku value average kaavali every 15 minutes interval ki and also group by target_name....also eedhanna date ki value NULL iithe 0.0 kindha thesukovali
output should be something like
TARGET_NAME AVG(VALUE) ROUND(COLLECT_TS)
abc123 1.1 2016-18-03 12:00
xyz234 1.4 2016-18-03 12:00
abc123 2.1 2016-18-03 12:15
xyz234 3.4 2016-18-03 12:15 |
Archives - 2016