Autonomous Database (ADB) で DBMS_CLOUD_AI (Select AIなど) を使用する際に作成した、AI Profile（AIプロファイル）の登録状況を確認するための方法です。
よく確認方法忘れてしまうので備忘録程度です。
結論それぞれのDBMS_CLOUD_AIビューを見るだけでOK。
プロファイル一覧を確認する
自分のスキーマのみ確認する場合
作成済みのプロファイル名や作成日などを確認するには USER_CLOUD_AI_PROFILES ビューを参照します。
SQL> SELECT * FROM USER_CLOUD_AI_PROFILES;
PROFILE_ID PROFILE_NAME STATUS DESCRIPTION CREATED LAST_MODIFIED ORACLE_MAINTAINED
_____________ ___________________________ __________ ______________________________________________________ _________________________________________ _________________________________________ ____________________
7 GENAI_COHERE_COMMAND_R ENABLED 25-09-11 17:36:01.320640000 ASIA/TOKYO 25-09-11 17:36:01.320640000 ASIA/TOKYO N
29 GENAI_COHERE_2025 ENABLED 25-10-14 21:23:10.983449000 ASIA/TOKYO 25-10-14 21:23:10.983449000 ASIA/TOKYO N
9 OCI_GENAI_GROK_3 ENABLED Supports the Select AI Sales Return Agent scenario. 25-09-12 05:43:57.708674000 UTC 25-09-12 05:43:57.708674000 UTC N
11 AGENT$RETURN_AGENCY_TEAM ENABLED dummy profile for agent team 25-09-12 05:46:20.398182000 UTC 25-09-12 05:46:20.398182000 UTC N
8 XAI_GROK4 ENABLED 25-09-12 13:40:17.660336000 ASIA/TOKYO 25-09-12 13:40:17.660336000 ASIA/TOKYO N
全ユーザーのプロファイルを確認する場合（管理者向け）
他のユーザーを含めた全てのプロファイルを確認するにはADMINでDBA_CLOUD_AI_PROFILES ビューを参照します。
SQL> SELECT * FROM DBA_CLOUD_AI_PROFILES;
PROFILE_ID PROFILE_NAME OWNER STATUS DESCRIPTION CREATED LAST_MODIFIED ORACLE_MAINTAINED
_____________ __________________________________ _________________ __________ ______________________________________________________ _________________________________________ _________________________________________ ____________________
5 GENAI_COHERE_COMMAND_R ADMIN ENABLED 25-09-08 21:13:17.027944000 ASIA/TOKYO 25-09-08 21:13:17.027944000 ASIA/TOKYO N
31 GENAI_COHERE_COMMAND_R SELECT_AI_USER ENABLED 25-12-03 14:51:17.205749000 ASIA/TOKYO 25-12-03 14:51:17.205749000 ASIA/TOKYO N
4 GENAI_COHERE_COMMAND_R_COMMENTS SELECT_AI_USER ENABLED 25-07-12 15:12:23.084739000 ASIA/TOKYO 25-07-12 15:12:23.084739000 ASIA/TOKYO N
7 GENAI_COHERE_COMMAND_R WKSP_APEXDEV ENABLED 25-09-11 17:36:01.320640000 ASIA/TOKYO 25-09-11 17:36:01.320640000 ASIA/TOKYO N
29 GENAI_COHERE_2025 WKSP_APEXDEV ENABLED 25-10-14 21:23:10.983449000 ASIA/TOKYO 25-10-14 21:23:10.983449000 ASIA/TOKYO N
9 OCI_GENAI_GROK_3 WKSP_APEXDEV ENABLED Supports the Select AI Sales Return Agent scenario. 25-09-12 05:43:57.708674000 UTC 25-09-12 05:43:57.708674000 UTC N
11 AGENT$RETURN_AGENCY_TEAM WKSP_APEXDEV ENABLED dummy profile for agent team 25-09-12 05:46:20.398182000 UTC 25-09-12 05:46:20.398182000 UTC N
8 XAI_GROK4 WKSP_APEXDEV ENABLED 25-09-12 13:40:17.660336000 ASIA/TOKYO 25-09-12 13:40:17.660336000 ASIA/TOKYO N
19 VECTOR_CRED$PROF DOCUSER ENABLED 25-10-04 09:49:57.576474000 ASIA/TOKYO 25-10-04 09:49:57.576474000 ASIA/TOKYO N
9 rows selected.
プロファイルの属性（詳細設定）を確認する
自分のスキーマのみ確認する場合
各プロファイルに設定されている具体的な属性値（プロバイダー、クレデンシャル、モデル名、オブジェクトリストなど）を確認するには USER_CLOUD_AI_PROFILE_ATTRIBUTES ビューを参照します。
SQL> SELECT * FROM USER_CLOUD_AI_PROFILE_ATTRIBUTES;
PROFILE_ID PROFILE_NAME ATTRIBUTE_NAME ATTRIBUTE_VALUE LAST_MODIFIED
_____________ _________________________ __________________ ___________________________________________________________________________________ _________________________________________
7 GENAI_COHERE_COMMAND_R provider oci 25-09-11 17:36:01.338729000 ASIA/TOKYO
7 GENAI_COHERE_COMMAND_R credential_name OCI_GENAI_CRED 25-09-11 17:36:01.338729000 ASIA/TOKYO
7 GENAI_COHERE_COMMAND_R model cohere.command-a-03-2025 25-09-11 17:36:01.338729000 ASIA/TOKYO
7 GENAI_COHERE_COMMAND_R oci_apiformat COHERE 25-09-11 17:36:01.338729000 ASIA/TOKYO
7 GENAI_COHERE_COMMAND_R object_list [{"owner":"WKSP_APEXDEV","name":"EMP"},{"owner":"WKSP_APEXDEV","name":"DEPT"},{" 25-09-11 17:36:01.338729000 ASIA/TOKYO
29 GENAI_COHERE_2025 provider oci 25-10-14 21:23:11.112928000 ASIA/TOKYO
29 GENAI_COHERE_2025 credential_name OCI_GENAI_CRED 25-10-14 21:23:11.112928000 ASIA/TOKYO
29 GENAI_COHERE_2025 model cohere.command-a-03-2025 25-10-14 21:23:11.112928000 ASIA/TOKYO
29 GENAI_COHERE_2025 oci_apiformat COHERE 25-10-14 21:23:11.112928000 ASIA/TOKYO
29 GENAI_COHERE_2025 region us-chicago-1 25-10-14 21:23:11.112928000 ASIA/TOKYO
29 GENAI_COHERE_2025 object_list [{"owner":"WKSP_APEXDEV","name":"ACTOR_MV_HW"}] 25-10-14 21:23:11.112928000 ASIA/TOKYO
9 OCI_GENAI_GROK_3 provider oci 25-09-12 05:43:57.730878000 UTC
9 OCI_GENAI_GROK_3 credential_name OCI_GENAI_CRED 25-09-12 05:43:57.730878000 UTC
9 OCI_GENAI_GROK_3 model xai.grok-3 25-09-12 05:43:57.730878000 UTC
9 OCI_GENAI_GROK_3 embedding_model cohere.embed-english-v3.0 25-09-12 05:43:57.730878000 UTC
8 XAI_GROK4 provider oci 25-09-12 13:40:17.721929000 ASIA/TOKYO
8 XAI_GROK4 credential_name OCI_GENAI_CRED 25-09-12 13:40:17.721929000 ASIA/TOKYO
8 XAI_GROK4 model xai.grok-4 25-09-12 13:40:17.721929000 ASIA/TOKYO
8 XAI_GROK4 oci_apiformat GENERIC 25-09-12 13:40:17.721929000 ASIA/TOKYO
8 XAI_GROK4 object_list [{"owner":"WKSP_APEXDEV","name":"EMP"},{"owner":"WKSP_APEXDEV","name":"DEPT"},{" 25-09-12 13:40:17.721929000 ASIA/TOKYO
20 rows selected.
全ユーザーのプロファイルを確認する場合（管理者向け）
先ほどと同様。
他のユーザーを含めた全てのプロファイル属性を確認するにはADMINユーザーで、DBA_CLOUD_AI_PROFILE_ATTRIBUTES ビューを参照します。
SQL> SELECT * FROM DBA_CLOUD_AI_PROFILE_ATTRIBUTES;
PROFILE_ID PROFILE_NAME OWNER ATTRIBUTE_NAME ATTRIBUTE_VALUE LAST_MODIFIED
_____________ _________________________ _______________ __________________ ___________________________________________________________________________________ _________________________________________
5 GENAI_COHERE_COMMAND_R ADMIN provider oci 25-09-08 21:13:17.131616000 ASIA/TOKYO
5 GENAI_COHERE_COMMAND_R ADMIN credential_name OCI_GENAI_CRED 25-09-08 21:13:17.131616000 ASIA/TOKYO
5 GENAI_COHERE_COMMAND_R ADMIN model cohere.command-r-08-2024 25-09-08 21:13:17.131616000 ASIA/TOKYO
5 GENAI_COHERE_COMMAND_R ADMIN oci_apiformat COHERE 25-09-08 21:13:17.131616000 ASIA/TOKYO
5 GENAI_COHERE_COMMAND_R ADMIN region ap-osaka-1 25-09-08 21:13:17.131616000 ASIA/TOKYO
5 GENAI_COHERE_COMMAND_R ADMIN object_list [{"owner":"WKSP_SELECTAITEST"}] 25-09-08 21:13:17.131616000 ASIA/TOKYO
7 GENAI_COHERE_COMMAND_R WKSP_APEXDEV provider oci 25-09-11 17:36:01.338729000 ASIA/TOKYO
7 GENAI_COHERE_COMMAND_R WKSP_APEXDEV credential_name OCI_GENAI_CRED 25-09-11 17:36:01.338729000 ASIA/TOKYO
7 GENAI_COHERE_COMMAND_R WKSP_APEXDEV model cohere.command-a-03-2025 25-09-11 17:36:01.338729000 ASIA/TOKYO
7 GENAI_COHERE_COMMAND_R WKSP_APEXDEV oci_apiformat COHERE 25-09-11 17:36:01.338729000 ASIA/TOKYO
7 GENAI_COHERE_COMMAND_R WKSP_APEXDEV object_list [{"owner":"WKSP_APEXDEV","name":"EMP"},{"owner":"WKSP_APEXDEV","name":"DEPT"},{" 25-09-11 17:36:01.338729000 ASIA/TOKYO
29 GENAI_COHERE_2025 WKSP_APEXDEV provider oci 25-10-14 21:23:11.112928000 ASIA/TOKYO
29 GENAI_COHERE_2025 WKSP_APEXDEV credential_name OCI_GENAI_CRED 25-10-14 21:23:11.112928000 ASIA/TOKYO
29 GENAI_COHERE_2025 WKSP_APEXDEV model cohere.command-a-03-2025 25-10-14 21:23:11.112928000 ASIA/TOKYO
29 GENAI_COHERE_2025 WKSP_APEXDEV oci_apiformat COHERE 25-10-14 21:23:11.112928000 ASIA/TOKYO
29 GENAI_COHERE_2025 WKSP_APEXDEV region us-chicago-1 25-10-14 21:23:11.112928000 ASIA/TOKYO
29 GENAI_COHERE_2025 WKSP_APEXDEV object_list [{"owner":"WKSP_APEXDEV","name":"ACTOR_MV_HW"}] 25-10-14 21:23:11.112928000 ASIA/TOKYO
9 OCI_GENAI_GROK_3 WKSP_APEXDEV provider oci 25-09-12 05:43:57.730878000 UTC
9 OCI_GENAI_GROK_3 WKSP_APEXDEV credential_name OCI_GENAI_CRED 25-09-12 05:43:57.730878000 UTC
9 OCI_GENAI_GROK_3 WKSP_APEXDEV model xai.grok-3 25-09-12 05:43:57.730878000 UTC
9 OCI_GENAI_GROK_3 WKSP_APEXDEV embedding_model cohere.embed-english-v3.0 25-09-12 05:43:57.730878000 UTC
PROFILE_ID PROFILE_NAME OWNER ATTRIBUTE_NAME ATTRIBUTE_VALUE LAST_MODIFIED
_____________ __________________________________ _________________ _____________________ ___________________________________________________________________________________ _________________________________________
8 XAI_GROK4 WKSP_APEXDEV provider oci 25-09-12 13:40:17.721929000 ASIA/TOKYO
8 XAI_GROK4 WKSP_APEXDEV credential_name OCI_GENAI_CRED 25-09-12 13:40:17.721929000 ASIA/TOKYO
8 XAI_GROK4 WKSP_APEXDEV model xai.grok-4 25-09-12 13:40:17.721929000 ASIA/TOKYO
8 XAI_GROK4 WKSP_APEXDEV oci_apiformat GENERIC 25-09-12 13:40:17.721929000 ASIA/TOKYO
8 XAI_GROK4 WKSP_APEXDEV object_list [{"owner":"WKSP_APEXDEV","name":"EMP"},{"owner":"WKSP_APEXDEV","name":"DEPT"},{" 25-09-12 13:40:17.721929000 ASIA/TOKYO
19 VECTOR_CRED$PROF DOCUSER provider oci 25-10-04 09:49:57.659005000 ASIA/TOKYO
19 VECTOR_CRED$PROF DOCUSER credential_name VECTOR_CRED 25-10-04 09:49:57.659005000 ASIA/TOKYO
19 VECTOR_CRED$PROF DOCUSER oci_compartment_id ocid1.compartment.oc1..aaaaaaaa3oq2a3gfabe77xkyhcrorbwglvxllhmuvq2dd2cmzfqkcu5o3 25-10-04 09:49:57.659005000 ASIA/TOKYO
31 GENAI_COHERE_COMMAND_R SELECT_AI_USER credential_name OCI_GENAI_CRED 25-12-03 14:51:17.289416000 ASIA/TOKYO
31 GENAI_COHERE_COMMAND_R SELECT_AI_USER model cohere.command-r-08-2024 25-12-03 14:51:17.289416000 ASIA/TOKYO
31 GENAI_COHERE_COMMAND_R SELECT_AI_USER oci_apiformat COHERE 25-12-03 14:51:17.289416000 ASIA/TOKYO
31 GENAI_COHERE_COMMAND_R SELECT_AI_USER region ap-osaka-1 25-12-03 14:51:17.289416000 ASIA/TOKYO
31 GENAI_COHERE_COMMAND_R SELECT_AI_USER object_list [{"owner":"select_ai_user","name":"highschools_view"}] 25-12-03 14:51:17.289416000 ASIA/TOKYO
4 GENAI_COHERE_COMMAND_R_COMMENTS SELECT_AI_USER provider oci 25-07-12 15:12:23.091442000 ASIA/TOKYO
4 GENAI_COHERE_COMMAND_R_COMMENTS SELECT_AI_USER credential_name OCI_GENAI_CRED 25-07-12 15:12:23.091442000 ASIA/TOKYO
4 GENAI_COHERE_COMMAND_R_COMMENTS SELECT_AI_USER model cohere.command-r-08-2024 25-07-12 15:12:23.091442000 ASIA/TOKYO
4 GENAI_COHERE_COMMAND_R_COMMENTS SELECT_AI_USER oci_apiformat COHERE 25-07-12 15:12:23.091442000 ASIA/TOKYO
4 GENAI_COHERE_COMMAND_R_COMMENTS SELECT_AI_USER region ap-osaka-1 25-07-12 15:12:23.091442000 ASIA/TOKYO
4 GENAI_COHERE_COMMAND_R_COMMENTS SELECT_AI_USER comments true 25-07-12 15:12:23.091442000 ASIA/TOKYO
4 GENAI_COHERE_COMMAND_R_COMMENTS SELECT_AI_USER object_list [{"owner":"select_ai_user","name":"highschools_view"}] 25-07-12 15:12:23.091442000 ASIA/TOKYO
31 GENAI_COHERE_COMMAND_R SELECT_AI_USER provider oci 25-12-03 14:51:17.289416000 ASIA/TOKYO
42 rows selected.
参考