Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images
Bewarse Talk Discussion Board * Archives - 2016 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through March 23, 2016 * Sql help < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this 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:    Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

nee avesam k... ni kc...D...
telugu biDDa (staying in bangalore and from vijayawada)
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

hoo cheppada thupak...
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

15 mins interval ku koncham time isthe cheputha
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

select t_name, avg(value), timestamp from ...... group by t_name, timestamp
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

ayte lepeyna :-O
telugu biDDa (staying in bangalore and from vijayawada)
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

dobbey cheppadu , please ignore this thread for now
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

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

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration