Nach Markierungen suchen

Using Temporary Tables for Complex Reports

Global temporary tables (or private temporary tables, if you use Oracle 18c) are a practical feature to be used for SQL queries with multiple steps, for example complex reports in a data warehouse. If you want to use them, some … Continue reading...

Veröffentlicht 15 Mai 2018 23:40 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL, DWH Architecture

Why and How Using the accessible_by_clause?

The accessible_by_clause was introduced in Oracle Database 12 Release 1 and extended in Release 2. If you do no know this feature, I suggest to have […] ...read more...( read more ) Mehr…

Veröffentlicht 6 Mai 2018 12:22 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Oracle 12c, Oracle 12cR2, accessible_by_clause, utPLSQL

White Listed PL/SQL Programs in Oracle Database 18c

I’ve recently installed plscope-utils in an Oracle Database 18c instance. A package body using the SYS.UTL_XML.ParseQuery function failed to compile. The error message was: PLS-00306: wrong number or […] ...read more...( read more ) Mehr…

Veröffentlicht 30 Apr 2018 18:10 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, Oracle 12c, Oracle 12cR2, Oracle 18c

Streams for basic capturing of changes from an Oracle database

Subtitle: Continuous Integration of Oracle Database to other heterogeneous systems, e.g. Big Data Hi there, Basically, this blog post is about Oracle database but that time inspired by the fact that there is more than just Oracle. In a discussion with...

Veröffentlicht 26 Apr 2018 16:24 von triBLOG

Gespeichert unter: Oracle, big data, mongodb, kafka, Hadoop, Cassandra, NoSQL

Conditional Logic in SQL

A few days ago Sven Weller has published an excellent post about writing conditional logic in SQL and it reminded me of an example I used in one of my presentations. It is also about conditional logic in SQL but maybe some less obvious use cases in context...

Veröffentlicht 10 Apr 2018 17:45 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, analytische Funktionen, IGNORE NULLS, prozedurale Logik, bedingte Logik

Oracle Database Security For Developers

The last blog post of Jeff Smith (18.1 Features: SQL Injection Detection) about little, but nice feature of SQL Developer detecting if your PL/SQL code might be vulnerable for SQL Injection, reminded me about the presentation I’ve delivered during...

Veröffentlicht 10 Apr 2018 15:30 von triBLOG

Gespeichert unter: Oracle, Security, PL/SQL, SQL injection

Polymorphic Table Functions Example – (NOT) Transposing Rows to Columns

It was not possible for me to write a follow-up to my last post about Transposing Columns To Rows with PTF showing an opposite task of transposing rows to columns right next weekend as I thought. Partly because of our awesome Trivadis TechEvent which...

Veröffentlicht 4 Apr 2018 12:58 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, PL/SQL, Pivot, PTF, 18c, transponieren, UNIVOT, "table function", tabellenfunktion, polymorphic

Keep Your SQL Simple (and Fast)

Complex SQL statements are hard to understand – not only for us, but for the query optimizer, too. Sometimes, it is a good idea to write a simpler SQL query to do the same work. Here a nice story about … Continue reading →...( read more...

Veröffentlicht 3 Apr 2018 22:01 von triBLOG

Gespeichert unter: SQL, Oracle, Performance

BI jobs performance degradation after Oracle 11.2.0.4 to 12.1.0.2 migration

If you have performance problems after migrating your BI databases from 11.2.0.4 to 12.1.0.2 or any other performance issue, you should not underestimate SQL Plan Notes, which can point you to the right direction or just let you understand what exactly...

Veröffentlicht 26 Mrz 2018 6:30 von triBLOG

Gespeichert unter: Migration, Oracle, Performance, optimizer, Parallel Processing, execution plan

PL/SQL Cop for SonarQube 7.0

The last two months my Trivadis colleague Daniel Schutzbach and I have been working on the PL/SQL Cop plugin for SonarQube. The goal was to support […] ...read more...( read more ) Mehr…

Veröffentlicht 11 Mrz 2018 18:51 von triBLOG

Gespeichert unter: Oracle, PL/SQL, PL/SQL Cop, SonarQube

Having Fun with Auto-List Partitioning

I just wanted to write a small demo script for Auto-List Partitioning in Oracle 12.2. Instead, I spent an entire evening finding a bug in the Oracle data dictionary. Fortunately, it’s not a dramatic one. When I was messing around … Continue reading...

Veröffentlicht 27 Feb 2018 21:50 von triBLOG

Gespeichert unter: Oracle, Partitioning, Oracle 12c

Polymorphic Table Functions Example – Transposing Columns To Rows

Hey, Oracle 18c is now available on the cloud and for engineered systems! For more than a week now. That also means you can play with it at LiveSQL. And of course you can try polymorphic table functions (PTF)! At least I’ve done that this weekend...

Veröffentlicht 25 Feb 2018 23:35 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, Pivot, PTF, 18c, transponieren, UNIVOT, "table function", tabellenfunktion, polymorphic

Smart way to run commands on many *nix machines from (not only) Windows client

Having a need to run the same set of commands on many machines is a very common task for IT engineers of all kind. If you want to do it efficiently and in a smart way (e.g. to run it only on machines with specific set of conditions), I have an example...

Veröffentlicht 21 Feb 2018 0:29 von triBLOG

Gespeichert unter: linux, Toolbox, Oracle, Unix

Direct-Path INSERT and NOLOGGING with Oracle 12.2

Direct-Path INSERT is a very efficient way to load data into data warehouse tables. The load performance can even be improved with NOLOGGING on the target table. In Oracle 12c Release 2, this is even possible for Oracle Data Guard … Continue reading...

Veröffentlicht 20 Feb 2018 10:49 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL, Oracle 12c

Monitor backup jobs using RMAN views

Proper monitoring of backup jobs is one of the crucial elements in ensuring that your databases are well-enough protected against data loss. You can for example grep your backup logs, put some kind of alerting inside your backup scripts, but the most...

Veröffentlicht 22 Jan 2018 22:14 von triBLOG

Gespeichert unter: Oracle, Backup, Monitoring, RMAN

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives