Hi,

For some  reason we cannot install lifetime server in our production server so we are unable to use it for performance monitoring. As per my understanding, performance is still being logged for each server action/query/scree time etc in DB. Is there any way I can directly get all those logs and use it for my further analysis, e.g. lets say I have a server action GetCustomerList so can i get 

1. How many times this server action was executed in give period of time?

2. What was the time time take by each execution?


Thanks!

Hello Nuzhar,


For the lifetime installation probably a support case will be your best choice : )

Regarding the logs, yes you can access the same logs manually


I believe this are the tables you want:

OSSYS_REPORT_SLOWTIMER
OSSYS_REPORT_HOUR
OSSYS_REPORT_SLOWSCREE
OSSYS_REPORT_SLOWQUERY
OSSYS_REPORT_ESPACEUSA
OSSYS_REPORT_TYPE
OSSYS_REPORT_METRICS
OSSYS_REPORT_SLOWSQL
OSSYS_REPORT_LINE
OSSYS_REPORT_SLOWEXTENSION
OSSYS_REPORT_INTEGRATION
OSSYS_REPORT_TOPERRORS
OSSYS_REPORT_SLOWWEBSE


Best regards,

Cristiano Marques

Solution

Cristiano Marques wrote:

Hello Nuzhar,


For the lifetime installation probably a support case will be your best choice : )

Regarding the logs, yes you can access the same logs manually


I believe this are the tables you want:

OSSYS_REPORT_SLOWTIMER
OSSYS_REPORT_HOUR
OSSYS_REPORT_SLOWSCREE
OSSYS_REPORT_SLOWQUERY
OSSYS_REPORT_ESPACEUSA
OSSYS_REPORT_TYPE
OSSYS_REPORT_METRICS
OSSYS_REPORT_SLOWSQL
OSSYS_REPORT_LINE
OSSYS_REPORT_SLOWEXTENSION
OSSYS_REPORT_INTEGRATION
OSSYS_REPORT_TOPERRORS
OSSYS_REPORT_SLOWWEBSE


Best regards,

Cristiano Marques

Thanks!


Solution