AI, Oracle, Performance

Oracle AI Cheat Sheet

by jb

This blog post contains some random Oracle commands or SQL statements to have them at hand when using Oracle and AI.

General

# show all embedding models available in the database (loaded with DBMS_VECTOR.LOAD_ONNX_MODEL)
select * from dba_mining_models;
# show all Oracle Text Hybrid Vector Indexes
# idx_vector_type: HNSW=Hierarchical Navigable Small World (HNSW) IVF=Inverted File Flat
select idx_name, idx_table_owner, idx_table, idx_status, idx_type, idx_sub_type, idx_vector_type, idx_model_owner, idx_model_name from ctx_user_indexes;
# Oracle Text: create Hybrid Vector Index (IVF):
create hybrid vector index my_hybrid_idx on dba_error_kb(error_desc) parameters ('model e5');
# Oracle Text: create Hybrid Vector Index (HNSW):
create hybrid vector index my_hybrid_idx_hnsw on dba_error_kb(error_desc) parameters ('model e5 vector_idxtype hnsw');

0