Oracle SOA BPM Composite performance query

                     



             select cu.composite_name Composite, cu.component_name Process, cu.componenttype, cu.state, cu.ECID,co.title,cu.CREATION_DATE,cu.MODIFY_DATE,

          trunc((extract(day    from (cu.modify_date-cu.creation_date))*24*60*60 +

                extract(hour   from (cu.modify_date-cu.creation_date))*60*60 +

                extract(minute from (cu.modify_date-cu.creation_date))*60 +

                extract(second from (cu.modify_date-cu.creation_date))),4) responsetime from

                cube_instance cu, composite_instance co where  cu.ECID=co.ECID and cu.COMPOSITE_NAME='xxx' and

          cu.creation_date >= to_timestamp('2014-11-20 00:00:00','YYYY-MM-DD HH24:MI:SS')

          and cu.creation_date <= to_timestamp('2014-12-01 00:00:00','YYYY-MM-DD HH24:MI:SS') and co.title Is NOT NULL

          order by responsetime desc;