Follow Josip Pojatina Blog on Feedspot

Continue with Google
Continue with Facebook

Josip Pojatina Blog
Performatune provides consulting in Oracle Retail Performance Tuning, Ora..
In this post I’ll explain what you need to do to setup external C procedure call with Oracle 18c. I’ll also show for a CPU intensive ..read more
Main objective of this post is to list some of the typical issues I’ve found when debugging PL/SQL stored procedures, functions and ..read more
Recently I had a case of duplicate rows in a table with Primary Key enabled. More common case is to catch CBO (Cost Based Optimizer) to ..read more
Imagine you need to create an ETL workflow that uses the Oracle database as one of its sources or even more common situation where you ..read more
The main topic of this article is the DESC index type, which is often mixed-up with the Btree index type because of the great similarity ..read more
I work with Oracle more than I can remember, but every day I find something new. This time I’m asked to drop one index on the production ..read more
In this post I’m going to explain the most important drawbacks when using db links technology for purposes for which it is not design ..read more
In this post mechanism of Oracle database link technology along with locking strategy used by Oracle database will be described. Today in ..read more
This is the last part of the series called “Oracle RAC in the AWS Cloud”. In my previous article I’ve promised to put a Oracle RAC ..read more
In the 2nd part of the Oracle RAC in the AWS Cloud series I’ll present test results of Oracle 2 nodes RAC databases running on AWS ..read more

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview