long running queries

[Former Member]

Hi All

I want to write a query which could provide the top 25 queries which are taking long time based on input parameter(day/month). If i input the day, it should give the particular day related top10 queries taking lnog time. if i query the month, top 10 queries which have taken long time, in that particular month.

I have build the query with the following fields

1. Queryname, infoprovider name, date/time, Timetaken

and i have taken the condition on time taken, TOP N.

Now the output is as follows

Query InfoproviderName date time

Q0010 xxxxx 01.01.2008 13567

25.01.2008 1000

01.02.2008 900

Q0002 yyyyy

[Former Member]

solved

[Former Member]

I want to write a query which could provide the top 25 queries which are taking long time based on input parameter(day/month). If i input the day, it should give the particular day related top10 queries taking lnog time. if i query the month, top 10 queries which have taken long time, in that particular month.

I have build the query with the following fields

1. Queryname, infoprovider name, date/time, Timetaken

and i have taken the condition on time taken, TOP N.

Now the output is as follows

Query InfoproviderName date time

Q0010 xxxxx 01.01.2008 13567

25.01.2008 1000

01.02.2008 900

Q0002 yyyyy 01.01.2008 500

xxxxdate 300

Q0005 zzzzz dates xxxxx

I want the output in the below way

Q0010 xxxxx 01012008 13567

Q0010 xxxxx 25012008 1000

Q0010 yyyy 01022008 900

q0002

etc etc

for each query, its giving top10 timing.

Instaed i want top 10 queries

how can i achieve this

regards

[shanthi_bhaskar]

yo u can make use of RSDDSTAT table for ur reference

[Former Member]

i am presntly using statis cube c10