Database Tuning (MOSC)

MOSC Banner

help in the what need to do in this sql problem

edited Dec 16, 2020 5:43AM in Database Tuning (MOSC) 2 commentsAnswered
  Investigate application logic involving I/O on TABLE SUBPARTITION
      "MYRPPADMIN.PAYMENTINTERCHANGE.SYS_SUBP2731794" with object ID 4280431.
      Related Object
         Database object with ID 4280431.
   Rationale
      The I/O usage statistics for the object are: 0 full object scans, 158207
      physical reads, 0 physical writes and 0 direct reads.

   Recommendation 2: Segment Tuning
   Estimated benefit is .06 active sessions, 3.66% of total activity.
   ------------------------------------------------------------------
   Action
 

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