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.
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: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This information is not available.

Regards
Michel
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: 139
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.
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: 57613
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
Previous Topic: convert the given sql to procedure
Next Topic: Can a oracle database Function return Images?
Goto Forum:
  


Current Time: Sun Apr 20 12:47:51 CDT 2014

Total time taken to generate the page: 0.04986 seconds