Oracle interview question

Current project system design Producer consumer problem