Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   V2R5.1 & Tracking System Object Usage
 
From:   ian.a.russell

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016