dba_userSqlList
Retrieve SQL queries executed by specific users or all users within a specified time period to monitor database activity and analyze query patterns.
Instructions
Get a list of SQL run by a user in the last number of days if a user name is provided, otherwise get list of all SQL in the last number of days.
Arguments: user_name - user name no_days - number of days
Returns: ResponseType: formatted response with query results + metadata
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| no_days | No | ||
| user_name | Yes |
Input Schema (JSON Schema)
{
"properties": {
"no_days": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": 7,
"title": "No Days"
},
"user_name": {
"title": "User Name",
"type": "string"
}
},
"required": [
"user_name"
],
"type": "object"
}