Dynamic sql to kill session oracle rac6/13/2023 The relevant statistical value of each service is divided by the total value and multiplied by 100 to find the relevant statistical usage percentage of the relevant service. SUM_VALUE column is created by summing up the relevant statistical values found at SERVICE_NAME level.Ĥ. Thus, the values of the instances are collected at the SERVICE_NAME and STAT_NAME levels for the specified time period.ģ. Group by is done according to SERVICE_NAME and STAT_NAME. VALUE: The statistical value of the days in the time period specified at the instance level is found by subtracting the minimum value from the maximum value. *įor statistics that measure time (such as the DB CPU), this column displays a cumulative value in microseconds.įor other statistics that do not measure time (such as execute count) this column displays the appropriate numeric value for the statistic.ġ. Please note that the query was confirmed by Connor on asktom. If you need to historically check the resource usage (Example: DB CPU) according to the services in the Oracle database, you can use the following SQL that I have prepared by revising it according to your needs.
0 Comments
Leave a Reply. |