Nach Markierungen suchen

How to Save 7 Keystrokes with dbms_xplan

An almost unknown simplification in the usage of dbms_xplan is possible since Oracle 12.2. Sometimes, there are small details that makes our job (a little bit) easier. In one of his presentations at the Kscope19 conference, Kim Berg Hansen mentioned an...

Veröffentlicht 16 Jul 2019 22:22 von triBLOG

Gespeichert unter: Oracle, Performance, PL/SQL, Oracle 12c

Conference Review 2019 (Part 1)

In the last two months, I had the pleasure to speak at four different conferences. Each of them was unique in its own way, and all of them were definitely worth to attend. Of course, it is not possible to … Continue reading →...( read more...

Veröffentlicht 10 Jul 2019 9:05 von triBLOG

Gespeichert unter: Oracle, conferences

Running utPLSQL Tests in SQL Developer

Introduction In November 2017 Jacek Gebal asked me if I could help to integrate utPLSQL into SQL Developer. In January 2018 we released the first MVP. […] The post Running utPLSQL Tests in SQL Developer appeared first on Philipp Salvisberg's Blog...

Veröffentlicht 6 Jul 2019 19:23 von triBLOG

Gespeichert unter: Oracle, PL/SQL, SQL Developer, utPLSQL

Oracle Privilege Analysis in action

As Oracle has quite recently announced that Privilege Analysis is now included with the Oracle Database Enterprise Edition licence, I played a little bit with this cool feature to solve infamous ORA-01031: Insufficient privileges error. You can read results...

Veröffentlicht 30 Apr 2019 20:19 von triBLOG

Gespeichert unter: Oracle, Troubleshooting, Security, #PTK, privilege analysis, Oracle Scene, UKOUG, ORA-01031

Bitmap-based COUNT(DISTINCT) Functions in Oracle 19c

Oracle 19c provides a set of new SQL functions for bitmap operations. They allow fast computation of COUNT(DISTINCT) expressions. What is the purpose of these functions? The Oracle documentation is very sparse, but at least it tells us that the main …...

Veröffentlicht 20 Apr 2019 21:13 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, Materialized Views, oracle 19c

Using DBMS_DEBUG in SQL Developer

Do you need to debug PL/SQL units in SQL Developer? You can’t get it to work because someone refuses to open TCP ports between your database […] The post Using DBMS_DEBUG in SQL Developer appeared first on Philipp Salvisberg's Blog . ...read...

Veröffentlicht 8 Apr 2019 0:28 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Debugging, SQL Developer

Cross-endian Oracle migration – moving user data – part II

In my previous post I shared some findings on migrating user and application data between platforms with different endianness, focusing on problems with reducing downtime. Today I’ll talk more about the complexity of chosen method. It’s not...

Veröffentlicht 19 Mrz 2019 8:30 von triBLOG

Gespeichert unter: Migration, Oracle, Backup, Troubleshooting, RMAN, XTTS

Cross-endian Oracle migration – moving user data – part I

One can find a lot of sources and materials regarding migrating Oracle databases between platforms having different endianness, even though the choice of possible methods is limited in this case. On paper (slides?) everything looks fine, but then you...

Veröffentlicht 14 Mrz 2019 22:04 von triBLOG

Gespeichert unter: Migration, Oracle, Backup, Troubleshooting, RMAN, XTTS

20 Years Working for Trivadis

Today, it is exactly twenty years ago since I started my job as a consultant for Trivadis. In 1999, I never thought that I will stay in one company for such a long time. A retrospective of the last two decades. … Continue reading →...( read...

Veröffentlicht 1 Mrz 2019 11:08 von triBLOG

Gespeichert unter: Oracle

Materialized View Refresh for Dummies

Materialized Views are often used in data warehouses to improve query performance on aggregated data. But what if it takes too long to refresh the materialized views? Here are some basic rules to improve refresh performance. Unlike indexes, materialized...

Veröffentlicht 18 Feb 2019 21:19 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL, Materialized Views

MemOptimized RowStore in Oracle Database 19c

Since February, 13 2019 Oracle Database 19c is available. I blogged about this feature here and here. Time for an update. So, what’s new in 19c regarding the […] The post MemOptimized RowStore in Oracle Database 19c appeared first on Philipp Salvisberg's...

Veröffentlicht 17 Feb 2019 21:15 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, PinkDB, oracle 19c

Troubleshooting Oracle session disconnection slowness

I have been recently asked to investigate very interesting issue. In short: AIX 7.1 with Oracle 12.1.0.2. Connect with SQL*Plus from hostX to databaseA running on hostZ, then disconnect – was hanging for around 75 seconds. Connect with SQL*Plus from hostY...

Veröffentlicht 13 Feb 2019 13:00 von triBLOG

Gespeichert unter: Oracle, Troubleshooting, TCP/IP, AIX, network, Oracle Net, Tracing

Issue with the Hint ENABLE_PARALLEL_DML

Performing an ETL with large data sets, it is often a good idea to run DML in parallel. But, in contrast to parallel query or DDL, parallel DML have to be explicitly enabled. You had to issue ALTER SESSION ENABLE PARALLEL DML in the past. Starting with...

Veröffentlicht 27 Jan 2019 23:28 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, ETL, Data Warehouse, CBO, PDML, parallel DML

Dynamic Pivot with Polymorphic Table Function?

LiveSQL is great place to start playing with new features. It provides a couple of very helpful demo scripts explaining how polymorphic table functions work. There I found a new script few days ago which uses PTF for dynamic pivot! WOW! According to my...

Veröffentlicht 4 Jan 2019 14:24 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, PL/SQL, PTF, 18c

Polymorphic Table Functions (PTF), Part 4 – Table Semantic PTF

In the first three parts of the series we have seen how a PTF basically works, but we have focused on row-semantic PTF only. In this part we’ll look at the table semantic PTF. As a reminder, the main difference to row-semantic PTF is that it is...

Veröffentlicht 24 Dez 2018 14:47 von triBLOG

Gespeichert unter: SQL, Oracle, Allgemein, Trivadis, PL/SQL, PTF, 18c, polymorphic

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives