DBMS_CLOUD_AI_AGENT Views

The DBMS_CLOUD_AI_AGENT package uses the following views.

See Also:

Select AI Agent

• DBA_AI_AGENTS View
  The view display agents created by all users inside their database.
• DBA_AI_AGENTS_ATTRIBUTES View
  The view displays attributes of the agents created by all users inside their database.
• USER_AI_AGENTS View
  The view displays details on conversations in your schema.
• USER_AI_AGENTS_ATTRIBUTES View
  The view displays attributes of agents created by the current user inside their schema.
• DBA_AI_AGENT_TOOL View
  The view displays details of the tools created by all users inside their database.
• DBA_AI_AGENT_TOOL_ATTRIBUTES View
  The view displays attributes of tools created by all users inside their database.
• USER_AI_AGENT_TOOL View
  The view displays details tools created by the current user inside their schema.
• USER_AI_AGENT_TOOL_ATTRIBUTES View
  The view displays attributes of tools created by the current user inside their schema.
• DBA_AI_AGENT_TASK View
  The view display tasks created by all users inside their database.
• DBA_AI_AGENT_TASK_ATTRIBUTES View
  The view displays attributes of tasks created by all users inside their database.
• USER_AI_AGENTS View
  The view displays details on tasks created by the current user inside their schema.
• USER_AI_AGENT_TASK_ATTRIBUTES View
  The view displays attributes of tasks created by the current user inside their schema.
• DBA_AI_AGENT_TEAMS View
  The view displays details of the teams created by all users inside their database.
• DBA_AI_AGENT_TEAM_ATTRIBUTES View
  The view displays attributes of teams created by all users inside their database.
• USER_AI_AGENT_TEAMS View
  The view displays details on teams created by the current user inside their schema.
• USER_AI_AGENT_TEAM_ATTRIBUTES View
  The view displays details of attributes of teams created by the current user inside their schema.
• DBMS_CLOUD_AI_AGENT History Views
  The DBMS_CLOUD_AI history views are categorized into team history view, task history view, and tool history views.

DBA_AI_AGENTS View

The view display agents created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column	Datatype	NULL	Description
AGENT_ID	NUMBER	NOT NULL	Stores the unique number assigned to an agent.
AGENT_NAME	VARCHAR2(128)	NOT NULL	Specifies the agent name.
OWNER	VARCHAR2(128)	NOT NULL	Specifies the owner of the agent.
DESCRIPTION	CLOB	-	Provides a description summarizing the purpose or context of the agent.
CREATED	TIMESTAMP(6) WITH TIME ZONE	-	The timestamp the agent was created.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	-	Indicates the timestamp of the most recent modification to the agent.
STATUS	VARCHAR2(8)	-	Specifies the status of the agent.
ORACLE_MAINTAINED	CHAR(1)	-	Indicates that the object is maintained by Oracle.

DBA_AI_AGENTS_ATTRIBUTES View

The view displays attributes of the agents created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column	Datatype	NULL	Description
AGENT ID	NUMBER	NOT NULL	Stores the unique number assigned to an agent.
AGENT_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the agent.
OWNER	VARCHAR2(128)	NOT NULL	Specifies the owner of the agent attributes.
ATTRIBUTE_NAME	VARCHAR2(128)	-	Specifies the name of the attributes.
ATTRIBUTE_VALUE	CLOB	NOT NULL	Specifies the attribute value.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the agent attribute.

USER_AI_AGENTS View

The view displays details on conversations in your schema.

The current user can see the agents they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column	Datatype	NULL	Description
AGENT_ID	NUMBER	NOT NULL	Stores the unique number assigned to an agent.
AGENT_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the agent.
DESCRIPTION	CLOB	-	Provides a description summarizing the purpose or context of the agent.
CREATED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	The timestamp the agent was created.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the agent.
STATUS	VARCHAR2(8)	-	Specifies the status of the agent.
ORACLE_MAINTAINED	NUMBER	-	Indicates if it is maintained by Oracle.

