wait event : cursor: pin S wait on X

You could see high such waits in your database if you are using automatic memory management of the SGA ( the new feature in Oracle 10G )
Solution : Set manually  the memory components of the SGA's database .

see also http://www.nocoug.org/Journal/NoCOUG_Journal_201008.pdf