Oracle : Scheduling crontab to send EMAIL in Unix

Oracle : Scheduling crontab to send EMAIL in Unix $ vi test.bash

Crontab entry

  Updated Script.

    Crontab entry

   

DDL Wait Option in Oracle.

DDL Wait Option in Oracle. A DBA is trying to alter the table called SALES to add a column, TAX_CODE. he issues the following SQL statement:

But instead of getting something like “Table altered”, he gets:

The error message says it all: the… Read More

Performance Tuning-Part5

We have discussed on How Optimizer works in our previous article. Please find the article here Performance Tuning – Part4 Now we will discuss about the SQL Tuning. SQL TUNING   Before going into how to perform SQL Tuning, let us begin with Thumb Rules… Read More