ORA-24244: invalid host or port for access control list (ACL) assignment Mustafa Kalaycı, 2020-12-24 Hello everyone, So you wanted to migrate your ACLs to another database or you are trying to add a new acl entity but you got ORA-24244. There are many reasons for that error unfortunately. I wish Oracle provides us more detail about what is the error but I wanted to… Continue Reading
export import ACL & ORA-24244 error during import Mustafa Kalaycı, 2020-12-16 Hello everyone, it’s been a while since my last post. So, I wanted to write about export and import ACL privileges. They always become a pain (at least for me). after 12c, Oracle introduce us a new and easy way of ACL copying from db to db. export&import. so here… Continue Reading
Which Column has Changed in Every Row? Mustafa Kalaycı, 2020-11-02 Hi, Edit: Thanks to Chris Saxon who is from asktom team, checked my code and warned me about a problem. Not to overload the PGA fetch_rows function only fetches 1024 rows at once so every row set chunk size is 1024. In this case for the 1025th row, previous row… Continue Reading
SQL Macro Part2 column_value = nvl(:param, column_value) Mustafa Kalaycı, 2020-10-30 Hi, Since I am working on "SQL Macro", I am keep testing things. so please see my previous post: https://mustafakalayci.me/2020/10/28/sql-macro-is-finally-here/ as mentioned in previous post, is it possible to get rid of column_value = nvl(:param, column_value) conditions? since they become a huge pain in big and complex queries. I provided… Continue Reading
SQL Macro is finally here! Mustafa Kalaycı, 2020-10-28 Hi, I was waiting for this for a long time. Finally we can use sql macro in Oracle database. Actually I was excited when I first read about this but after my tests, I stuck at some points. I was hoping to use this as “parameterized views” as in, send… Continue Reading
Direct Path Insert &/vs Conventional Insert Mustafa Kalaycı, 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
Flashback Data Archive Problems! Mustafa Kalaycı, 2020-09-10 Hi, if you don't know about flashback data archive you can check this post first: https://mustafakalayci.me/2019/03/02/goodbye-log-triggers-welcome-flashback-data-archive/ I mentioned about flashback data archive (FDA) in that post and really flattered it. Well, maybe I shouldn't! FDA is really fast dml tracking method but thanks to Peter Schlaeger, I noticed some potential… Continue Reading
Oracle Table Compression Part1 Mustafa Kalaycı, 2020-09-10 Hi, I have been dealing with table compression a lot during my development period and I still do. I wanted to share some information about table information but I believe this will be a long explanation so I will write them in parts and this is part1. Table compression is… Continue Reading
Redo Log Switch Order Mustafa Kalaycı, 2020-09-03 Hi, I always have the impression that redo log switch occurs in group number order but a small test showed me, I was wrong. As you know redo log is one of the most important part of a Oracle database. it almost protect everything! your data in memory, data file,… Continue Reading
NVME Drives and Oracle Database Mustafa Kalaycı, 2020-08-20 Hi There, NVME drives are so hot these days. They have amazing read/write speed. my old samsung ssd drive can read and write around 550/530 MB per second and my even older 2.5inch hdd drive has 45/20 MB per second. Current NVME disc drives has around 3500 read and 3000… Continue Reading