check for session wait event.. when you execute that proc for 5000 rows to process.