Archives of the TeradataForum

Message Posted: Wed, 17 Mar 2004 @ 14:28:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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
Database Administrator, Data Warehousing Services, Barclays Bank

	<Prev	Next>		<<First	<Prev	Next>	Last>>