oracle table monitoring

[Himanshu Agrawal]

Hi, 

We need to monitor only 3 table size on a oracle database.

Can we do that or it will monitor all available tables on that server when we tick tablespace size ?

[Gene Howard]

By default, it will monitor all tablespace size.
You could create a custom checkpoint based on that query to only do the ones that you want.
How to create a custom checkpoint for Oracle probe (Knowledge Base Articles - 14959)
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=14959

Oracle Checkpoint Queries (Knowledge Base Articles - 34630)
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=34630

------------------------------
Gene Howard
Principal Support Engineer
Broadcom
------------------------------

[Himanshu Agrawal]

Hi Gene,
 
I want to monitor "if number of rows in table goes beyond certain number" generate alert . How can it be done ?

[Gene Howard]

this would be a simple Select Count(*) from XXXX custom query.

------------------------------
Gene Howard
Principal Support Engineer
Broadcom
------------------------------

[Himanshu Agrawal]

Hi Gene,

Although i am able to connect to database, but when i am entering query and test query it is showing "query returns error : query test connection to database failed". Why it could be  ?

[David Michel]

For the answer to that question there is a feature of the probe which will be most helpful, it's log. 
By design all probes maintain a log called <probe name>.log. 
Even more the level of detail is controllable via the log level setting.

------------------------------
Support Engineer
Broadcom
------------------------------

[Gene Howard]

Could be a rights issue hard to say not enough information to provide any insight

------------------------------
Gene Howard
Principal Support Engineer
Broadcom
------------------------------