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
What is the Difference Between SYSDBA and 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 »What is the Difference Between SYSDBA and 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 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
How to Resolve ORA-3136 Inbound Connection Timed Out
ORA-3136 At times, some users complained about connection timeout, and you saw error messages ORA-3136 in sqlnet.log as such: Fatal NI connect error 12170. … Read More »How to Resolve ORA-3136 Inbound Connection Timed Out
Search Order of Parameter File for Startup
Shared SPFILE You might have noticed that the newly created SPFILE for a RAC database was not taking effective after restarts. And I think you… Read More »Search Order of Parameter File for Startup
How to Connect Idle, Nomount or Restricted Database Remotely
Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »How to Connect Idle, Nomount or Restricted Database Remotely
How to Set NLS_DATE_FORMAT in RMAN
After you set RMAN log location, the next problem that you want to solve is the format of timestamp in the log, which was too… Read More »How to Set NLS_DATE_FORMAT in RMAN
3 Ways to Set RMAN Log Location
RMAN Log Location RMAN is a client side utility like sqlplus used to interoperate with DB, we usually compose a script file or a batch… Read More »3 Ways to Set RMAN Log Location