commit after select

Question

I have read the explanations when a commit may be neccessary after a select statement for DB2 and MySQL:

Is a commit needed on a select query in DB2?

Should I commit after a single select

My question is when and why would it be important to commit after executing a select statement using Oracle?

I am no Oracle pro, so perhaps someone more knowledgeable can comment on this, but I have run scripts that have executed a large number of large select statements, which eventually returned database server temp space issues. Committing after each select eliminated this. — woemler
– woemler, Commented Jan 21, 2013 at 1:50

DazzaL · Accepted Answer · 2013-01-21 10:25:56Z

17

there are only a few situations that I can think of that you may want to commit after a select.

if your select is joining on database links, a transaction will be created. if you attempt to close this link, you'd get an error unless you committed/rolled back the transaction.
select for update (as DCookie says) to release the locks.
to remove an serialized isolation level if set or to add one, if you've been selecting from db links prior to invoking this.

answered Jan 21, 2013 at 10:25

DazzaL

22.1k3 gold badges52 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DCookie · Accepted Answer · 2013-01-20 23:14:00Z

15

If you did a SELECT ... FOR UPDATE; you would need a COMMIT or ROLLBACK to release the records held for update. Otherwise, I can't think of any reason to do this.

answered Jan 20, 2013 at 23:14

DCookie

43.7k11 gold badges88 silver badges93 bronze badges

Collectives™ on Stack Overflow

commit after select

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related