How to limit DB Link Connection Timeout mustafakalayci, 2024-07-03 Hi, I just want to share something small that I dug to learn. I didn’t work with db links for years and now all of a sudden I have tens of them. This comes with new challenges of course. When you tried to run a query or function/procedures over a… Continue Reading
29th of February and interval mustafakalayci, 2024-02-29 Hi, it has been a long time since I post something. I just relocated to a different country, the Netherlands, and I was dealing with so much paperwork and stuff. So far so good. Dutch people are so kind and warm, they help about everything. My first impression is amazing… Continue Reading
Guid vs Sequences mustafakalayci, 2023-12-29 Hi Everyone, I haven’t written any posts lately because there is so much going on in my life and biggest change is I am moving to the Netherlands. it is a big change for me and my family but I hope everything will be fine (if we can find a… Continue Reading
DBMS_PIPE Connecting the Sessions mustafakalayci, 2023-08-18 Hi, It has been a long time since I wrote something. It is summer and I was in a long vacation. Well I worked mostly of course but at least get away a little bit. In this post I would like to talk about PIPEs in Oracle Database. It is… Continue Reading
DBCA Templates and Dangerous “General Purpose” Template mustafakalayci, 2023-05-11 Hi, I still see that many dba is creating their databases using “General Purpose or Transaction Processing” template. Why you shouldn’t use it? Because it is way too general! if you click the “view details” on the right: Almost all the “Components” are true. So it installs everything even… Continue Reading
lsnrctl or new db connection is too slow mustafakalayci, 2022-07-20 Hello everyone, I know this is not new but I haven’t seen this problem for a long time and it takes a while to find out it. A team leader (who is an elder brother to me) from the company I started to my first job called me and asked… Continue Reading
SESSION_CACHED_CURSORS Parameter and How can It Affect the Database mustafakalayci, 2022-07-02 Hello, Let’s talk about the SESSION_CACHED_CURSORS parameter. It might have significant affect on your system so understanding how it works and what it cause is important. This parameter limits the number of cached cursors on the session. As you know there is 2 kind of parse SOFT and HARD. Hard… Continue Reading
Hierarchical Blocking Session List mustafakalayci, 2021-10-19 Hi, Today, I needed to list all blocking sessions hierarchically. As you know, all information about sessions (and blocking sessions) are in gv$session (or just v$session if you are using single instance) view. I wanted to see who is blocking who and blocker at the top. you can write simple… Continue Reading
Subquery Caching mustafakalayci, 2021-10-17 Hi, I want to talk about very sweet performance “trick”. I love when I do something small and gain a lot 🙂 Today, I will demonstrate subquery caching in Oracle and try to explain how it works and it’s limitations. Probably, you are using some plsql functions in your select… Continue Reading
Direct Path Insert &/vs Conventional Insert mustafakalayci, 2020-10-27 Hi there, I couldn’t write anything for a while. Those days were busy. So I would talk to about direct path insert and conventional insert. Many people think that they are using “direct path insert” when used sqlldr utility but they are not. it is easy to confused batch insert… Continue Reading