Ed Chen Logic - Page 87 of 88 - To Make My Logic More Logical

How to Resolve Only at Command is Available to Schedule Jobs

by Ed Chen
October 16, 2012May 4, 2019

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 Find Most Expensive SQL

by Ed Chen
October 15, 2012May 4, 2019

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 Monitor Unix Memory Usage by Processes

by Ed Chen
October 14, 2012May 4, 2019

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 »

What is the Difference Between SYSDBA and SYSOPER Privileges

by Ed Chen
October 13, 2012December 28, 2020

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 »

Who has SYSDBA Privilege?

by Ed Chen
October 13, 2012February 2, 2021

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 »

How to Grant All Tables Owned by Others

by Ed Chen
October 13, 2012November 24, 2020

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 Resolve ORA-3136 Inbound Connection Timed Out

by Ed Chen
October 11, 2012November 24, 2020
2 Comments

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 »

Why SPFILE Does Not Work in RAC

by Ed Chen
October 10, 2012January 14, 2021

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 »

How to Connect Idle, Nomount or Restricted Database Remotely

by Ed Chen
October 10, 2012January 11, 2021

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 Set NLS_DATE_FORMAT in RMAN

by Ed Chen
October 9, 2012September 13, 2019

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 »