same repeated in statspack
From: Purav Chovatia <puravc_at_gmail.com>
Date: Thu, 12 Apr 2018 00:38:33 +0530
Message-ID: <CADrzpjFfO9nUp0sv8YcTyxp==CjrE2oVvWR4_n4R5Z-Tpo-6cw_at_mail.gmail.com>
Hello,
Date: Thu, 12 Apr 2018 00:38:33 +0530
Message-ID: <CADrzpjFfO9nUp0sv8YcTyxp==CjrE2oVvWR4_n4R5Z-Tpo-6cw_at_mail.gmail.com>
Hello,
On a 12.1.0.2 2-node RAC database running on RHEL, statspack report for some snaps is showing the same sql_id (with same old hash value) twice. Report data for the hour previous to the previous hour seems to be getting reported alongwith data for current hour.
For e.g. data for 1am-2am is repeated in 2am-3am.
Has anybody encountered this?
Thanks,
Purav
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 11 2018 - 21:08:33 CEST