--- title: "#oracle-23ai articles | Hashnode" description: "Explore 34 articles tagged #oracle-23ai on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/oracle-23ai" --- Tag # #oracle-23ai 34 posts · 1 followers [Phil Grinham](https://hashnode.com/@PhilGrinham) · [Jun 30](https://hashnode.com/posts/materialized-views-the-sweet-spot/6a453454fbfc9f1ee09e7f17) ### [Materialized Views: The Sweet Spot](https://philgrinham.hashnode.dev/materialized-views-the-sweet-spot?utm_source=hashnode&utm_medium=feed) The Inspiration I recently read an article from the always excellent Connor McDonald that I highly recommend where he provided a solution on how to maintain a materialized view that needs to be "up to 9 min read · [philgrinham.hashnode.dev](https://philgrinham.hashnode.dev/materialized-views-the-sweet-spot?utm_source=hashnode&utm_medium=feed) [Ryan Giggs](https://hashnode.com/@Derrick-Ryan-Giggs) · [Mar 16](https://hashnode.com/posts/oracle-database-23ai-vector-similarity-search-exact-approximate-and-multi-vector-strategies/69b7c6506ca8e7d49b9b60fd) ### [Oracle Database 23ai: Vector Similarity Search - Exact, Approximate, and Multi-Vector Strategies](https://ryan-giggs.hashnode.dev/oracle-database-23ai-vector-similarity-search-exact-approximate-and-multi-vector-strategies?utm_source=hashnode&utm_medium=feed) Oracle Database 23ai's AI Vector Search provides multiple strategies for finding similar vectors, each with different trade-offs between accuracy, speed, and resource usage. Understanding when to use 12 min read · [ryan-giggs.hashnode.dev](https://ryan-giggs.hashnode.dev/oracle-database-23ai-vector-similarity-search-exact-approximate-and-multi-vector-strategies?utm_source=hashnode&utm_medium=feed) [Ryan Giggs](https://hashnode.com/@Derrick-Ryan-Giggs) · [Mar 9](https://hashnode.com/posts/oracle-database-23ai-creating-vectors-and-understanding-distance-metrics-for-similarity-search/69ae7cb145e043be6265edb2) ### [Oracle Database 23ai: Creating Vectors and Understanding Distance Metrics for Similarity Search](https://ryan-giggs.hashnode.dev/oracle-database-23ai-creating-vectors-and-understanding-distance-metrics-for-similarity-search?utm_source=hashnode&utm_medium=feed) Oracle Database 23ai introduces native vector capabilities that enable semantic search directly within SQL. Understanding how to create vectors, calculate distances, and choose appropriate metrics is 12 min read · [ryan-giggs.hashnode.dev](https://ryan-giggs.hashnode.dev/oracle-database-23ai-creating-vectors-and-understanding-distance-metrics-for-similarity-search?utm_source=hashnode&utm_medium=feed) [Wojciech Sowa](https://hashnode.com/@mrsowa) · [Feb 17](https://hashnode.com/posts/the-likely-obvious-oracle-tip-9/699461c3a6b88e7bf4fc6822) ### [The Likely Obvious Oracle Tip #9](https://wsowa.hashnode.dev/the-likely-obvious-oracle-tip-9?utm_source=hashnode&utm_medium=feed) Discover GROUP BY clause new features introduced in Oracle Database 23/26ai. Grouping by column alias, position and GROUP BY ALL. 2 min read · [wsowa.hashnode.dev](https://wsowa.hashnode.dev/the-likely-obvious-oracle-tip-9?utm_source=hashnode&utm_medium=feed) [David Sanz](https://hashnode.com/@sanzmaci) · [Jan 13](https://hashnode.com/posts/oci-proxy-pdb/6966a27b98812ba1fe2bf5a6) ### [\[OCI\] Proxy PDB](https://dbaenlasombra.com/oci-proxy-pdb?utm_source=hashnode&utm_medium=feed) El artículo también se encuentra publicado en Ingles English version. En el artículo de hoy, vamos a ver las Proxy PDB. Pero, ¿Qué es un proxy PDB? Es hacer referencia a otra PDB pero de manera remota o en mismo CDB. Podríamos decir que es algo simil... 4 min read · [dbaenlasombra.com](https://dbaenlasombra.com/oci-proxy-pdb?utm_source=hashnode&utm_medium=feed) [David Sanz](https://hashnode.com/@sanzmaci) · [Jan 13](https://hashnode.com/posts/oci-proxy-pdb/6966a1c4a60fa880b55582a7) ### [\[OCI\] Proxy PDB](https://dbaintheshadow.com/oci-proxy-pdb?utm_source=hashnode&utm_medium=feed) If you prefer to read in Spanish Spanish version. Today, we’re going to talk about Proxy PDB. So, what is a Proxy PDB? Basically, it’s when one PDB references another PDB remotely, or even within the same CDB. It works like DB Links, but in this case... 3 min read · [dbaintheshadow.com](https://dbaintheshadow.com/oci-proxy-pdb?utm_source=hashnode&utm_medium=feed) [Mauricio Muñoz Palma](https://hashnode.com/@LaboticadelDBA) · [Oct 23, 2025](https://hashnode.com/posts/2326-26ai-que-cambia-y-por-que-deberia-importarte-como-dba/68fa92d22b223b6ce7414064) ### [23.26 → 26ai: ¿qué cambia y por qué debería importarte como DBA?](https://laboticadeldba.com/2326-26ai-que-cambia-y-por-que-deberia-importarte-como-dba?utm_source=hashnode&utm_medium=feed) Oracle transforma 23ai en Oracle AI Database 26ai aplicando el Release Update 23.26.0. Resumen práctico y mini-checklist para DBAs. 2 min read · [laboticadeldba.com](https://laboticadeldba.com/2326-26ai-que-cambia-y-por-que-deberia-importarte-como-dba?utm_source=hashnode&utm_medium=feed) [David Sanz](https://hashnode.com/@sanzmaci) · [Oct 4, 2025](https://hashnode.com/posts/23ai-shadow-tablespaces/68e157d93b022f3c1ce4f3f8) ### [\[23ai\] Shadow Tablespaces](https://dbaenlasombra.com/23ai-shadow-tablespaces?utm_source=hashnode&utm_medium=feed) El artículo también se encuentra publicado en Ingles English version. En el artículo de hoy vamos hablar sobre un tipo de tablespace que se “encuentran” nunca mejor dicho, en la sombra de la página oficial de Oracle, son los Shadow Tablespaces. Este ... 4 min read · [dbaenlasombra.com](https://dbaenlasombra.com/23ai-shadow-tablespaces?utm_source=hashnode&utm_medium=feed) [David Sanz](https://hashnode.com/@sanzmaci) · [Oct 4, 2025](https://hashnode.com/posts/23ai-shadow-tablespaces/68e156e43d8b9f30cf926295) ### [\[23ai\] Shadow Tablespaces](https://dbaintheshadow.com/23ai-shadow-tablespaces?utm_source=hashnode&utm_medium=feed) If you prefer to read in Spanish Spanish version. The otherr day, while I was reading the Oracle’s website, I came across a type of tablespace that I wasn’t familiar with. It’s called “Shadow Tablespaces”. It’s not a feature in 23ai, so it was introd... 4 min read · [dbaintheshadow.com](https://dbaintheshadow.com/23ai-shadow-tablespaces?utm_source=hashnode&utm_medium=feed) [David Sanz](https://hashnode.com/@sanzmaci) · [Sep 5, 2025](https://hashnode.com/posts/23ai-instalacion-de-oracle23ai-en-oralinux9/68baac91f0182b3dd8989325) ### [\[23ai\] Instalación de Oracle23ai en OraLinux9](https://dbaenlasombra.com/23ai-instalacion-de-oracle23ai-en-oralinux9?utm_source=hashnode&utm_medium=feed) El artículo también se encuentra publicado en Ingles English version. En este pequeño artículo, vamos a ver a definir una base de datos 23ai con Oracle Database Configuration Assistant (DBCA). Para poder hacer este laboratorio me he creado un IaaS en... 8 min read · [dbaenlasombra.com](https://dbaenlasombra.com/23ai-instalacion-de-oracle23ai-en-oralinux9?utm_source=hashnode&utm_medium=feed)