tag:blogger.com,1999:blog-1339993448594009052.post7227447456330635007..comments2024-03-27T22:31:52.563-07:00Comments on Triggers Considered Harmful, Considered Harmful: "Workarounds" for ORA-04091Toon Koppelaarshttp://www.blogger.com/profile/08153913435188725112noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-1339993448594009052.post-7373874965026570742013-03-26T15:30:04.949-07:002013-03-26T15:30:04.949-07:00Thanks.
Just remember, these aren't really wo...Thanks. <br />Just remember, these aren't really workarounds...<br />They are dirty fixes, which you do not want to employ.Toon Koppelaarshttps://www.blogger.com/profile/08153913435188725112noreply@blogger.comtag:blogger.com,1999:blog-1339993448594009052.post-64169194748845381262013-03-26T15:27:30.346-07:002013-03-26T15:27:30.346-07:00Wow, thank you so much for the nice post. I learn...Wow, thank you so much for the nice post. I learned a lot.shiroynuhttps://www.blogger.com/profile/11887386697204653653noreply@blogger.comtag:blogger.com,1999:blog-1339993448594009052.post-4199665043569385872011-12-17T10:45:00.975-08:002011-12-17T10:45:00.975-08:00danilo, it's the same (distributed) transactio...danilo, it's the same (distributed) transaction, in a transaction you have to see your changes, so it's not a dirty read..<br /><br />nice post, I'm looking forward to the next one :)Radoslav Golianhttps://www.blogger.com/profile/11089830721619663885noreply@blogger.comtag:blogger.com,1999:blog-1339993448594009052.post-4018701271839954232011-12-15T14:37:57.045-08:002011-12-15T14:37:57.045-08:00Yes, I've struggled with this in the past and ...Yes, I've struggled with this in the past and I'm looking forward to learning if there is a usable workaround.<br /><br />- Stew<br /><br />p.s. I don't seem to be able to subscribe to the RSS feed here? Maybe it's a FireFox issue?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1339993448594009052.post-41377784248260590832011-12-14T01:50:28.624-08:002011-12-14T01:50:28.624-08:00As a spin on the 'autonomous transaction' ...As a spin on the 'autonomous transaction' you can also use flashback query (eg AS OF TIMESTAMP SYSTIMESTAMP). Has a similar logical effect because the flashback query returns the committed state of the table but with fewer potential side-effects (eg there's only one session/transaction so you can't deadlock).<br />But the same fundamental flaws as all programmatic constraint enforcement, escpecially in highly concurrent environments.sydoraclehttps://www.blogger.com/profile/10404756950638119562noreply@blogger.comtag:blogger.com,1999:blog-1339993448594009052.post-25860779696355947412011-12-13T14:23:03.406-08:002011-12-13T14:23:03.406-08:00Read uncommitted are possible in Oracle. How cool!...Read uncommitted are possible in Oracle. How cool!<br /><br />I used the autonomous transaction "workaround" sometimes, believing it was a legitimate use. Let's see how wrong I was...Danilo Piazzalungahttps://www.blogger.com/profile/01660247588218614923noreply@blogger.com