Commit Time – Part 2 (On Commit Trigger) Mustafa, 2019-12-192019-12-19 Hello again, Not long ago, I mentioned about how to get approximate commit time on a table: https://mustafakalayci.me/2019/05/25/commit-time-for-an-inserted-row-in-oracle/ While I was reading some blogs and jumping from one to another, I came to Saibabu Devabhaktuni’n blog post: http://sai-oracle.blogspot.com/2013/09/how-to-setup-oracle-on-commit-trigger.html and I was literally shocked because I never heard something about this…. Continue Reading
How to Get Your SID? USERENV vs V$MYSTAT! Mustafa, 2019-05-232020-07-05 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