http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID,F4950_P8_CRITERIA:1137834554916,{soft}%20and%20{parse}

basically sqlplus doesnt use cache cursors and causes soft parse everytime u execute the same query