USER_AI_AGENTS_ATTRIBUTES View

The view displays attributes of agents created by the current user inside their schema.

The current user can see the agent attributes they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column	Datatype	NULL	Description
AGENT ID	NUMBER	NOT NULL	Stores the unique number assigned to an agent.
AGENT_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the agent.
ATTRIBUTE_NAME	VARCHAR2(128)	-	Specifies the name of the attributes.
ATTRIBUTE_VALUE	CLOB	NOT NULL	Specifies the attribute value.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the agent attribute.

DBA_AI_AGENT_TOOL View

The view displays details of the tools created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column	Datatype	NULL	Description
TOOL ID	NUMBER	NOT NULL	Stores the unique number assigned to a tool.
TOOL_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the tool.
OWNER	VARCHAR2(128)	NOT NULL	Specifies the owner of the tool.
DESCRIPTION	CLOB	-	Provides a description summarizing the purpose or context of the tool.
CREATED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	The timestamp the tool was created.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the tool.
STATUS	VARCHAR2(8)	-	Specifies the status of the tool.
ORACLE_MAINTAINED	CHAR(1)	-	Indicates if the object is maintained by Oracle.

DBA_AI_AGENT_TOOL_ATTRIBUTES View

The view displays attributes of tools created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column	Datatype	NULL	Description
TOOL ID	NUMBER	NOT NULL	Stores the unique number assigned to a tool attribute.
AGENT_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the tool.
OWNER	VARCHAR2(128)	NOT NULL	Specifies the owner of the tool attribute.
ATTRIBUTE_NAME	VARCHAR2(128)	-	Specifies the name of the attribute.
ATTRIBUTE_VALUE	CLOB	NOT NULL	Specifies the attribute value.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the tool attributes.

USER_AI_AGENT_TOOL View

The view displays details tools created by the current user inside their schema.

The current user can see the tools they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column	Datatype	NULL	Description
TOOL ID	NUMBER	NOT NULL	Stores the unique number assigned to a tool.
TOOL_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the tool.
DESCRIPTION	CLOB	-	Provides a description summarizing the purpose or context of the tool.
CREATED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	The timestamp the tool was created.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the tool.
STATUS	VARCHAR2(8)	-	Specifies the status of the tool.
ORACLE_MAINTAINED	CHAR(1)	-	Indicates if the object is maintained by Oracle.

USER_AI_AGENT_TOOL_ATTRIBUTES View

The view displays attributes of tools created by the current user inside their schema.

The current user can see the tool attributes they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column	Datatype	NULL	Description
TOOL ID	NUMBER	NOT NULL	Stores the unique number assigned to a tool.
AGENT_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the tool.
ATTRIBUTE_NAME	VARCHAR2(128)	-	Specifies the name of the attribute.
ATTRIBUTE_VALUE	CLOB	NOT NULL	Specifies the attribute value.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the tool attributes.

DBA_AI_AGENT_TASK View

The view display tasks created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column	Datatype	NULL	Description
TASK ID	NUMBER	NOT NULL	Stores the unique number assigned to a task.
TASK_NAME	VARCHAR2(128)	NOT NULL	Specifies the task name.
OWNER	VARCHAR2(128)	NOT NULL	Specifies the owner of the task.
DESCRIPTION	CLOB	-	Provides a description summarizing the purpose or context of the task.
CREATED	TIMESTAMP(6) WITH TIME ZONE	-	The timestamp the task was created.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	-	Indicates the timestamp of the most recent modification to the task.
STATUS	VARCHAR2(8)	-	Specifies the status of the task.
ORACLE_MAINTAINED	CHAR(1)	-	Indicates that the object is maintained by Oracle.

DBA_AI_AGENT_TASK_ATTRIBUTES View

