cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Infrastructure (Server, Network, Database)

Database User Account Health Rule Setup

Gregory.Barnes
Wanderer

Database User Account Health Rule Setup

Hoping this is the correct board to post this question.  I need help in setting up a health rule for our Oracle database so I can be alerted if one of our application user accounts get locked.  For the life of me I can't seem to find where I can define that.  Any help would be greatly appreciated.

 

Thanks

Greg

By replying you agree to the Terms and Conditions of the AppDynamics Community.
Database User Account Health Rule Setup
1 REPLY 1
Hiroki.Ito
AppDynamics Team

Hi @Gregory.Barnes,

 

Database custom metrics can be used in this situation.
https://docs.appdynamics.com/21.7/en/database-visibility/monitor-databases-and-database-servers/conf...

 

You can create a custom metric by specifying SQL queries to run on the monitored database.
A custom metric with a number of locked users from the user table may work for you.

 

Then you can create a health rule and a policy to get an alert.
Please see the document below for alert and respond policy structure.
https://docs.appdynamics.com/21.7/en/appdynamics-essentials/alert-and-respond#AlertandRespond-Alerta...

 

As a side note, you can query pdb by <tablenamme>@<pdb name>.
Also, please remove semicolon at the end of the query.

e.g. select count(*) from ABC@XYZ
XYZ is PDB and ABC is the table name.

 

Best Regards,
Hiroki


Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.