Diagnose Client/Server Performance

Performance impact: Variable

You can analyze your client/server performance with statistics that are tracked in the SYS.SYSTEMSTATS table.

These statistics can also be viewed with either the ttStats utility or the TT_STATS PL/SQL package.

Note:

For more details on the SYS.SYSTEMSTATS table, see SYS.SYSTEMSTATS in the Oracle TimesTen In-Memory Database System Tables and Views Reference. For details on the ttStats utility, see ttStats in the Oracle TimesTen In-Memory Database Reference. For more details on the TT_STATS PL/SQL package, see TT_STATS in the Oracle TimesTen In-Memory Database PL/SQL Packages Reference.

• Total number of executions from a client/server application.

• Total number of INSERT, UPDATE, DELETE, SELECT, MERGE, ALTER, CREATE, DROP statements run by the server.

• Total number of transactions committed or rolled back by the server.

• Total number of table rows inserted, updated, or deleted by the server.

• Total number of client/server roundtrips.

• Total number of bytes transmitted or received by the server.

• Total number of client/server disconnects.