Slow Response In Query

Hi,

I am running a scheduled task in AIX environment. The scheduled task takes the text file and insert the data temporary table using SQL loader.

At end of the process we have rename the temp table into production table name. Index will be renamed.

After renaming the table I am getting slow response in query.

I have attached my SP with this post.

Looking for experts command why the query get slow response after renaming the table:

PROCEDURE:
----------------------

CREATE OR REPLACE procedure SP_INDUMP_PROCESS as
 getCount1   NUMBER(10):=0;
 getCount2   NUMBER(10):=0;
 strSQL      VARCHAR2(4000):='';
begin

  select Count(1) into getCount1 from GSM_PRE_IVR_IN_FCD_DTL;