Skip to primary content
Skip to secondary content

Data Warehousing with Oracle

Dani Schnider's Blog

Data Warehousing with Oracle

Main menu

  • Home
  • Contact
  • About
  • Publications
  • Presentations

Monthly Archives: December 2017

Incremental Statistics – A Real World Scenario

Posted on 30. December 2017 by Dani Schnider
9

Incremental statistics reduce the time to gather global statistics for a partitioned table. Really? In some situations it may happen that incremental statistics slow down statistics calculation dramatically. An example of a real project in Oracle 12.1 and how it can be improved with Oracle 12.2.

Continue reading →

Posted in Oracle, Oracle 12c, Partitioning, Performance | 9 Replies

UKOUG Tech17: Chocolate and Knowhow Sharing

Posted on 10. December 2017 by Dani Schnider
Reply

For the first time, I had the chance to attend and speak at the UKOUG Technology Conference. In these three days at UKOUG Tech17 in Birmingham, I attended some very good sessions, had many interesting discussions about Oracle databases, data warehousing and performance tuning, met nice people and tasted a lot of chocolate.

Continue reading →

Posted in Conferences, Oracle | Leave a reply

Categories

  • ADWC (6)
  • Books (8)
  • Cloud (6)
  • Conferences (20)
  • Data Vault Modeling (20)
  • Dimensional Modeling (13)
  • DWH Architecture (16)
  • DWH Automation (4)
  • ETL (27)
  • In-Memory (5)
  • Materialized Views (6)
  • Oracle (82)
  • Oracle 12c (27)
  • Oracle 19c (3)
  • Oracle 20c (1)
  • Oracle Data Integrator (1)
  • Oracle OpenWorld (8)
  • Oracle Warehouse Builder (7)
  • Partitioning (20)
  • Performance (50)
  • PL/SQL (9)
  • Relational Modeling (3)
  • Snowflake (1)
  • SQL (45)

Archives

  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • February 2022
  • December 2021
  • January 2021
  • December 2020
  • November 2020
  • June 2020
  • April 2020
  • February 2020
  • December 2019
  • October 2019
  • July 2019
  • June 2019
  • April 2019
  • March 2019
  • February 2019
  • December 2018
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • July 2016
  • June 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • April 2015
  • March 2015
  • January 2015
  • December 2014
  • October 2014
  • August 2014
  • July 2014
  • June 2014
  • October 2013
  • July 2013
  • June 2013
  • April 2013
  • March 2013
  • June 2012
  • May 2012
  • January 2012
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • April 2011
Blog at WordPress.com.
  • Follow Following
    • Data Warehousing with Oracle
    • Join 125 other followers
    • Already have a WordPress.com account? Log in now.
    • Data Warehousing with Oracle
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar