Solution : https://service.sap.com/sap/support/notes/1121838 (SAP Service marketplace login required)
Key words :
Oracle 10.2.0.2, select, shrink compact, row chache lock
Related Notes :
| 910389 | FAQ: Oracle Segment Shrinking |
| 871096 | Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.2 |
| 619188 | FAQ: Oracle wait events |