DB Query Issue

Hi,

We are facing issue in our database. Last few days the DB time was shown in higher percentage:

Instance 1:

Snap Id      Snap Time      Sessions Curs/Sess

            --------- ------------------- -------- ---------

Begin Snap:     16839 10-Jan-12 16:29:29       602       1.1

  End Snap:     16840 10-Jan-12 17:28:55       602       1.1

   Elapsed:               59.44 (mins)

   DB Time:               39.36 (mins)

Instance 2:

              Snap Id      Snap Time      Sessions Curs/Sess

            --------- ------------------- -------- ---------

Begin Snap:     16839 10-Jan-12 16:30:51       597       1.1

  End Snap:     16840 10-Jan-12 17:30:17       598       1.1

   Elapsed:               59.44 (mins)

   DB Time:               40.91 (mins)

I suspect the below query is one of the root cause of the issue.

PROCEDURE SP_GET_BILLING_INFO2

(

i_AREA_CODE                                           IN   VARCHAR2,

i_CLI                                                 IN   VARCHAR2,

i_ACC_NBR                               IN   NUMBER,

i_CIRCLE_ID                             IN   VARCHAR2,