Home » SQL & PL/SQL » SQL & PL/SQL » MV/snapshot refresh
icon5.gif  MV/snapshot refresh [message #235560] Mon, 07 May 2007 03:31 Go to next message
sbrbot
Messages: 5
Registered: August 2006
Location: Croatia
Junior Member

I created materialized view (snapshot) on Oracle 10g (refresh type=COMPLETE) which should refresh itself each Sunday by night. How one can chech when last successful refresh occured and how long it lasted?
Re: MV/snapshot refresh [message #235569 is a reply to message #235560] Mon, 07 May 2007 04:17 Go to previous message
sbrbot
Messages: 5
Registered: August 2006
Location: Croatia
Junior Member

I found it:
SELECT
 job,
 log_user,
 schema_user,
 last_date,
 next_date,
 total_time,
 broken,
 failures,
 what
FROM
 user_jobs;

Previous Topic: Function overloading
Next Topic: Lock row and notify to other computer
Goto Forum:
  


Current Time: Tue Dec 06 06:40:05 CST 2016

Total time taken to generate the page: 0.09147 seconds