Sundaramurthy Blog

February 1, 2010

writing to alert log

Filed under: Oracle commands — sundar5 @ 8:17 pm

SQL>  exec sys.dbms_system.ksdwrt(2, ‘Testing writting to alert log‘);

PL/SQL procedure successfully completed.

SQL>

$tail -f alert_turn2.log

Mon Feb  1 12:11:12 2010
Thread 1 advanced to log sequence 267582 (LGWR switch)
Current log# 1 seq# 267582 mem# 0: /turndb2/01/turn2/database/redo01.log
Current log# 1 seq# 267582 mem# 1: /turndb2/01/turn2/database/redo01b.log
Mon Feb  1 12:11:21 2010

Testing writting to alert log

exec sys.dbms_system.ksdwrt(2, ‘Testing writting to alert log‘);

where

* 1 – Write to trace file.
* 2 – Write to alertlog.
* 3 – Write to both.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: