What’s brown and sticky?
The UK Heatwave continues…grab some shade and read some of the latest blog posts from the finest of bloggers!
Blogs of the week
Check out the new podcast from Jeff Smith and Scott Spendolini:
KPI Partners go through:
- Security Implementation Benefits
- General Practice
- Flow Diagram
- Proposed Solution
- Implementation Steps
Kevin Black details:
1. Tool – Data Relationship Governance
2. Process – Data Governance Program
3. Integration – DRM to External Systems
and summarises by saying: “So there you have it. Three critical components to effective data governance: a good tool (DRG), a robust process (data governance program), and automated integration (with DRM as the hub).”
Richard Foote says, “In Part I, I discussed how the order of columns in an index makes no real difference to the effectiveness of the index if all columns are referenced via equality predicates.”
Read this blog which is Part II in the series
Michelle Kolbe summarises the past 3 blog posts which are linked here:
This post is part 4 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). The previous posts are:
She finishes her blog by going through the BVT Errors she has encountered
Connor McDonald works through a problem with ‘NULL’ and ‘NUL’!!
Dani Schidner gives 10 Tips to Improve ETL Performance.
- Use Set-based Operations
- Avoid Nested Loops
- Drop Unnecessary Indexes
Read the full blog for all 10
Peter Scott writes, “one of the great things over the past (almost) two decades has been table partitioning; true, other vendors do similar things now, but Oracle’s way always seemed easy to adopt and performed well…however,there are some quirks that we need plan for:
- Partitions get created with system generated names.
- partitions are not created until they have at least one row to insert into it.”
Jonathan Lewis opens his blog by saying,”A recent tweet from Connor McDonald highlighted an article he’d written a couple of years ago about an enhancement introduced in 12c that allowed for direct path inserts to index organized tables (IOTs). The article included a demonstration seemed to suggest that direct path loads to IOTs were of no benefit, and ended with the comment, “Direct mode insert is a very cool facility, but it doesn’t mean that it’s going to be the best option in every situation.”
Read his full blog for more.
This week on Twitter
Mike Dietrich tweeted Oracle Database 18.3.0 installation on premises
UKOUG shared agendas for Conferences and Exhibitions
ODTUG shared livestreams from #kscope18
Videos such as
Troubleshooting a Complex Oracle Performance Issue
and Oracle Autonomous Data Warehouse Cloud Demo