REFRESH_REPORT|V5.0.1|OceanBase Database|docs|OceanBase Documentations

For V5.x versions, REFRESH_REPORT was introduced starting with V5.0.1.

REFRESH_REPORT is used to generate a hierarchical diagnostic report for a single materialized view refresh task.

Limitations and considerations

Specify at least one of refresh_id and mv_name.

DBMS_MVIEW.REFRESH_REPORT(
    refresh_id,
    mv_name,
    tenant_id,
    format)

Parameter	Note
refresh_id	The unique identifier of a materialized view refresh batch, assigned by the new scheduling framework. Note You can view the `refresh_id` information through the DBA_MVREF_RUN_STATS view.
mv_name	Specify the name of the materialized view (for example,`SCHEMA.MV_NAME`).
format	Optional. Specifies the report output format. Valid values: `XML`(Default) `JSON`
tenant_id	Currently only`sys`Tenant available, used to query the materialized view refresh reports of other tenants.

Return type: CLOB.
Content format: Depends on the format parameter. It can be text in XML or JSON format.

Retrieve the diagnostic report in XML format by using the refresh_id.
```
obclient> SELECT DBMS_MVIEW.REFRESH_REPORT(100023);
```

Obtain a report in JSON format.

obclient> SELECT DBMS_MVIEW.REFRESH_REPORT(100023, NULL, NULL, 'JSON');

Retrieve the most recently refreshed report by its name.

obclient> SELECT DBMS_MVIEW.REFRESH_REPORT(NULL, 'TEST.MV_SALES_DAILY');

Query the refresh report of other tenants in the sys tenant.

obclient> SELECT DBMS_MVIEW.REFRESH_REPORT(100023, NULL, 1002);