OraFAQ Forum: Server Administration » Alternative to dbms

Home » RDBMS Server » Server Administration » Alternative to dbms_system.ksdwrt (db 11.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Alternative to dbms_system.ksdwrt [message #584639]

Thu, 16 May 2013 08:33

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

I can write a message to the alert log and/or a trace file with dbms_system.ksdwrt (if anyone isn't familiar with this procedure, the first argument is either 1 for a trace file, 2 for the alert log, or 3 for both; the second argument is the message) but dbms_system isn't documented so one really shouldn't use it. Is there an alternative way of doing this?

Thank you for any insight.

Report message to a moderator

Re: Alternative to dbms_system.ksdwrt [message #584652 is a reply to message #584639]

Thu, 16 May 2013 09:51

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Hmm, you can write your own procedure to write into the alert.log in append mode.
Of course, you have no more the protection of the Oracle internal locking that prevents 2 of its processes writing at the same time, so if you are unlucky...

If you really need it, I'd go with dbms_system; it is there since at least version 7 and internally used by Oracle processes, so I think there is not so much risk to use it.

Regards
Michel

Report message to a moderator

Re: Alternative to dbms_system.ksdwrt [message #584768 is a reply to message #584652]

Fri, 17 May 2013 09:25

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Thank you for replying - I agree. The only alternative seems to be using utl_file, and I really don't want to do that.

Report message to a moderator

Previous Topic:	ORA-01034 received when to install
Next Topic:	upgrade from 11.1.0.7 to 11.2.0.3 taking long time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 23:46:48 CST 2024