Posts

aaa

Oracle AI Database 26ai(23.26.4): Streaming Windowing Table Functions

Image
  Analyzing time-based data is a common requirement in modern database applications. Oracle AI Database 26ai(RU 23.26.4) introduces four SQL streaming windowing table functions that simplify this type of analysis by dividing table rows into time-based windows. These functions are: TUMBLE: Divides rows into consecutive, non-overlapping time windows. HOP: Creates sliding time windows that can overlap or have gaps. CUMULATE: Creates expanding time windows with a common starting point. SESSIONS: Groups rows into sessions based on the time interval between consecutive events. Each function accepts a datetime column and interval parameters to determine how rows are assigned to windows. The returned result includes two additional columns, WINDOW_START and WINDOW_END , which identify the time boundaries of each window. In this article, we will explore how these four functions work and demonstrate their practical applications using customer activity data. 1. How Streaming Windowing Fun...

Oracle AI Database 26ai: Does ROW_MOVEMENT_DEFAULT Work in Enterprise Edition?

Image
  Oracle AI Database 26ai introduced the ROW_MOVEMENT_DEFAULT initialization parameter in RU 23.26.2 to control whether row movement is enabled by default for new tables. I tested this feature on Oracle AI Database 26ai Enterprise Edition — 23.26.4.0 .0 . The parameter does not enable row movement by default in Enterprise Edition. My test: Oracle AI Database 26 ai Enterprise Edition Release 23.26 .4 .0 .0 - Production Version 23.26 .4 .0 .0 SQL > alter system set row_movement_default = ENABLED; System altered. SQL > show parameter row_movement_default NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ row_movement_default string ENABLED SQL > CREATE TABLE vahid.customers ( customer_id NUMBER, name VARCHAR2( 14 ), last_name VARCHAR2( 14 ), registration_date DATE ) PARTITION BY RANGE (registration_date) ( PARTITION customers_2024 VALUES LESS THAN ( DATE '2025-01-01' ), PARTITION customers_2025 VALUES ...