Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

AWR report performance tuning

RobeenJan 14 2022

Oracle DB 12.1.0.2
RAC 2 nodes on Solaris 11
Hello Team,
I have a few questions regarding AWR report.
Can you please advise what does recommendation below mean?

  Recommendation 2: Segment Tuning
   Estimated benefit is .11 active sessions, 3.3% of total activity.
   -----------------------------------------------------------------
   Action
      Run "Segment Advisor" on TABLE "CBSOGG.CB_ACCOUNT_RECEIVE_PAY" with
      object ID 1378774.
      Related Object
         Database object with ID 1378774.
   Action
      Investigate application logic involving I/O on TABLE
      "CBSOGG.CB_ACCOUNT_RECEIVE_PAY" with object ID 1378774.
      Related Object
         Database object with ID 1378774.
   Rationale
      The I/O usage statistics for the object are: 15 full object scans,
      5544524 physical reads, 2 physical writes and 5513634 direct reads.

Execute to parse is -ve
image.pngShould I increase shared pool?

shared_pool_reserved_size      big integer
1G
shared_pool_size           big integer

NAME                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
0

Thanks,
Roshan

Comments

Post Details

Added on Jan 14 2022
#performance-availability, #xml-db
0 comments
328 views