SELECT distinct a.usr_key, a.actiondate
FROM aging_tracking a  
WHERE a.actiondate =
  (SELECT MAX(actiondate)
  FROM aging_tracking b
  WHERE b.usr_key = a.usr_key
  AND b.status    = 'P'
  )
AND a.actiondate BETWEEN sysdate AND sysdate +30

SELECT usr_key, actiondate
FROM
(SELECT usr_key, actiondate, row_number() OVER(partition by usr_key ORDER BY usr_key DESC) a
FROM aging_tracking
WHERE actiondate BETWEEN sysdate AND (sysdate+30)
AND status    = 'P') b
WHERE  A=1

SELECT DISTINCT
       a.usr_key'
      ,a.actiondate
FROM   aging_tracking a  
WHERE  a.actiondate = (SELECT MAX(actiondate)
                       FROM   aging_tracking b
                       WHERE  b.usr_key = a.usr_key
                       AND    b.status  = 'P'
                      )
AND    a.actiondate BETWEEN SYSDATE AND SYSDATE + 30

CREATE INDEX aging_tracking_nu_i ON aging_tracking
  ( actiondate
   ,usr_key
   ,status)
TABLSPACE ???;