OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Document Feedback

SET_SYSTEM_DEFAULT

Last Updated：2026-04-15 08:25:15 Updated

The SET_SYSTEM_DEFAULT procedure sets the default values of refresh statistics parameters.

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.

Syntax

DBMS_MVIEW_STATS.SET_SYSTEM_DEFAULT (
		parameter_name	    IN   VARCHAR2,
		value               IN   VARCHAR2);

DBMS_MVIEW_STATS.SET_SYSTEM_DEFAULT (
		parameter_name	    IN   VARCHAR2,
		value               IN   NUMBER);

Parameters

Parameter	Description
parameter_name	The parameter name. Valid values: `COLLECTION_LEVEL`: the statistics collection level. The default value is `TYPICAL`. `RETENTION_PERIOD`: the retention period (in days) of statistics. The default value is 31 days.
value	When `parameter_name` is `COLLECTION_LEVEL`, the parameter value indicates the collection level. Valid values: `NONE`: specifies not to collect statistics. `TYPICAL`: specifies to collect basic refresh statistics. `ADVANCED`: specifies to collect detailed refresh statistics. `NULL`: specifies to use the default value, that is, `TYPICAL`. When `parameter_name` is `RETENTION_PERIOD`, the parameter value indicates the retention period (in days) of statistics, which ranges from 1 to 365,000 days. `NULL`: specifies to use the default value. `-1`: specifies to permanently retain statistics.

Parameter

Description

parameter_name

The parameter name. Valid values:

COLLECTION_LEVEL: the statistics collection level. The default value is TYPICAL.

RETENTION_PERIOD: the retention period (in days) of statistics. The default value is 31 days.

value

When parameter_name is COLLECTION_LEVEL, the parameter value indicates the collection level. Valid values:

NONE: specifies not to collect statistics.

TYPICAL: specifies to collect basic refresh statistics.

ADVANCED: specifies to collect detailed refresh statistics.

NULL: specifies to use the default value, that is, TYPICAL.

When parameter_name is RETENTION_PERIOD, the parameter value indicates the retention period (in days) of statistics, which ranges from 1 to 365,000 days.

NULL: specifies to use the default value.

-1: specifies to permanently retain statistics.

Previous topic

SET_MVREF_STATS_PARAMS

Last

Next topic

Overview