Note
This view is available starting with V4.6.2.1.
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
field |
Type |
Is NULL |
Description |
|---|---|---|---|
| MODEL | varchar(513) | NO | The full model name is provider_name and model_name with / Concatenated results, for example, aliyun/qwen-plus. |
| MODEL_CONFIG | varchar(4096) | YES | Model API call parameters JSON, corresponding to ALTER_MODEL_PROFILE in the model_config. |
| RUN_CONFIG | varchar(4096) | YES | JSON for model runtime options on the OceanBase side, corresponding to ALTER_MODEL_PROFILE in the run_config. |
| CREATE_TIME | timestamp(6) | NO | Creation time. |
| UPDATE_TIME | timestamp(6) | NO | Last modified at. |
Sample query
This example shows how a user tenant queries the AI model parameter configuration information of its own tenant.
If vendor configuration has not been registered, execute
REGISTER_PROVIDERfirst, and replaceaccess_keyandbase_urlwith the actual values:CALL DBMS_AI_SERVICE.REGISTER_PROVIDER('test-provider', '{ "protocol": "openai", "base_url": "https://xxx", "access_key": "sk-xxx" }');Use
ALTER_MODEL_PROFILEto 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 } }');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