Is there any rule, which monitors long running queries aka long running sql for Oracle database monitoring cartridges in Foglight?
This rule is unnecessary because for some data warehouse environments most of the reports query take a long time which is fine and OK. For OLTP environments, the long running SQL's will be always in the TOP SQL's list because in OLTP most of of the queries should be executed extremely fast.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center