This chapter describes the possible troubleshooting scenarios and any known issues for the Sybase ASE plug-in.
The following topics are presented in this chapter:
If the following parameters are not enabled for the Sybase Adaptive Server 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 System Monitoring Plug-in Troubleshooting Guide:
http://docs.oracle.com/cd/E24628_01/em.121/e35212/toc.htm