You must understand how data compiles in key tables and how this impacts performance of the usage monitoring process. You can gather audit columns on each table (for example, CREATE_DATE) on a daily basis and from the REFRDEL table. You should monitor how much the tables through several weeks and now the periodic peak activity. You must keep track of peak usage times because you will use them to make hardware decisions. Monitor the following tables:
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014