What’s brown and sticky?
A stick
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:
2. Integration of OBIEE with an External Web Application – SAML SSO
KPI Partners go through:
- Security Implementation Benefits
- Requirement
- General Practice
- Flow Diagram
- Proposed Solution
- Implementation Steps
Francesco Tisiot talked about the Sunday Symposium and Presentations, Visualizing Streams, DevOps and OBIEE: Do it Before it’s Too Late, and linkedto Kscope19 in Seattle
4. The Data Governance Triple Crown
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).”
5. Index Column Order – Impact On Index Branch Blocks Part II (The Weeping Song)
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
6. Using Oracle’s Baseline Validation Tool with OBIEE — Part 4
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
7. Humble pie made with NULL strings
Connor McDonald works through a problem with ‘NULL’ and ‘NUL’!!
8. 10 Tips to Improve ETL Performance – Revised for ADWC
Dani Schidner gives 10 Tips to Improve ETL Performance.
These include:
- Use Set-based Operations
- Avoid Nested Loops
- Drop Unnecessary Indexes
Read the full blog for all 10
9. Oracle Interval Partitions and Bitmap Indexes
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
Paper.li
Stories from www.vlamis.com, www.biconnector.com and www.odtug.com
Videos such as
Troubleshooting a Complex Oracle Performance Issue
and Oracle Autonomous Data Warehouse Cloud Demo