Table space Monitoring

Hello Nikola,

easiest would be a user defined query. Our DB agents provide the option to take your own SQL statement and let the agent run it. So any metric which Foglight does not collect, can be collected this way. So in your case take the statement to get the needed tablespace metrics and in the WHERE clause enter the tablespace names of the tablespaces which you want to monitor. Then create a user defined query with this statement.

Here  a solution how to create a user defined query:

https://support.quest.com/foglight/kb/106430/configuring-user-defined-collections-for-oracle-database-agents

And here a solution how to create a rule for the metrics collected by the user defined query:

https://support.quest.com/foglight/kb/114172/how-to-create-a-rule-for-a-user-defined-collection

Does that help?

Cheers

Nicola

Hi Nicola

thank you, I know about that features and I have SQL statement but little problem for me is that I want read tabelspaces names from file because there is lot of them and I dont want edit SQL query every time I muss add new tablespace under monitoring. So, the WHERE clause must be to read from file or table. This is I think the best way to adding new tablespaces under monitoring.

Hi Nicola

thank you, I know about that features and I have SQL statement but little problem for me is that I want read tabelspaces names from file because there is lot of them and I dont want edit SQL query every time I muss add new tablespace under monitoring. So, the WHERE clause must be to read from file or table. This is I think the best way to adding new tablespaces under monitoring.

Hello Nikola,

in that case I think it might be best if you discuss your request with our PSO team. They might have further ideas how to implement it.

Your account manger can help to arrange the PSO contact or you can have a look here:
support.quest.com/professional-services-product-select

Kind Regards

Nicola