Commit Time – Part 2 (On Commit Trigger)

Hello again, Not long ago, I mentioned about how to get approximate commit time on a table: While I was reading some blogs and jumping from one to another, I came to Saibabu Devabhaktuni’n blog post: and I was literally shocked because I never heard something about this. So I did my tests […]

How to Get Your SID? USERENV vs V$MYSTAT!

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:

I always prefer USERENV(‘SID’) context to get SID and curious about which […]