Re: Memory Issue

From: Sayan Malakshinov <>
Date: Wed, 23 Dec 2020 17:58:49 +0300
Message-ID: <>

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

Received on Wed Dec 23 2020 - 15:58:49 CET

Original text of this message