Version 2

    Tuning SPECjAppServer2002




    Database: Oracle Buffer Cache


    Conduct at least one SPECjAppServer2002 benchmark run. Then, via the Oracle Enterprise Manager (OEM), access the database instance (probably specdb) that needs to be monitored. The user sys, connecting as a sysdba will need to be used. Upon expansion of the Instance and Configuration nodes, a Memory tab will be displayed. The Memory tab will show a number of memory related parameters. Some of the parameters have Suggestion buttons by the side of them. Use the Suggestion buttons to access the parameter suggestion screen so that the amount of memory for a specific parameter can be adjusted in accordance with Oracle�s suggestions. Refer to the Oracle documentation and tuning guides for more information.