PLSQL and Flashback Data Archive Problems. Mustafa, 2021-01-302021-01-30 Hi, I have written about flashback data archive before. if you didn’t read please check these post first. https://mustafakalayci.me/2019/03/02/goodbye-log-triggers-welcome-flashback-data-archive/ https://mustafakalayci.me/2020/09/10/flashback-data-archive-problems/ I’ve already mentioned about some problems on my second post but these are not kind of problems which will stop your work. The problem I am about talk is that… Continue Reading
ORA-24244: invalid host or port for access control list (ACL) assignment Mustafa, 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, 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, 2020-11-022020-11-03 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
Direct Path Insert &/vs Conventional Insert Mustafa, 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, 2020-09-102020-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, 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, 2020-09-032020-09-04 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, 2020-08-202020-08-21 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