Hi Jonathan ,
Thanks for your mail, I understand the above points , and will try to
drive in a similar direction as you have mentioned .
Regards,
Krishna
On Mon, 4 Oct 2021 at 16:13, Krishnaprasad Yadav <chrishna0007@xxxxxxxxx>
wrote:
Hi Jonathan,
Its 2 node rac system , and only one instance is running and the other
one is down .
Regards,
Krishna
On Mon, 4 Oct 2021 at 15:18, Jonathan Lewis <jlewisoracle@xxxxxxxxx>
wrote:
GES is the global enqueue service (which isn't about buffer cache), so it
looks as if you are doing something that requires coordination of some
locking event. (And the code path is followed regardless of how many
instances are up.)
I would take a couple of snapshots of v$enqueue_stat over a short period
of time to see if any specific enqueue is being acquired very frequently;
but some global enqueue gets don't get recorded in that view - so it may
show nothing interesting. And I would do the same (snapshots) of v$rowcache
to see if any if the dictionary cache objects were subject to a high rate
of access. EIther of these might give you some clue about what's going on.
Historic issues:
sequences being accessed very frequently and declared with NOCACHE (or
very small CACHE) or with ORDER.
Some bugs relating to tablespace handling, undo handling, VPD, the result
in massive overload on dc_tablespaces, dc_users, dc_objects,
dc_rollback_segments (though I can't remember if any of them were still
around in 12.2).
Regards
Jonathan Lewis
On Mon, 4 Oct 2021 at 10:23, Krishnaprasad Yadav <chrishna0007@xxxxxxxxx>
wrote:
Hi Experts ,
There is a situation around which is causing an event : latch: ges
resource hash list in database . CRS /RDBMS is 12c2 version on solaris
DB is 2 node RAC , but due to application compatibility node 2 always
remains down. however on node 1 we lot of query waiting for latch : ges
resource hash list ,(no specific query is ,but all )
on node 2 ,the complete CRS stack is down , not sure why this event is
popping up on node1 .
Parallely CPU for node 1 also remains higher more than 80% most of the
time .
Any light about this event will be helpful .
Regards,
Krishna
