ANALYZE vs DBMS_STATS
Oracle recommends to use DBMS_STATS instead of ANALYZE since 8i. Sometimes, we might get confused by the two similar tools. So I took some times… Read More »ANALYZE vs DBMS_STATS
How to Resolve ORA-30036 UNABLE TO EXTEND SEGMENT BY 8 IN UNDO TABLESPACE 'UNDOTBS1'
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'
How to Resolve ORA-01653 Unable to Extend Table in Tablespace
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
How to Remove No-Name or Empty-Name Files
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
How to Resolve Only at Command is Available to Schedule Jobs
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
How to Find Most Expensive SQL
With a demanding database, you may want to know how to find out the most expensive sqls. Running on Oracle, we have Cost-Based Optimizer, the… Read More »How to Find Most Expensive SQL
How to Monitor Unix Memory Usage by Processes
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 Privileges
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 »SYSDBA vs SYSOPER Privileges
Who has SYSDBA Privilege?
SYSDBA Privilege SYSDBA is a system privilege. By default, only SYS has the privilege, but it can be changed by granting to other user. Although… Read More »Who has SYSDBA Privilege?
How to Grant All Tables Owned by Others
Grant All Tables at Object Level For those who don't like the old username and want to switch all data to a well-named user, you… Read More »How to Grant All Tables Owned by Others