DBMS_CLOUD_AI Views
The DBMS_CLOUD_AI package uses the following views.
DBA_CLOUD_AI_PROFILES View
The list of profiles created in the current database can be obtained by querying DBA_CLOUD_AI_PROFILES. The view displays the details of AI profiles in the database.
Only the ADMIN user is privileged to access DBA_CLOUD_AI_PROFILES. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
PROFILE_ID |
NUMBER |
NOT NULL |
Unique number assigned to the AI profile |
PROFILE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the AI profile |
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner schema of the AI profile |
STATUS |
VARCHAR2(7) |
NOT NULL |
Current status of AI profile - ENABLED or DISABLED |
DESCRIPTION |
VARCHAR2(4000) |
NOT NULL |
User specified description for the AI profile |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Creation time for the AI profile. |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification time for the AI profile |
USER_CLOUD_AI_PROFILES View
The list of profiles created in the current database can be obtained by querying USER_CLOUD_AI_PROFILES. The view displays the details of AI profiles in your schema.
Only the user is privileged to access USER_CLOUD_AI_PROFILES. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
PROFILE_ID |
NUMBER |
NOT NULL |
Unique number assigned to the AI profile |
PROFILE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the AI profile |
STATUS |
VARCHAR2(7) |
NOT NULL |
Current status of AI profile - ENABLED or DISABLED |
DESCRIPTION |
VARCHAR2(4000) |
- |
User specified description for the AI profile |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Creation time for the AI profile |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification time for the AI profile |
DBA_CLOUD_AI_PROFILE_ATTRIBUTES View
Attributes of AI profile manage the configuration and behavior of the AI profile. The view displays details of all AI profiles in the database.
Only the ADMIN user is privileged to access DBA_CLOUD_AI_PROFILE_ATTRIBUTES. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
PROFILE_ID |
NUMBER |
NOT NULL |
Unique number assigned to the AI profile |
PROFILE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the AI profile |
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner schema of the AI profile |
ATTRIBUTE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the AI profile attribute |
ATTRIBUTE_VALUE |
CLOB |
- |
Value of the AI profile attribute |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification time of the AI profile attribute |
USER_CLOUD_AI_PROFILE_ATTRIBUTES View
Attributes of AI profile manage the configuration and behavior of the AI profile. The view displays details of AI profiles in your schema.
Only the user is privileged to access USER_CLOUD_AI_PROFILE_ATTRIBUTES. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
PROFILE_ID |
NUMBER |
NOT NULL |
Unique number assigned to the AI profile |
PROFILE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the AI profile |
ATTRIBUTE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the AI profile attribute |
ATTRIBUTE_VALUE |
CLOB |
- |
Value of the AI profile attribute |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification time of the AI profile attribute |
DBA_CLOUD_VECTOR _INDEXES View
You can obtain a list of vector indexes created in the current database by querying DBA_CLOUD_VECTOR_INDEXES. The view displays the details of all available vector indexes in the entire database.
Only the administrator is privileged to access DBA_CLOUD_VECTOR_INDEXES. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
INDEX ID |
NUMBER |
NOT NULL |
Unique number assigned to the index |
INDEX_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the index |
STATUS |
VARCHAR2(7) |
- |
Current status of index: ENABLED or DISABLED |
DESCRIPTION |
CLOB |
- |
User specified description for the index |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Creation date and time of the index |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification date and time of the index |
USER_CLOUD_VECTOR _INDEXES View
You can obtain a list of vector indexes you created in the current database by querying USER_CLOUD_VECTOR_INDEXES. The view displays the details of all vector indexes that you created in your schema or a PDB.
You have the privilege to access USER_CLOUD_VECTOR_INDEXES. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
INDEX ID |
NUMBER |
NOT NULL |
Unique number assigned to the index |
INDEX_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the index |
STATUS |
VARCHAR2(7) |
- |
Current status of index: ENABLED or DISABLED |
DESCRIPTION |
VARCHAR2(4000) |
- |
User specified description for the index |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Creation date and time of the index |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification date and time of the index |
DBA_CLOUD_VECTOR_INDEX_ATTRIBUTES View
Query the DBA_CLOUD_VECTOR_INDEX_ATTRIBUTES view to display details about the attributes of vector indexes across the entire database. Attributes of the view manage the configuration and behavior of the vector index.
Only the administrator is privileged to access DBA_CLOUD_VECTOR_INDEX_ATTRIBUTES. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
INDEX_ID |
NUMBER |
NOT NULL |
Unique number assigned to the vector index |
INDEX_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the vector index |
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner schema of the vector index |
ATTRIBUTE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the vector index attribute |
ATTRIBUTE_VALUE |
CLOB |
- |
Value for the vector index attribute_name |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification date and time of the vector index |
USER_CLOUD_VECTOR_INDEX_ATTRIBUTES View
Query the USER_CLOUD_VECTOR_INDEX_ATTRIBUTES view to display details about the attributes of vector indexes that you created in your schema or PDB. Attributes of the view manage the configuration and behavior of the vector index.
You have the privilege to access USER_CLOUD_VECTOR_INDEX_ATTRIBUTES. You cannot grant access to other users.
| Column | Datatype | NULL | Description |
|---|---|---|---|
INDEX_ID |
NUMBER |
NOT NULL |
Unique number assigned to the vector index |
INDEX_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the vector index |
ATTRIBUTE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the vector index attribute |
ATTRIBUTE_VALUE |
CLOB |
- |
Value for the vector index attribute_name |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification date and time of the vector index |
USER_CLOUD_AI_CONVERSATIONS View
The view displays details on conversations in your schema.
The current user can see the conversations 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 |
|---|---|---|---|
CONVERSATION_ID |
VARCHAR2(36) |
NOT NULL |
Stores the unique number assigned to a conversation. |
CONVERSATION_TITLE |
VARCHAR2(128) |
NOT NULL |
Specifies the title for the conversation. |
DESCRIPTION |
CLOB |
- |
Provides a description summarizing the purpose or context of the conversation. This can be NULL if the conversations is not used. |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
The timestamp the conversation was created. |
MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Indicates the timestamp of the most recent modification to the conversation. |
RETENTION_DAYS |
NUMBER |
- |
Specifies the number of days to retain the conversation history. |
CONVERSATION_LENGTH |
NUMBER |
- |
Number of recent prompts and responses from the conversation that are sent to the LLM along with the current prompt. |
USER_CLOUD_AI_CONVERSATION_PROMPTS View
The view displays details of the prompts in a conversation in your schema.
The current user can see the conversation prompts 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 |
|---|---|---|---|
CONVERSATION_PROMPT_ID |
VARCHAR2(36) |
NOT NULL |
Stores the unique number assigned to a prompt. |
CONVERSATION_ID |
VARCHAR2(36) |
NOT NULL |
Stores the unique number assigned to a conversation. |
CONVERSATION_TITLE |
VARCHAR2(128) |
NOT NULL |
Specifies the name for the conversation. |
PROFILE_NAME |
VARCHAR2(128) |
- |
Specifies the AI profile used for the conversation. |
PROMPT_ACTION |
VARCHAR2(11) |
NOT NULL |
Specifies the type of action performed for the prompt (For example, narrate, runsql, chat). |
PROMPT |
CLOB |
- |
Represents a user-provided natural language input. |
PROMPT_RESPONSE |
CLOB |
- |
The LLM’s response generated for the user prompt. |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
The timestamp the prompt was created. |
MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
The timestamp the prompt was modified. |
CLIENT_IDENTIFIER |
VARCHAR2(128) |
- |
Client identifier of the session where the prompt is created. |
CLIENT_IP |
VARCHAR2(128) |
- |
Unique identifier assigned to a device. |
SID |
NUMBER |
- |
Identifier of the session where the prompt is created. |
SERIAL# |
NUMBER |
- |
Stores the unique serial number of the session in which the prompt was created. |
AI_TRANSLATION_LANGUAGES View
This view displays information about available translation languages to the user.
All users can query this view.
| Column | Datatype | NULL | Description |
|---|---|---|---|
LANGUAGE_NAME |
VARCHAR(128) |
- | The name of the language. |
LANGUAGE_CODE |
VARCHAR2(128) |
- | The unique code identifying a language, as recognized by providers. |
PROVIDER |
CLOB |
- | The generative AI provider that supports the specified language and language code. |