ORA-30036 This error ORA-30036 could be very serious in a situation that is described below and may make users panic: One day, a DBA was… Read More »How to Resolve ORA-30036 UNABLE TO EXTEND SEGMENT BY 8 IN UNDO TABLESPACE 'UNDOTBS1'
ORA-01653 The following two error messages are very similar. As a DBA, you'll probably meet them someday in the future. ORA-01653 is for table, ORA-01654… Read More »How to Resolve ORA-01653 Unable to Extend Table in Tablespace
After you finish your shell scripting, you'd like to try your scripts to see the result in your test environment. In the debug phase, you… Read More »How to Remove No-Name or Empty-Name Files
Only at Command Available When you are a customer DBA at your client's site to do routine db data collection or planned health check tasks,… Read More »How to Resolve Only at Command is Available to Schedule Jobs
Monitor Memory Usage In Unix, you have many tools to monitor the overall memory usage, such as vmstat, sar, top and free. Using vmstat Command… Read More »How to Monitor Unix Memory Usage by Processes
SYSDBA vs SYSOPER According to Oracle documentation about administrative accounts and privileges, I compared their privileges between SYSDBA and SYSOPER as below: Allowed Actions SYSDBA… Read More »What is the Difference Between SYSDBA and SYSOPER Privileges
Grant All Tables at Object Level Sometimes, you may want a user who can select all the tables from the other user's. But the question… Read More »How to Grant All Tables Owned by Others