same repeated in statspack

From: Purav Chovatia <>
Date: Thu, 12 Apr 2018 00:38:33 +0530
Message-ID: <>


On a 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?


Received on Wed Apr 11 2018 - 21:08:33 CEST

Original text of this message