When was materialized view last refreshed

Submit Search. You are here:. Oracle Materialized View Intervals Test A materialized view is a database object that contains the results of a query. Note: For this test to report metrics, the database should contain at least one materialized view.

Target of the test : An Oracle server Agent deploying the test : An internal agent Outputs of the test : One set of results for the Oracle server being monitored. Configurable parameters for the test TEST PERIOD - How often should the test be executed Host — The host for which the test is to be configured Port - The port on which the server is listening User — In order to monitor an Oracle database server, a special database user account has to be created in every Oracle database instance that requires monitoring.

Confirm password — Confirm the password by retyping it here. No alerts will be generated if the server is not running. Measurements made by the test Measurement Description Measurement Unit Interpretation Last refresh: Indicates the duration of time elapsed since the materialized view was last refreshed. Information Schema , Table Functions.

Enterprise Edition Feature. Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support. Converting to old-style outer join syntax:. Materialized Views - Identifying the last refresh. Asked 4 Months ago Answers: 5 Viewed 21 times. You will have to create a unique index on the materialized view itself. From the documentation: When you create a materialized view, Oracle Database creates one internal table and at least one index, and may create one view, all in the schema of the materialized view.

Based on the definition to added to the question later, it will refresh every day at midnight. A quick test to see that it works The ANSI-join syntax restriction is mentioned in point 6 in this blogpost. Regards, Rob. OMG Ponies k 75 75 gold badges silver badges bronze badges.

Scott Scott 1 1 gold badge 3 3 silver badges 4 4 bronze badges. Specifically what version of Oracle? As you might have guessed I don't have that much experience with oracle.

OMG Ponies I believe we have 9. If you could not see the mv you are interested in.. Show 3 more comments. Active Oldest Votes. Improve this answer. Justin Cave Justin Cave k 22 22 gold badges silver badges bronze badges. Add a comment. I was wondering if the date was longer.

Thanks for the additional answer.