Last week I had to analyze a strange performance problem. Since the cause/solution was somehow surprising, at least for me, I thought to share it with you.
Let me start by quickly describing the setup and what was done to reproduce the problem:
Database version: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 (64-bit)
Operating system: Solaris 10 (SPARC)