Concurrent Program waiting

Hi Everyone,

A program is running from last few hours, earlier its get completed in few minutes. Its showing running normal.

I checked with below Sql and found its showing waiting.

I also checked there is no lock for program.

select a.sid, a.serial#, b.sql_text

    from v$session a, v$sqlarea b

     where a.sql_address=b.address

      and a.sid = &sid

DBA's are saying its a code issue. However program was completed successfully before.

Kindly requesting you to advise if there is any way:

1. we can find out how much time program takes for completion.

2. Whether program is waiting for any other process.