Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL or DML? DDL… Read More »Truncate vs Delete Entire Table
To improve overall performance, sometimes, we may consider to move redo logs to the location with faster disks, like Solid-State Drive (SSD). Once you decide… Read More »How to Change Redo Log Location in Oracle
Actually, this topic "How to Move Oracle Database" follows my previous post: How to Move ORACLE HOME. But I think it can be used in… Read More »How to Move Oracle Database
Resize Redo Logs The default size of redo logs during installation is 50MB which is too small for production databases. Of course, you can change… Read More »How to Resize Redo Logs in Oracle
There are several different kinds of situation when you recover a database with inconsistent states among files. In the following, I have to assume that… Read More »When Database is Not Consistent
In this post, I will talked about the following 3 topics. How to Define Archive Log Size? Are all Archive Logs the Same Size? How… Read More »How to Check Archive Log Size