Fixing Unable to relay error in Outlook

Error Message: Undeliverable:xyz System Administrator Your message did not reach some or all of the intended recipients. The following recipient(s) could not be reached: 550 5.7.1 Unable to relay for xyz12@x212.com ┬áSolution: This was the Solution which helped me to send the messages all over the world. 1) Open OutlookExpress2003 2)Go to Tools- Email Account-… Continue reading Fixing Unable to relay error in Outlook

On Cursors, Context Switches, and Mistakes

http://www.oracle.com/technetwork/issue-archive/2015/15-jul/o45plsql-2543984.html Key lessons learned: Never use a cursor FOR loop to fetch a single row. Never use an explicit cursor to fetch a single row. Avoid writing code that hides bugs. User-defined functions executed inside a SQL statement should never contain their own SQL statements. Keep user interface and report formatting logic separate from data… Continue reading On Cursors, Context Switches, and Mistakes

Analyzing multiple accesslog files

— generate beBigAndTradeDepositByTremList access history frequency for each access log per minute for i in `ls -ltr | grep -i access| awk ‘{print $NF}’` do name=`ls -l | grep -w $i | awk ‘{print $6″”$7}’|sed ‘s/://g’` grep beBigAndTradeDepositByTremList $i | awk ‘{print $3}’ | awk -F: ‘{print $1″:”$2}’ | uniq -c | awk ‘{print $2,$1}’… Continue reading Analyzing multiple accesslog files

Slow impdp

select v.status, v.sid, v.serial#, io.block_changes, v.event, v.module from v$sess_io io, v$session v where io.sid = v.sid and v.saddr in ( select saddr from dba_datapump_sessions) order by sid; STATUS SID SERIAL# BLOCK_CHANGES EVENT MODULE ——– ———- ———- ————- ————————————————– ————————- ACTIVE 151 54669 5488 wait for unread message on broadcast channel udi@PDWHDBS01 (TNS V1-V3) ACTIVE 414… Continue reading Slow impdp

Consistent export with expdp using flashback_scn (cont)

Q: Will flashback_scn help to avoid primary key conflict during export and import of data pump? A: Yes. DB: 11.2.0.3 OS:Redhat Linux 5.4 Here is my test case. SQL> select current_scn from v$database; CURRENT_SCN ———– 1800301 SQL> select seq_test.currval from dual; CURRVAL ———- 102 SQL> begin 2 for i in 1..100 loop 3 insert into… Continue reading Consistent export with expdp using flashback_scn (cont)

Suspicious slow I/O actually may not be an issue

OS: AIX 7.1 DB: Oracle 11.2.0.3 single instance Multipath: MPIO LGWR trace file was complaining slow LGWR: *** 2016-08-05 22:08:21.187 Warning: log write elapsed time 103557ms, size 229KB *** 2016-08-05 22:09:49.053 Warning: log write elapsed time 87866ms, size 181KB bps is extremely low (smaller than 1M) although I/O utility has reached almost 100% iostat -D… Continue reading Suspicious slow I/O actually may not be an issue