Delete oracle table from UNIX script

Shell Programming and Scripting
1

Hi,
Is it possible to delete oracle table datas using a UNIX script/Shell script?
how can we do this??
I have oracle Database and i have to delete millions of record everyday.. adn it is taking hours togather to execute this. Will the delete query triggered from UNIX be faster can we expect any performance improvement?

2

No,
the delete performance has nothing to do with the fact that it's executed via shell script, rather than sqlplus or some other API.

A few thoughts:

  1. If you delete every record in the table it is worth verifying if truncating the table is more appropriate.

  2. If multiple partitions of a partitioned table are involved, try parallelizing the delete operation.

  3. Verify if it is possible to implement partitioning, if not already implemented, and remove the data by dropping the unused partitions.

  4. Check the wait events your operation is waiting on; the system optimization should be based on those events.

  5. Check for before/after delete triggers defined on the table.