The view displays attributes of tasks created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column	Datatype	NULL	Description
TASK ID	NUMBER	NOT NULL	Stores the unique number assigned to a task.
TASK_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the task.
OWNER	VARCHAR2(128)	NOT NULL	Specifies the owner of the task attributes.
ATTRIBUTE_NAME	VARCHAR2(128)	-	Specifies the name of the attributes.
ATTRIBUTE_VALUE	CLOB	NOT NULL	Specifies the attribute value.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the task attribute.

USER_AI_AGENTS View

The view displays details on tasks created by the current user inside their schema.

The current user can see the tasks they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column	Datatype	NULL	Description
TASK ID	NUMBER	NOT NULL	Stores the unique number assigned to a task.
TASK_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the task.
DESCRIPTION	CLOB	-	Provides a description summarizing the purpose or context of the task.
CREATED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	The timestamp the task was created.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the task.
STATUS	VARCHAR2(8)	-	Specifies the status of the task.
ORACLE_MAINTAINED	NUMBER	-	Indicates if the task is maintained by Oracle.

USER_AI_AGENT_TASK_ATTRIBUTES View

The view displays attributes of tasks created by the current user inside their schema.

The current user can see the agent task attributes they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column	Datatype	NULL	Description
TASK ID	NUMBER	NOT NULL	Stores the unique number assigned to an agent task.
TASK_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the task.
ATTRIBUTE_NAME	VARCHAR2(128)	-	Specifies the name of the attributes.
ATTRIBUTE_VALUE	CLOB	NOT NULL	Specifies the attribute value.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the agent task attribute.

DBA_AI_AGENT_TEAMS View

The view displays details of the teams created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column	Datatype	NULL	Description
TEAM ID	NUMBER	NOT NULL	Stores the unique number assigned to a tool.
TEAM_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the team.
OWNER	VARCHAR2(128)	NOT NULL	Specifies the owner of the team.
DESCRIPTION	CLOB	-	Provides a description summarizing the purpose or context of the team.
CREATED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	The timestamp the team was created.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the team.
STATUS	VARCHAR2(8)	-	Specifies the status of the team.
ORACLE_MAINTAINED	CHAR(1)	-	Indicates if the object is maintained by Oracle.

DBA_AI_AGENT_TEAM_ATTRIBUTES View

The view displays attributes of teams created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column	Datatype	NULL	Description
TEAM ID	NUMBER	NOT NULL	Stores the unique number assigned to a task.
TEAM_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the team.
OWNER	VARCHAR2(128)	NOT NULL	Specifies the owner of the team attributes.
ATTRIBUTE_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the attributes.
ATTRIBUTE_VALUE	CLOB	-	Specifies the attribute value.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	-	Indicates the timestamp of the most recent modification to the team attribute.

USER_AI_AGENT_TEAMS View

The view displays details on teams created by the current user inside their schema.

The current user can see the team they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column	Datatype	NULL	Description
TEAM ID	NUMBER	NOT NULL	Stores the unique number assigned to an team.
TEAM_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the team.
DESCRIPTION	CLOB	-	Provides a description summarizing the purpose or context of the team.
CREATED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	The timestamp the team was created.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	NOT NULL	Indicates the timestamp of the most recent modification to the team.
STATUS	VARCHAR2(8)	-	Specifies the status of the team.
ORACLE_MAINTAINED	NUMBER	-	Indicates if the object is maintained by Oracle.

USER_AI_AGENT_TEAM_ATTRIBUTES View

The view displays details of attributes of teams created by the current user inside their schema.

The current user can see the team attributes they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column	Datatype	NULL	Description
TEAM ID	NUMBER	NOT NULL	Stores the unique number assigned to an agent team.
TEAM_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the team.
ATTRIBUTE_NAME	VARCHAR2(128)	NOT NULL	Specifies the name of the attribute.
ATTRIBUTE_VALUE	CLOB	-	Specifies the attribute value.
LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE	-	Indicates the timestamp of the most recent modification to the agent team attribute.