Siebel Order Management Infrastructure Guide > PSP Engine > About Tuning Performance of PSP >

About PSP Cache Performance Statistics


To view statistics on PSP Cache performance, navigate to the Administration - Server Management screen, Tasks, and then the Statistics view, and query on "PSP*". The Siebel application provides the following statistics:

  • PSP Cache Hit Total. An integer that indicates how many times the cached query results are used.
  • PSP Cache Miss Total. An integer that indicates how many times a query cannot be found in PSP Cache for which a database query has been conducted.

NOTE:  The higher the value of PSP Cache Hit Total /(PSP Cache Hit Total + PSP Cache Miss Total), the better performance exhibited by PSP Cache.

Siebel Order Management Infrastructure Guide Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.