AI 对话 的模板

sample1:  告诉AI 版本，才能得到该版本的准确信息，比如 OBI 

 

 

sample 1

->网址：https://www.oceanbase.com/obi

-> 对话：OceanBase 3.x 系列版本 ， SQL 查询如下信息
1.最近 3 次合并
SELECT *
FROM __all_virtual_partition_compaction_history
3;

 

##20260130 智能体研究，

 

随着Moltbot 的大火，于是继续学习了下智能体。最重要是智能体打分

 

‌除了扣子空间     76分，还有那些自动agent

Kimi OK Computer‌：Kimi推出的“OK Computer”模式，通过虚拟机与浏览器交互，能自主完成提案撰写、UI设计等多步骤任务，展现出较强的动态任务调整能力。‌

‌

MiniMax智能伙伴‌， 77 分：凭借“1M超长上下文”优势，在长文本分析、跨领域任务规划中表现亮眼，其Agent模式能在Web开发、视频创建等不同领域进行多步骤规划和自动化生成。‌

这些工具共同构成了2025年主流的Agent生态，用户可根据自身需求（如企业自动化、个人办公或特定行业应用）进行选择。‌

 

 gemini 80

 

##20260130 反向整理

针对AI 给出SQL 字段不存在，反向找到SQL DDL 定义，反向找AI 整理
1.show create table SYS.GV$SQL_AUDIT

2.咨询

show create table SYS.GV$SQL_AUDIT
这个是 "GV$SQL_AUDIT"视图定义，请根据这个定义的字段查询oracel 模式的的ob 3,2 查询
TopSQL

CREATE VIEW "GV$SQL_AUDIT" AS SELECT svr_ip SVR_IP, svr_port SVR_PORT, request_id REQUEST_ID, execution_id SQL_EXEC_ID, trace_id TRACE_ID, session_id SID, client_ip CLIENT_IP, client_port CLIENT_PORT, tenant_id TENANT_ID, effective_tenant_id EFFECTIVE_TENANT_ID, tenant_name TENANT_NAME, user_id USER_ID, user_name USER_NAME, user_group as USER_GROUP, user_client_ip as USER_CLIENT_IP, db_id DB_ID, db_name DB_NAME, sql_id SQL_ID, query_sql QUERY_SQL, plan_id PLAN_ID, affected_rows AFFECTED_ROWS, return_rows RETURN_ROWS, partition_cnt PARTITION_CNT, ret_code RET_CODE, qc_id QC_ID, dfo_id DFO_ID, sqc_id SQC_ID, worker_id WORKER_ID, event EVENT, p1text P1TEXT, p1 P1, p2text P2TEXT, p2 P2, p3text P3TEXT, p3 P3, "LEVEL" "LEVEL", wait_class_id WAIT_CLASS_ID, "WAIT_CLASS#" "WAIT_CLASS#", wait_class WAIT_CLASS, state STATE, wait_time_micro WAIT_TIME_MICRO, total_wait_time_micro TOTAL_WAIT_TIME_MICRO, total_waits TOTAL_WAITS, rpc_count RPC_COUNT, plan_type PLAN_TYPE, is_inner_sql IS_INNER_SQL, is_executor_rpc IS_EXECUTOR_RPC, is_hit_plan IS_HIT_PLAN, request_time REQUEST_TIME, elapsed_time ELAPSED_TIME, net_time NET_TIME, net_wait_time NET_WAIT_TIME, queue_time QUEUE_TIME, decode_time DECODE_TIME, get_plan_time GET_PLAN_TIME, execute_time EXECUTE_TIME, application_wait_time APPLICATION_WAIT_TIME, concurrency_wait_time CONCURRENCY_WAIT_TIME, user_io_wait_time USER_IO_WAIT_TIME, schedule_time SCHEDULE_TIME, row_cache_hit ROW_CACHE_HIT, bloom_filter_cache_hit BLOOM_FILTER_CACHE_HIT, block_cache_hit BLOCK_CACHE_HIT, block_index_cache_hit BLOCK_INDEX_CACHE_HIT, disk_reads DISK_READS, retry_cnt RETRY_CNT, table_scan TABLE_SCAN, consistency_level CONSISTENCY_LEVEL, memstore_read_row_count MEMSTORE_READ_ROW_COUNT, ssstore_read_row_count SSSTORE_READ_ROW_COUNT, request_memory_used REQUEST_MEMORY_USED, expected_worker_count EXPECTED_WORKER_COUNT, used_worker_count USED_WORKER_COUNT, sched_info SCHED_INFO, ps_client_stmt_id as PS_CLIENT_STMT_ID, ps_inner_stmt_id as PS_INNER_STMT_ID, transaction_hash TRANSACTION_HASH, request_type as REQUEST_TYPE, is_batched_multi_stmt as IS_BATCHED_MULTI_STMT, ob_trace_info as OB_TRACE_INFO, plan_hash as PLAN_HASH, params_value as PARAMS_VALUE FROM SYS.ALL_VIRTUAL_SQL_AUDIT WHERE TENANT_ID = SYS_CONTEXT('USERENV', 'CON_ID')

 

 

 

#######sample 3

 

 

最快免费方案：Dify + Ollama(Qwen2.5-7B) + 您的37个文档。一台普通电脑，30分钟搭好，永久免费使用。