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