Re: Memory Issue
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 23 Dec 2020 17:58:49 +0300
Message-ID: <CAOVevU5KmvoB--Og6+54XdMput6SSjOTE2Uso4gp5WN4JWONSA_at_mail.gmail.com>
Date: Wed, 23 Dec 2020 17:58:49 +0300
Message-ID: <CAOVevU5KmvoB--Og6+54XdMput6SSjOTE2Uso4gp5WN4JWONSA_at_mail.gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 23 2020 - 15:58:49 CET