I've got you exported ASH. Btw, it would be much easier if you use pastebin
or gist.github to post such data and just provide links to the files.
To be honest the only interesting thing I see in your ASH data is "V8
Describe Any" in "Top level call name", which should be OCIDescribeAny().
Also only 716 rows from total 3146 were in "waiting", all other 2430 snaps
(~80%) were "On CPU". So I would start with snapping session call stack, at
least 30-40 "oradebug short_stack".
From those 716 rows, 715 were "library cache: mutex X" and one "latch: row
cache objects"
And 132 rows with Blocking session status=valid with blocking
sid=808,serial=37715.
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org
