Skip to Main Content
Troubleshooting Oracle Performance, Second Edition
book

Troubleshooting Oracle Performance, Second Edition

by Christian Antognini
June 2014
Intermediate to advanced content levelIntermediate to advanced
740 pages
23h 59m
English
Apress
Content preview from Troubleshooting Oracle Performance, Second Edition

Deleting Object Statistics

You can delete object statistics from the data dictionary. Except for testing purposes, this is usually not necessary. Nevertheless, it might happen that a table shouldn’t have object statistics because you want to take advantage of dynamic sampling (covered in Chapter 9). In that case, the following procedures are available in the dbms_stats package: delete_database_stats, delete_dictionary_stats, delete_fixed_objects_stats, delete_schema_stats, delete_table_stats, delete_column_stats, and delete_index_stats.

As you can see, for each gather_*_stats procedure, there is a corresponding delete_*_stats procedure. The former ones gather object statistics, and the latter ones delete object statistics. The only exception ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Troubleshooting Oracle Performance

Troubleshooting Oracle Performance

Christian Antognini
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning

Richmond Shee, Kirtikumar Deshpande, K Gopalakrishnan
Expert Oracle Exadata, Second Edition

Expert Oracle Exadata, Second Edition

Martin Bach, Karl Arao, Andy Colvin, Frits Hoogland, Randy Johnson, Kerry Osborne, Tanel Poder

Publisher Resources

ISBN: 9781430257585Purchase book