Home » RDBMS Server » Performance Tuning » stale stats (Oracle 12c)
stale stats [message #658242] |
Wed, 07 December 2016 08:34 |
srinivas.k2005
Messages: 404 Registered: August 2006
|
Senior Member |
|
|
Hello,
We have an issue with slowness in DB and one of the suggestions from DBA is to check stale stats for the table. He has provided below info.
Examples:
SQL> select INSERTS,UPDATES,DELETES,TIMESTAMP from dba_tab_modifications where table_owner='LA' and TABLE_NAME='WORKFLOW_S';
INSERTS UPDATES DELETES TIMESTAMP
---------- ---------- ---------- -------------- ( 100% modification )
146 0 146 06-DEC-16
SQL> select INSERTS,UPDATES,DELETES,TIMESTAMP from dba_tab_modifications where table_owner='LA' and TABLE_NAME='PROVS';
INSERTS UPDATES DELETES TIMESTAMP
---------- ---------- ---------- ------------------
8118 9083 8115 06-DEC-16
DBA guys are telling our DEV team that too much of stale in the above tables and hence we need to plan to change DB architecture for these tables.
But I am not convinced because there are very few records in the tables. Yes, there are inserts and deletes happens to above tables daily but that does not mean it is hampering any performance related to queries. Am I correct here? Please advise.
Your suggestions are valuable to us.
Regards,
SRK
|
|
|
Goto Forum:
Current Time: Fri Mar 29 07:43:25 CDT 2024
|