Can We use threading in PL/SQL?

by

+1 for DBMS_SCHEDULER and DBMS_JOB approaches, but also consider whether you ought to be using a different approach.

If you have a procedure which executes in a row-by-row manner and you find that it is slow, the answer is probably not to run the procedure multiple times simltaneously but to ensure that a set-based aproach is used instead. At an extreme you can even then use parallel query and parallel DML to reduce the wall clock time of the process.

I mention this only because it is a very common fault.

More Related Contents:

  1. What is the replacement of cursor foreach in oracle pl/sql?
  2. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  3. Printing the value of a variable in SQL Developer
  4. PL/SQL, how to escape single quote in a string?
  5. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  6. Passing an array of data as an input parameter to an Oracle procedure
  7. Convert comma separated string to array in PL/SQL
  8. UTL_FILE.FOPEN() procedure not accepting path for directory?
  9. Oracle stored procedure with parameters for IN clause
  10. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  11. Get resultset from oracle stored procedure
  12. Oracle PL/SQL – How to create a simple array variable?
  13. ways to avoid global temp tables in oracle
  14. Split function in oracle to comma separated values with automatic sequence
  15. check if “it’s a number” function in Oracle
  16. ORA-06508: PL/SQL: could not find program unit being called
  17. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  18. Create Pivot view in SQL from a SQL table
  19. SQL*Plus how to accept text variable from prompt?
  20. Why doesn’t PL/SQL respect privileges granted by Roles?
  21. if (select count(column) from table) > 0 then
  22. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  23. What is the algorithm used by the ORA_HASH function?
  24. passing in table name as plsql parameter
  25. Reading clob line by line with pl\sql
  26. How to use parameters in a ‘where value in…’ clause?
  27. Why cannot I create triggers on objects owned by SYS?
  28. automating rollback script oracle
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. Escaping single quote in PLSQL

Leave a Comment