Forum Stats

  • 3,825,934 Users
  • 2,260,581 Discussions
  • 7,896,738 Comments

Discussions

AWR report performance tuning

Robeen
Robeen Member Posts: 2,179 Silver Badge

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

Should I increase shared pool?

shared_pool_reserved_size      big integer
1G
shared_pool_size           big integer

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

Thanks,

Roshan