I must say this is a "best asked" question on this forum in quite some time. Good info to start with, details made available as and when needed. All responses have been equally sane, no humor, no jabs, no nothing...Good work Guy !! You are anyway a manager. I propose making you a Sr. Manager.

Question about the statspack snapshot : The one you have posted reflects pure OLTP activity or does it cover a time space when you were doing some of you maintenance tasks ?

Just last week I went though this for our OLTP system. System was as good as dead. "Log file sync" wait had shot through the roof. Rediculous "change write time" stats. And there was absolutely NOTHING unusual going on in the syatem. No app changes, no process changes, nothing...

After coule of days it all boiled down to a loose cable that connected our SAN disks and fiber switches and servers and what not...Point is there can be something hiding under that waut event.