Wednesday, November 09, 2005

Developing Signatures for Data Buffers

Remember, change occurs in the data buffers rapidly, and sometimes a long-term analysis will provide clues that point to processing problems within the database. Almost every Oracle database exhibits patterns that are linked to regular processing schedules, called signatures.

To solve this problem, the DBA might schedule a dynamic adjustment to add more RAM to db_cache_size every day.

http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/burleson_auto_pt2.html