Skip to content

Keep calm and talk about Oracle.

Skip to content
  • Home

> /* MV_REFRESH (DEL) */

/* MV_REFRESH (DEL) */

Frequent and Fast Refresh Materialized Views has a Big Problem!

Published on: 2020-07-252020-07-25 by Mustafa Comment

Hi, While I was checking V$SQL_PLAN view for a whole different reason, I realized that some of the cursors has incredibly high child cursors. I started to dig and finally I find the problem. My customer have a few frequently fast refreshed materialized views. One of them is refreshed every 10 seconds (you might say […]

Search for:

Recent Posts

  • ORA-24244: invalid host or port for access control list (ACL) assignment
  • export import ACL & ORA-24244 error during import
  • Which Column has Changed in Every Row?
  • SQL Macro Part2 column_value = nvl(:param, column_value)
  • SQL Macro is finally here!

Recent Comments

  • Mustafa on Goodbye Log Triggers Welcome Flashback Data Archive
  • Madhan on Goodbye Log Triggers Welcome Flashback Data Archive
  • Mustafa on Goodbye Log Triggers Welcome Flashback Data Archive
  • Madhan on Goodbye Log Triggers Welcome Flashback Data Archive
  • Mustafa on Goodbye Log Triggers Welcome Flashback Data Archive

Archives

  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • July 2019
  • June 2019
  • May 2019
  • March 2019
  • February 2019
  • June 2018

Categories

  • 11g
  • 12c
  • 18c
  • 19c
  • 20c
  • Administration
  • Compression
  • Development
  • Materialized View
  • Performance
  • Security
  • SQL / PLSQL
  • Uncategorized
  • Undocumented
  • Useful Scripts

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Archives

  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • July 2019
  • June 2019
  • May 2019
  • March 2019
  • February 2019
  • June 2018
© 2021 Mustafa KALAYCI. All rights reserved.