exitcommit … or your career down the drain

Posted by

I recently posted a little video on the ‘exitcommit’ option in SQL Plus, adding a theatrical drama to present a worst case scenario of potentially destroying a Production system.  Take 3 mins to have a chuckle here.

https://www.youtube.com/watch?v=uCgbxGayjXA

My predecessor Natalka Roshak tweeted an interesting followup that I thought I would share, namely, if you’re a regular SQL Plus user, you should definitely take the time to check out the documentation on ‘exitcommit’ and its relationship to other related variables within SQL Plus.

Because you probably want to make sure you have got everything set just right !

 

image

3 comments

  1. Why on earth was autocommit invented, to this day escapes me!
    I’m quite sure it’s a flaw in my “bad dba” knowledge…
    Not very keen on exitcommit either, I’ve seen it do bad things indeed.
    Actually raised that concern first to DrDBA (Ken Jacobs) back in the second Australian Oracle User Conference I attended in Adelaide – somewhere in the early 90s.
    He clicked into the danger but did nothing about it, obviously.
    Apparently we were not big enough clients to deserve listening…

  2. I’d make the argument that commit on exit is the expected and normal behavior and you should be using PROMPT to know where you are working.

    If you set up your environment to be different than the usual behavior, then when you go somewhere else, you are probably not going to get what you want…, Or if someone comes in and does something for you (contractor?) then their stuff will break.

Got some thoughts? Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.