The following topics are presented in this chapter:
If the following parameters are not enabled for the Sybase Adaptive Server Enterprise (ASE) plug-in, metric collection errors may occur:
sp_configure "sql text pipe active", 1 sp_configure "sql text pipe max messages", 500 sp_configure "max SQL text monitored", 2048 sp_configure "plan text pipe active", 1 sp_configure "plan text pipe max messages", 100 sp_configure "statement pipe active", 1 sp_configure "statement pipe max messages", 500 sp_configure "statement statistics active", 1 sp_configure "per object statistics active", 1 sp_configure "enable stmt cache monitoring", 1 sp_configure "max SQL text monitored", 4096 set mon_stateful_history off
For information about the troubleshooting scenarios that you might encounter while working with the System Monitoring plug-ins, see the Oracle Enterprise Manager Third-Party Database Plug-in Troubleshooting Guide.