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 2 Comments

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

  • Expanded controlfile section n from nnn to nnn records
  • Audits are not Purged
  • lsnrctl or new db connection is too slow
  • SESSION_CACHED_CURSORS Parameter and How can It Affect the Database
  • Marked as unrecoverable datafile in V$datafile even if they are not!

Recent Comments

  • Mustafa on Blockchain vs Immutable tables
  • SERHAT on Blockchain vs Immutable tables
  • Mustafa on Can not Drop Materialized View on 12c and above?
  • Ashish on Can not Drop Materialized View on 12c and above?
  • Mustafa on Create a Clone DB from Backup on the Same Server (or remote)

Archives

  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • October 2021
  • September 2021
  • August 2021
  • April 2021
  • January 2021
  • 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
  • 21c
  • Administration
  • Compression
  • Development
  • Materialized View
  • Multi-tenant
  • Performance
  • Security
  • SQL / PLSQL
  • Uncategorized
  • Undocumented
  • Useful Scripts

Meta

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

Archives

  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • October 2021
  • September 2021
  • August 2021
  • April 2021
  • January 2021
  • 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
© 2022 Your Name. All rights reserved.