Home » RDBMS Server » Server Administration » Alternative to dbms_system.ksdwrt (db 11.2.0.3)
Alternative to dbms_system.ksdwrt [message #584639] Thu, 16 May 2013 08:33 Go to next message
John Watson
Messages: 4088
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.
Re: Alternative to dbms_system.ksdwrt [message #584652 is a reply to message #584639] Thu, 16 May 2013 09:51 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Alternative to dbms_system.ksdwrt [message #584768 is a reply to message #584652] Fri, 17 May 2013 09:25 Go to previous message
John Watson
Messages: 4088
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.
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:
  


Current Time: Sun Apr 20 08:13:43 CDT 2014

Total time taken to generate the page: 0.07834 seconds