spClientMonitor for Oracle SQL Monitoring Publisher's description
from spViewer Software
spClientMonitor software utility provides Oracle database administrators and tuning experts with a convenient way to monitor and trace SQL performance of end users applications accessing Oracle databases through the TCP/IP network.
spClientMonitor software utility provides Oracle database administrators and tuning experts with a convenient way to monitor and trace SQL performance of end users applications accessing Oracle databases through the TCP/IP network. This unique software allows you to monitor and analyze the end users SQL response time from the application or end user point of view. spClientMonitor software facilitates SQL tracing and debugging during resolving SQL performance issues and development of new applications. By implementing spClientMonitor, companies can speed up SQL trouble shooting, improve application stability and performance, as well as detect scarce resources more cost-effectively.
spClientMonitor software product allows you to monitor and analyze the database SQL response time from the application or end user point of view. This approach is very efficient because you can see what particular end users and applications do have performance problems and what particular SQL statements cause these problems. spClientMonitor software measures the response time of every SQL statement generated by client's applications and stores SQL performance metrics in the repository which is located in a separate Oracle database schema you configure when setting up the spClientMonitor software. This approach helps organizations to quickly target badly performing clients, applications and particular SQL statements. Traditional Oracle database monitoring tools provide solutions which are focusing on the monitoring of the database instance from the database administrator point of view. In contrast, spClientMonitor enables you to watch the SQL performance from the end-user or target application point of view. This approach allows you to quickly resolve SQL related performance issues which actually form the major part of Oracle database performance problems.
The main part of spClientMonitor SQL monitoring environment is called monitoring listener (ML). ML is the software module that actually captures and measures the performance of clients' SQL transactions. ML can work in non-intrusive passive listening mode. In this passive mode, ML does not affect the performance of the target users and clients applications at all. Thus, ML does not affect the final response time of SQL statements being monitored. Furthermore, while working in passive monitoring mode ML does not require any additional configuration of clients applications and network configurations. The monitoring listener consumes typically less than 2-3% of host CPU time. If ML is running on a separate host, its overhead on the target Oracle databases is reduced to zero percent. This passive mode can be used for configurations when spClientMonitor listener is installed on the same host where target Oracle databases are running. Also, the passive capture mode can be used when spClientMonitor listener is installed on the host through which SQL traffic goes to target Oracle databases. For example, it could be a network gateway host for the subnet to which belong end client hosts working with target Oracle databases. spClientMonitor monitoring listener can also work in active mode when end users connections to target Oracle databases are established through the spClientMonitor listener. In this active mode, it places a little additional overhead on the SQL response time that is less than 1%. This mode is used when target Oracle databases run under operating systems which are different from supported Windows versions like Sun Solaris or HP Unix.
System Requirements:No special requirements.
Program Release Status:
Program Install Support: Install and Uninstall