spClientMonitor software utility provides Oracle database administrators and tuning experts a convenient way to monitor and trace SQL performance of client applications accessing Oracle databases through the IP network.This unique software 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. spClientMonitor software also facilitates SQL tracing and debugging during resolving SQL performance issues and development of new applications. By implementing spClientMonitor, organizations can speed up trouble shooting, improve application stability and performance, as well as detect scarce resources more cost-effectively. 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. Key Features ------------ * Capture response time for SQL statements for target clients hosts, applications, end-users, and Oracle databases. * Support of passive non-intrusive and active monitoring modes. * Flexible deployment configurations which allow to meet all customers needs. * Very robust performance monitoring stability handling thousands of simultaneous SQL transactions. * Support of all Oracle current production database releases starting from 8.1.7 up to 11.2. * Detailed SQL performance analysis. * Capture of full SQL statement text * Capture full Oracle sessions details like username, host IP address, application, database service name/SID, operating system user name. * Support of SQL performance baselines based on the performance history. * SQL profile feature support which allows you to group target SQL statements into logical groups called SQL Profiles and quickly analyze the aggregate response times. * Tracing session's SQL statements with response time analysis and execution plans. * Convenient graphical user interface. * Performing long-time and trend analysis based on the SQL performance history stored in the database repository.