Archives of the TeradataForum
Message Posted: Wed, 17 Mar 2004 @ 14:28:45 GMT
The manual (V2R5.1 Database Administrator manual, Chapter 14: Tools for managing resources, Tracking system object counts) has a couple of cautions:
1. Do not enable count collection if you are performing a dump or restore on the data dictionary. The feature is automatically disabled if dictionary locks are held longer than the rate set for ObjectUseCountCollectRate
2. Collecting use counts, like access logging, is resource-intensive. Enable this feature only if necessary, and set the collection rate as needed
Has any other area implemented this and what impact have they seen on backups to dictionary (do they toggle this value before and after) & on system performance? Have they gone with the NCR recommendation of 10 minutes or what value are they using? Additionally, is anyone running the macros that clear these values down & why are they doing this.
Thanks for any information provided.
Ian A Russell
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|