Optimize sql with Full Table Scan

Hello,

Recently we are facing performance issues with the application, processes consuming 98% of CPU during peak hours. The AWR reports shows the sql consuming the resources, and it is going for full table scan.

SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS('PIE_P_SWT','SWT_DR_VOU_FILDET');

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS('PIE_P_SWT','SWT_DL_VOU_DEN');

PL/SQL procedure successfully completed.

SQL> EXPLAIN PLAN SET STATEMENT_ID = 'st1' FOR

  2  SELECT SERIAL_NO,

  3    PIN_NO,

  4    DENOMINTION,

  5    EXPIRY_DATE,

  6    STATUS_CODE,

  7    AUX_NO

  8  FROM PIE_P_SWT.SWT_DR_VOU_FILDET