Billing and Revenue Management (MOSC)

MOSC Banner

Old Partitions are beeing accessed while Running GL Report

edited Feb 12, 2020 2:36AM in Billing and Revenue Management (MOSC) 3 commentsAnswered

Hi,

We have executed the monthly GL report from 27-DEC-2019 til 27-JAN-2020.

This report took around 16 hours for completion.

While analyzing for root cause we have fetched the AWR report (PFB) and it indicates that queries taking long time while accesing partition of July2019.

Here the question arises, that why this Partition is being accessed at all as the GL report period does not include that period.

****************************************** Snippet  from AWR report ******************************************

Segments by Physical Reads

  • Total Physical Reads: 1,508,588,938
  • Captured Segments account for 92.5% of Total
  • When ** MISSING ** occurs, some of the object attributes may not be available
OwnerTablespace NameObject Name

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center