Home » RDBMS Server » Performance Tuning » stale stats (Oracle 12c)
stale stats [message #658242] Wed, 07 December 2016 08:34 Go to previous message
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

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Oracle Advance Queue consumes messages very slowly
Next Topic: Which index to choose local or global for attached scenario
Goto Forum:
  


Current Time: Fri Mar 29 07:43:25 CDT 2024