find long running query of oracle in zabbix dashboard

[sniperking]

We are currently using Zabbix 4.2.4, we have the zabbix oracle database which stores the information of the server level(CPU) and database level problems(Locking) in the database.

Is there any table which stores the information of long running SQL in zabbix database.

please let me know if you need more information.

[dimir]

You can configure Zabbix server to log long queries to the log file. See option LogSlowQueries in https://www.zabbix.com/documentation.../zabbix_server

E. g. to log SQL queries that take more than 3 seconds:

LogSlowQueries=3000

[sniperking]

Dear Dimir, thank you for responding. is there any tables in zabbix which stores the long running Queries.
For example the zabbix database has tables like HISTORY_UINT_TMP,TRENDS,TASK_ACKNOWLEDGE,APPLICATI ONS

[dimir]

Nope, long queries can only be logged to the log file.

[sniperking]

Thanks for the response dimir :-)