How to Get Your SID? USERENV vs V$MYSTAT! Mustafa Kalaycı, 2019-05-23 Hello everyone, This is an easy question. How to find your own session SID and when you ask Google for it, you will find many answers. While reading some documents, I realized that some Gurus are using V$MYSTAT to get current SID: Oracle PL/SQL select sid from v$mystat where rownum=1; 1 select sid from v$mystat where rownum=1; I always prefer USERENV(‘SID’) context to get… Continue Reading
Goodbye Log Triggers Welcome Flashback Data Archive Mustafa Kalaycı, 2019-03-02 Hello, I would like to talk about Flashback Data Archive (or Flashback Archive – FBA) in 12c. FBA was introduced in 11g. It is not new but it has very important new features that allow us to use FBA very efficiently and for free. I would like to talk about… Continue Reading