High value on CPU and ELAPSED time

 Hi All,

Can somebody help me to analyse this tkprof file, i mean what is wrong in our database? This program caused ERROR ORA-01555 in our LIVE system. If i run the query on TOAD using same paramater as in input parameter, it delivers data below one minute.....or if i run the program under our TEST or UAT system, the program is running well.

The table access from tkprof plan table and toad is similar.

Thank you in advance.

SELECT MSI.SEGMENT1 ITEM ,MC.SEGMENT5 MODEL ,DECODE(MSI.ATTRIBUTE2 , 'N',
  DECODE(SUBSTR(MSI.SEGMENT1, 1, 2) , 'RR', 'R' , 'RZ', 'R' , 'N') , 'N')