SAP Note 408527 - Checking the statistics using DBA_TAB_MODIFICATIONS

Composant : Database Administration with Oracle -

Solution : https://service.sap.com/sap/support/notes/408527 (Connexion à SAP Service Marketplace requise)

Mots Clés :
> set pagesize 50000> spool monit> select 'alter table, connect sap<sid>/<pwd>> set heading, / 100or<old_number_records> - <number_records_deleted> - <number_records_changed> <= <old_number_records> 100 /, <old_number_records> + <number_records_added> + <number_records_changed> >= <old_number_records>, > connect sapr3/<pwd>> @monitdata, prerequisites recommendation/additional informationprerequisite, means ofdetermining fragmented indexes, > connect sapr3/<pwd>, / 100or<new_number_records> <= <old_number_records> 100 /, br986w warnings referring

Notes associées :

806554FAQ: I/O-intensive database operations
744483Changes in collection of statistics in BRCONNECT 6.40
588668FAQ: Database statistics
517209BRCONNECT ignores DBA_TAB_MODIFICATIONS tables
491750ORA-01002 in BRCONNECT 6.10 at the tab_modif_read-7 location
403706Corrections in BR*Tools Version 6.10
403704BRCONNECT - Enhanced function for Oracle DBA
184513CBO: Parallel generation of optimizer statistics