Enable Unified Audit on Linux and Windows

Hi, As you know, since 12c Oracle introduce Unified Auditing which has much more capabilities than standard auditing. Creating policies, audit conditions, top level auditing etc. By default Oracle uses “mixed” mode which allows you to run unified auditing commands and standard auditing. you can check if you are using unified auditing by default:

[…]

V$DIAG_ALERT_EXT and equality conditions

Hello, I don’t know if this is a bug but something small took my attention. Codes below are run on 19.8 and 19.12 versions. Lately, I was working on alert log messages and to do that I use V$DIAG_ALERT_EXT view which is a row by row representation of alert log file. while I was looking […]

Blockchain vs Immutable tables

Hi, as you know 21c is here for linux and some new features are (as always) pretty exciting. two of them are Blockchain and Immutable tables. Let’s explain and test. first of all, those are new features for 21c but they are backported to 19c. at 19.10 you are able to use BLOCKCHAIN tables and […]

X Forwarding for an Oracle DBA

Hi, It’s been a long time. I want to write something about X Forwarding. you might feel more comfortable to use a GUI instead of silent installations sometimes. if you are connecting to a linux server remotely then you must enable X Forwarding to enable GUI for Oracle product like dbca, netca etc. First of […]

Pragma UDF & Deterministic

Hello everyone, I wanted to write about something simple and can improve the performance of your sql statements. Unfortunately, many database developers use too much plsql function in their SQL statements. I say too much because if you learn more about the SQL, you will use less plsql. SQL is very capable language to process […]

PLSQL and Flashback Data Archive Problems.

Hi, I have written about flashback data archive before. if you didn’t read please check these post first. http://mustafakalayci.me/2019/03/02/goodbye-log-triggers-welcome-flashback-data-archive/ http://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 kind of problem. From my […]

export import ACL & ORA-24244 error during import

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 is the basic command on […]