• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1910
  • Last Modified:

Which Oracle Statements Need Commit?

Dear experts,

Could you tell me which of the following statements do you recommend me to commit? Also could you offer me a documentation about when to perform explicit commit?

alter table <table name> deallocate unused;
alter index <index name> deallocate unused;
alter table <table name> enable row movement;
alter table <table name> shrink space;
analyze table <tablename> compute statistics;
alter index <index name> rebuild online;

BR,
0
GurcanK
Asked:
GurcanK
1 Solution
 
sventhanCommented:
< Could you tell me which of the following statements do you recommend me to commit? Also could you offer me a documentation about when to perform explicit commit?

None of the above statements need a commit. We should issue commit against DMLs (insert/update/delete).
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now