Nach Markierungen suchen

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

Fast Recovery Area space usage threshold

Using Fast Recovery Area to let Oracle automatically manage the backup/flashback/recovery related files is very useful, but avoiding problems related with FRA free space shortage requires careful planning. There are several factors that have to be taken...

Veröffentlicht 18 Dez 2018 13:30 von triBLOG

Gespeichert unter: Oracle, FRA

Data Types of Join Columns

The data type of primary key and foreign key columns has an impact on the query performance. This should be considered in the design decision of keys in a Data Vault schema. In a performance review of a customer project, … Continue reading →...

Veröffentlicht 11 Dez 2018 18:16 von triBLOG

Gespeichert unter: Oracle, Performance, Data Vault Modeling, ADWC

Redo Transport from Oracle 11.2 to 12.2 and SYS password case-sensitivity problems

Case-sensitive passwords were introduced in Oracle Database 11g, causing some misunderstanding and introducing quite a lot of annoying problems for DBAs, even though it was really required to bring level of Oracle’s security to 21st century standards...

Veröffentlicht 22 Nov 2018 16:08 von triBLOG

Gespeichert unter: Oracle, Troubleshooting, Security, password file

Polymorphic Table Functions (PTF) , Part 3 – Row Replication

In the third part of the PTF-series we learn how a PTF can change the cardinality of the input data flow: return more or less rows as in the input. We’ll use the same simple table as in the part 2 and our new task will be column transposing. We’ll...

Veröffentlicht 12 Nov 2018 22:37 von triBLOG

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

Online Statistics Gathering for ETL – Part 3

Preparing my session on Online Statistics Gathering for ETL for the DOAG conference, I noticed some points that I didn’t covered in the previous two blog posts. The first point is showing the problem that may arise if indexes are involved. The second...

Veröffentlicht 4 Nov 2018 22:32 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, ETL, Data Warehouse, 12c, CBO, 18c, incremental statistics, partitin exchange load, online statistics gathering, OSG

Polymorphic Table Functions (PTF) , Part 2 – More Basics With Some Deep-Dive

In the first part of PTF series we went through a very basic example removing some columns and adding a new column with a constant value. Starting from the same example we’ll do something more meaningful in the second part. How about concatenating...

Veröffentlicht 29 Okt 2018 16:47 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, PL/SQL, PTF, 18c, polymorphic table functions, FETCH_ROWS

Polymorphic Table Functions (PTF) – Tinkering with Rowsets

Writing the second „basics“ post on PTF I discovered, that there were much more details worth mentioning, than it would be acceptable for a „basics“ post and would blow it up anyway So I decided to to separate the tests and finding...

Veröffentlicht 29 Okt 2018 16:45 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, PL/SQL, PTF, 18c, polymorphic table functions, row set, rowset

Migrating from Windows to Linux with Active Duplicate for standby – problem with 11.2.0.4

Recently I was working on migrating Oracle 11.2.0.4 database running on Windows, to new hardware infrastructure on Linux. This Oracle version is with us for quite a long time, plus migration from Windows to Linux is quite common (fortunately in that direction…;...

Veröffentlicht 11 Okt 2018 8:30 von triBLOG

Gespeichert unter: Windows, linux, Migration, Oracle, Troubleshooting, Data Guard, RMAN, active duplicate, standby

Regular Expressions in SQL by Examples

Are you reluctant to use regular expressions in SQL? Then continue reading. Examples helped me to understand regular expressions years ago. Thus I hope this collection […] The post Regular Expressions in SQL by Examples appeared first on Philipp Salvisberg's...

Veröffentlicht 28 Sep 2018 16:28 von triBLOG

Gespeichert unter: SQL, Oracle

Star Schema Optimization in Autonomous Data Warehouse Cloud

Oracle Autonomous Data Warehouse Cloud does not allow to create indexes. Is this a problem for star schemas because no Star Transformation can be used? Or are the required bitmap indexes automatically created? A look under the hood of ADWC. … Continue...

Veröffentlicht 13 Sep 2018 18:03 von triBLOG

Gespeichert unter: Oracle, Cloud, Performance, in-memory, Dimensional Modeling, ADWC

SmartDB as of 2018-08-21

Introduction This is a transcription of the recorded Ask TOM #SmartDB Office Hours from August, 21 2018, where Bryn Llewellyn presented an updated, narrow definition of […] The post SmartDB as of 2018-08-21 appeared first on Philipp Salvisberg's...

Veröffentlicht 28 Aug 2018 22:36 von triBLOG

Gespeichert unter: Oracle, SmartDB

SmartDB as of 2018-06-12

This is a transcription of Bryn Llewellyn’s talk Guarding Your Data Behind a Hard Shell PL/SQL API—the Detail recorded at Kscope18. It covers the time between 08:06 to […] The post SmartDB as of 2018-06-12 appeared first on Philipp Salvisberg's...

Veröffentlicht 28 Aug 2018 22:35 von triBLOG

Gespeichert unter: Oracle, SmartDB

Use Database as Persistence Layer Only

Using the database as persistence layer only is an anti-pattern. Praful Todkar applies this anti-pattern in How to extract a data-rich service from a monolith. Martin […] The post Use Database as Persistence Layer Only appeared first on Philipp Salvisberg's...

Veröffentlicht 25 Aug 2018 16:57 von triBLOG

Gespeichert unter: SQL, Oracle, SmartDB, PinkDB

Polymorphic Table Functions (PTF) , Part 1 – Basics

I have already posted some examples on Polymorphic Table Functions in Oracle 18c in the last months. I quickly realized how difficult it is to explain completely new feature using advanced examples and wanted to write a series of posts starting from very...

Veröffentlicht 19 Aug 2018 23:28 von triBLOG

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

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives