Skip to content

Files

Latest commit

b1c902e · Mar 20, 2018

History

History
This branch is 148 commits behind oracle-samples/oracle-db-examples:main.

gather_stale

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Mar 16, 2018
Mar 20, 2018
Mar 20, 2018
Mar 16, 2018
Mar 16, 2018

How to gather statistics on individual tables, but only if statistics need to be gathered.

The scripts are designed to work in SQL Plus or SQLCL.

Spool files (.lst) are included so you can see the expected results.

nopart.sql is an example for non-partitioned environments

part.sql creates a partitioned table

DISCLAIMER

  • These scripts are provided for educational purposes only.
  • They are NOT supported by Oracle World Wide Technical Support.
  • The scripts have been tested and they appear to work as intended.
  • You should always run scripts on a test instance.

WARNING

  • These scripts drop and create tables. For use on test databases.