oceanbase.DBA_OB_AI_MODEL_PROFILES

Overview

Displays the AI model parameter (Model Profile) configuration information for the current tenant, allowing you to view the provider/model level parameters created or updated using the ALTER_MODEL_PROFILE PL statement.

Columns

Sample query

This example shows how to query the parameter configuration information of AI models in the current tenant.

1. If you have not registered a provider, you must first register one. Replace access_key and base_url with your actual values:

   CALL DBMS_AI_SERVICE.REGISTER_PROVIDER('test-provider', '{
   "protocol": "openai",
   "base_url": "https://xxx",
   "access_key": "sk-xxx"
   }');
   

2. Use ALTER_MODEL_PROFILE to set parameters for the model:

   CALL DBMS_AI_SERVICE.ALTER_MODEL_PROFILE('test-provider/test-model', '{
   "model_config": {
       "max_tokens": 4096,
       "temperature": 0
   },
   "run_config": {
       "batch_size": 16,
       "max_image_size": 4194304,
       "min_concurrency": 10,
       "max_concurrency": 100
   }
   }');
   

3. Query model parameter configuration information:

   SELECT MODEL, MODEL_CONFIG, RUN_CONFIG
   FROM oceanbase.DBA_OB_AI_MODEL_PROFILES
   WHERE MODEL = 'test-provider/test-model';
   

   The sample result is as follows:

   MODEL	MODEL_CONFIG	RUN_CONFIG
   test-provider/test-model	{"max_tokens": 4096, "temperature": 0}	{"batch_size": 16, "max_image_size": 4194304, "max_concurrency": 100, "min_concurrency": 10}
   1 row in set
   

References

• ALTER_MODEL_PROFILE
• Monitoring AI Function Services