June 2, 2002

Real-time Messaging in Oracle: Send E-mails Programmatically from the Database

ecause Oracle does not provide a tool for outputting messages in real-time, Oracle database developers have always faced the challenge of monitoring their stored procedure execution in real-time. They’ve had to use the DBMS_OUTPUT.PUT_LINE call, which doesn’t return the results of a procedure until the procedure has completed. In this

Control Log File Growth to Avoid Out-of-Space Errors

he first step in my initiation as a SQL Server admin came after only a week or two on the job. I was confronted with a message that made my palms sweat. The error read something like this:Error: 1105, Severity: 17, State: 2: Could not allocate space forthe transaction log