Home » SQL & PL/SQL » SQL & PL/SQL » Calculate Materialized view Refresh time (oracle 10g,oracle 11g)
Calculate Materialized view Refresh time [message #572419] Tue, 11 December 2012 20:56 Go to next message
y.michaelholding
Messages: 5
Registered: December 2012
Junior Member
Hi,

i want to find out the last refresh elasped time for materalized view. i do not see last refresh elapsed time in data dictionary. i see only last refresh date in data dictionary.

Please help me how to find the last refresh elapsed time for materalized view.

Report message to a moderator

Re: Calculate Materialized view Refresh time [message #572433 is a reply to message #572419] Wed, 12 December 2012 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 54167
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This information is not available.

Regards
Michel

Report message to a moderator

Re: Calculate Materialized view Refresh time [message #572468 is a reply to message #572433] Wed, 12 December 2012 04:56 Go to previous messageGo to next message
Flyby
Messages: 120
Registered: March 2011
Location: Belgium
Senior Member
Make an oracle scheduled job that will refresh the MV, scheduled jobs (DBMS_SCHEDULER) have logs so you can view how long it took.

Report message to a moderator

Re: Calculate Materialized view Refresh time [message #572470 is a reply to message #572468] Wed, 12 December 2012 05:00 Go to previous message
Michel Cadot
Messages: 54167
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...or modify your job so that it records its own execution time (and other session parameters if you want).

Regards
Michel

Report message to a moderator

Previous Topic: convert the given sql to procedure
Next Topic: Can a oracle database Function return Images?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 17:47:45 CDT 2013

Total time taken to generate the page: 0.95998 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.