# Oracle Database Oracle Database is a relational database management system that extends the relational model to an object-relational model. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## Percona and HexaCluster: Faster, Safer Oracle Migration DevFeed: [Percona and HexaCluster: Faster, Safer Oracle Migration]() Original publisher: [Read original article]() Author: Percona Team Published: 2026-09-14T22:19:16Z Content type: article Language: en Sources: [Blog - Percona]() Topics: [Oracle Database](), [migration](), [Open Source](), [PostgreSQL](), [Database Migration](), [Replication](), [Tooling]() Tags: [database](), [database-migration](), [database-trends](), [engineering](), [insight-for-dbas](), [insight-for-developers](), [migration](), [open-source](), [oracle](), [partners](), [percona](), [postgresql](), [replication](), [schema](), [sql](), [tooling](), [validation]() ### AI overview Percona and HexaCluster describe a partnership for moving organizations from Oracle, SQL Server, DB2, and Sybase ASE to supported open source databases, primarily PostgreSQL. HexaCluster provides assessment and migration engineering through DMAT and HexaRocket, while Percona provides distributions, operators, and long-term support. HexaRocket combines schema migration, data migration, validation, change data capture, live replication, and reverse replication in one platform. ### Source excerpt Percona and HexaCluster have partnered to remove the hardest part of an open source database migration: getting off Oracle, SQL Server, DB2 or Sybase ASE with confidence, on a predictable timeline, without a multi-year consulting program. Percona brings open source expertise, its own distributions, operators and enterprise support. HexaCluster brings the assessment and migration engineering ... Continued The post Percona and HexaCluster: Faster, Safer Oracle Migration appeared first on Percona. ## Getting started with Oracle Database@AWS: A complete onboarding guide DevFeed: [Getting started with Oracle Database@AWS: A complete onboarding guide]() Original publisher: [Read original article]() Author: Raghu Soma Published: 2026-09-08T16:59:29Z Content type: tutorial Language: en Sources: [AWS Database Blog]() Topics: [Oracle Database](), [cloud-infrastructure](), [AWS IAM]() Tags: [aws](), [aws-marketplace](), [best-practices](), [database](), [guide](), [iam](), [infrastructure](), [intermediate-200](), [onboarding](), [oracle](), [oracle-database-aws]() ### AI overview A step-by-step guide to onboarding Oracle Database@AWS, covering service selection, AWS Marketplace offers, prerequisites, OCI tenancy linking, and IAM configuration before provisioning. ### Source excerpt A practical, step-by-step guide to getting Oracle Database@AWS up and running. It covers the five procurement and onboarding steps, from securing your AWS Marketplace offer through validating prerequisites, linking your OCI tenancy, and configuring IAM, so you can move from purchase to a provisioning-ready environment. ## Characterizing SQL\*Net latency in your application for Oracle Database@AWS migrations DevFeed: [Characterizing SQL\*Net latency in your application for Oracle Database@AWS migrations]() Original publisher: [Read original article]() Author: Sameer Malik Published: 2026-08-18T18:17:28Z Content type: article Language: en Sources: [AWS Database Blog]() Topics: [Oracle Database](), [Latency](), [migration](), [Amazon Web Services](), [Database](), [Network]() Tags: [advanced-300](), [amazon-ec2](), [amazon-elastic-container-service](), [amazon-elastic-kubernetes-service](), [amazon-vpc](), [aws](), [best-practices](), [database](), [latency](), [migration](), [network](), [oracle](), [oracle-database-aws](), [performance]() ### AI overview This article presents a methodology for assessing SQL*Net latency sensitivity before migrating Oracle workloads to Oracle Database@AWS. It focuses on identifying workloads with fast, frequent, and concentrated SQL activity, then quantifying the impact of added network round-trip latency in a multi-cloud architecture. It also discusses reducing client-server round trips through stored procedures, array fetches, and bulk processing. ### Source excerpt Oracle Database@AWS places Oracle Exadata infrastructure inside AWS data centers, so SQL*Net latency between your application and the database can change after migration. This post presents the CRET methodology, a three-phase approach using AWR, Active Session History, and SQL Trace, to identify latency-sensitive SQL and quantify the impact before you migrate. ## Stream Oracle changes to ClickHouse in real time DevFeed: [Stream Oracle changes to ClickHouse in real time]() Original publisher: [Read original article]() Author: Prakhar Garg Published: 2026-07-07T00:00:00Z Content type: tutorial Language: en Sources: [Redpanda]() Topics: [clickhouse](), [Redpanda-Connect](), [Oracle Database](), [Kafka](), [real-time](), [data](), [Database](), [YAML]() Tags: [clickhouse](), [connectors](), [data](), [database](), [event](), [integration](), [kafka](), [oracle](), [pipeline](), [real-time](), [redpanda-connect](), [schema](), [yaml]() ### AI overview A hands-on walkthrough shows how to stream Oracle change data capture events through Redpanda Connect into ClickHouse in real time. It uses Oracle LogMiner and YAML-configured pipelines, with a Redpanda topic serving as an intermediate store before data is delivered to ClickHouse or other destinations. ### Source excerpt A hands-on walkthrough of the new Oracle input in Redpanda Connect. No Debezium, no Kafka Connect runtime, no JVM. ## Why Oracle and Amazon Aurora May Strain Under Cloud-Scale Workloads DevFeed: [Why Oracle and Amazon Aurora May Strain Under Cloud-Scale Workloads]() Original publisher: [Read original article]() Author: David Weiss Published: 2026-01-16T00:00:00Z Content type: article Language: en Sources: [Cockroach Labs]() Topics: [Oracle Database](), [Amazon Aurora](), [Cloud](), [Databases](), [Availability](), [consistency](), [systems](), [Deployment]() Tags: [alternatives](), [amazon-aurora](), [architecture](), [availability](), [cloud](), [consistency](), [deployment](), [distributed](), [oracle](), [performance]() ### AI overview The article argues that Oracle and Amazon Aurora were designed around architectural assumptions that can constrain modern cloud-scale workloads. It outlines requirements including global availability, horizontal scaling for reads and writes, strong cross-region consistency, zero-downtime operations, and flexible deployment. ### Source excerpt Oracle and Amazon Aurora continue to power many mission-critical applications. As cloud-scale workloads evolve, however, the definition of "enterprise-ready" has fundamentally shifted. ## How to map the Oracle TIMESTAMP WITH TIME ZONE with JPA DevFeed: [How to map the Oracle TIMESTAMP WITH TIME ZONE with JPA]() Original publisher: [Read original article]() Author: vladmihalcea Published: 2025-03-18T16:21:37Z Content type: tutorial Language: en Sources: [Vlad Mihalcea]() Topics: [Oracle Database](), [Java](), [SQL]() Tags: [article](), [hibernate](), [how-to](), [java](), [jpa](), [mapping](), [offsetdatetime](), [oracle](), [sql](), [timezone](), [types](), [zoneddatetime]() ### AI overview A tutorial on mapping Oracle TIMESTAMP WITH TIME ZONE columns to Java date-time types using JPA and Hibernate. It explains how ZonedDateTime and OffsetDateTime correspond to the Oracle column type and how to preserve time zone region information when retrieving values. ### Source excerpt Introduction In this article, I'm going to explain how to map the Oracle TIMESTAMP WITH TIME ZONE with JPA and Hibernate. While the DATE and TIMESTAMP column types are suitable for mapping the LocalDateTime, the TIMESTAMP WITH TIME ZONE column type allows us to map both the ZonedDateTime and OffsetDateTime. Oracle TIMESTAMP WITH TIME ZONE Traditionally, Oracle provided the DATE and TIMESTAMP column types to store timestamp values. The difference between the DATE and TIMESTAMP types is that the TIMESTAMP column type allows us to store fractional seconds while the DATE type... Read More The post How to map the Oracle TIMESTAMP WITH TIME ZONE with JPA appeared first on Vlad Mihalcea. ## jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more DevFeed: [jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more]() Original publisher: [Read original article]() Author: lukaseder Published: 2025-02-20T10:27:54Z Content type: release Language: en Sources: [jOOQ]() Topics: [clickhouse](), [databricks](), [SQL](), [DuckDB](), [modules](), [Oracle Database](), [Kotlin](), [Scala](), [reactive](), [jpa]() Tags: [array](), [clickhouse](), [databricks](), [decfloat](), [dirty-tracking](), [dml-join](), [duckdb](), [hidden-columns](), [jdk-21](), [jooq](), [jooq-3-20](), [jooq-development](), [jpa](), [json](), [kotlin](), [kotlin-2](), [merge](), [modules](), [oracle](), [oracle-plsql-types](), [r2dbc](), [reactive](), [scala](), [scala-3](), [sequences](), [spatial](), [sql]() ### AI overview jOOQ 3.20 introduces experimental ClickHouse and Databricks SQL dialects, improves DuckDB support, adds new integration modules, and expands support for Oracle type hierarchies, spatial features, decfloat, synonyms, hidden columns, Scala 3, and Kotlin 2. ### Source excerpt New dialects: jOOQ 3.20 ships with 2 new experimental dialects: ClickHouse is a fast-moving SQL dialect with a historic vendor-specific syntax that is gradually migrated to a more standards compliant alternative, which is why our support is still experimental. A lot of behaviours differ from what one would expect elsewhere, including NULL handling, which is ... Continue reading jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more -> ## Emulating SQL FILTER with Oracle JSON Aggregate Functions DevFeed: [Emulating SQL FILTER with Oracle JSON Aggregate Functions]() Original publisher: [Read original article]() Author: lukaseder Published: 2024-06-03T12:17:41Z Content type: article Language: en Sources: [jOOQ]() Topics: [Oracle Database](), [SQL](), [JSON]() Tags: [aggregate-functions](), [filter](), [filter-clause](), [jooq-3-20](), [json](), [json-aggregate-functions](), [json-arrayagg](), [json-objectagg](), [oracle](), [sql](), [sql-json]() ### AI overview This article explains how to emulate the SQL FILTER clause for JSON aggregate functions, particularly in Oracle. It presents a workaround that wraps legitimate data in arrays, filters out emulation-generated rows, and then unwraps the arrays. jOOQ 3.20 will implement these emulations. ### Source excerpt A cool standard SQL:2003 feature is the aggregate FILTER clause, which is supported natively by at least these RDBMS: The following aggregate function computes the number of rows per group which satifsy the FILTER clause: This is useful for pivot style queries, where multiple aggregate values are computed in one go. For most basic types ... Continue reading Emulating SQL FILTER with Oracle JSON Aggregate Functions -> ## Teleport 14 DevFeed: [Teleport 14]() Original publisher: [Read original article]() Author: ben@goteleport.com (Ben Arent) Published: 2023-09-25T00:00:00Z Content type: release Language: en Sources: [Teleport]() Topics: [releases](), [Release notes](), [Logging](), [Amazon S3](), [Kubernetes](), [Kubernetes clusters](), [Oracle Database](), [web applications](), [Terraform](), [Discord](), [Slack](), [okta]() Tags: [amazon-s3](), [announcement](), [audit](), [kubernetes](), [logging](), [product-updates](), [release](), [release-notes](), [releases](), [ui]() ### AI overview Teleport 14 is a major release featuring a unified resource view, access lists, an advanced audit log backend powered by Amazon S3 and Athena, Kubernetes application auto-discovery, extended Kubernetes resource RBAC, Oracle database access audit logging, and additional integrations and deployment updates. ### Source excerpt A deep dive into Teleport 14: unified resource view, Access Lists, Advanced Audit Log, Kubernetes Apps Auto-Discovery, extended RBAC, Oracle Audit Logging, and more. ## 3.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0 DevFeed: [3.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0]() Original publisher: [Read original article]() Author: lukaseder Published: 2023-03-08T16:34:56Z Content type: release Language: en Sources: [jOOQ]() Topics: [releases](), [SQL](), [JSON](), [Oracle Database](), [PostgreSQL](), [Kotlin]() Tags: [jdbc](), [jooq](), [kotlin](), [oracle](), [r2dbc](), [release](), [sql](), [sql-json](), [uncategorized]() ### AI overview jOOQ 3.18.0 is a release focused on expanded SQL diagnostics and SQL/JSON support, including vendor-specific MySQL and PostgreSQL features. It also adds improvements for the Query Object Model, Oracle associative arrays, PostgreSQL multidimensional arrays, Kotlin, and R2DBC 1.0. ### Source excerpt DiagnosticsListener improvements A lot of additional diagnostics have been added, including the automated detection of pattern replacements, helping you lint your SQL queries irrespective of whether you're using jOOQ to write your SQL, or if you're using it as a JDBC / R2DBC proxy for an existing application. A lot of these diagnostics are available ... Continue reading 3.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0 -> ## Calling Procedures with Default Parameters using JDBC or jOOQ DevFeed: [Calling Procedures with Default Parameters using JDBC or jOOQ]() Original publisher: [Read original article]() Author: lukaseder Published: 2022-10-21T14:35:39Z Content type: tutorial Language: en Sources: [jOOQ]() Topics: [Code](), [Reason](), [SQL](), [Oracle Database](), [PostgreSQL]() Tags: [db2](), [default-parameters](), [java](), [jdbc](), [jooq](), [jooq-in-use](), [oracle](), [pl-pgsql](), [pl-sql](), [postgresql](), [sql-server](), [stored-functions](), [stored-procedures](), [syntax]() ### AI overview This tutorial explains how to call stored procedures with default parameters using JDBC or jOOQ. It shows how directly instantiating a procedure call allows Java code to omit parameters that have database-side defaults, and notes that syntax varies across supported relational database systems. ### Source excerpt Using jOOQ's code generator to call stored procedures is a popular reason to use jOOQ. For example, when you have a procedure like the following Oracle PL/SQL procedure: jOOQ will generate code for you to call very simply, like this: This will execute the following, taking care of binding all IN and OUT parameters for ... Continue reading Calling Procedures with Default Parameters using JDBC or jOOQ -> ## Intro to SQL for the New Grad Developer DevFeed: [Intro to SQL for the New Grad Developer]() Original publisher: [Read original article]() Author: Brandon Raboy Published: 2022-06-08T13:00:00Z Content type: tutorial Language: en Sources: [Nic Raboy]() Topics: [SQL](), [Databases](), [MySQL](), [Oracle Database](), [PostgreSQL](), [sql-server]() Tags: [databases](), [developer](), [guide](), [mysql](), [oracle](), [postgresql](), [rdbms](), [sql](), [sql-server](), [syntax]() ### AI overview A beginner-oriented guide to SQL for new graduate developers. It explains SQL's role in accessing and manipulating databases, surveys MySQL, PostgreSQL, Oracle, and SQL Server, and introduces syntax differences, EXPLAIN, query runtime, and example problems. ### Source excerpt Ever since studying and working with databases 6 months ago, I've become fascinated with SQL and its relatively simple syntax. As a guide to the reader, I've gathered the essential criteria that emplo... The post Intro to SQL for the New Grad Developer appeared first on The Polyglot Developer. ## Entity Framework: Intercepting SQL Queries for Contextual Logging DevFeed: [Entity Framework: Intercepting SQL Queries for Contextual Logging]() Original publisher: [Read original article]() Published: 2013-03-21T00:00:00Z Content type: tutorial Language: en Sources: [Juri Strumpflohner]() Topics: [Framework](), [SQL](), [Logging](), [Oracle Database](), [NuGet]() Tags: [framework](), [logging](), [nuget](), [oracle](), [sql]() ### AI overview This tutorial describes using MiniProfiler to intercept Entity Framework SQL queries and include the executed SQL statement as contextual information in production error logs. The example involves diagnosing an intermittent insufficient-privileges exception against an Oracle database. ### Source excerpt Lorem ipsum dolor sit amet