In oracle, data sharing has brought convenience for employees, but also produced some negative effects. The transaction in oracle not only achieve its proper role, but also greatly reduce database performance. If the database transaction execution time longer, it is likely to lead to lock conflicts, thereby reducing the performance of the database concurrent access. Therefore, I want to know that how to get effective transaction in oracle. Please suggest.