.net - Multi threading Concept in Oracle pl/sql -

.net - Multi threading Concept in Oracle pl/sql -

i created procedure, takes input in form of array, beingness passed .net web application.

in procedure: open cursor containing info in table, fetching info cursor row row , apply validation rules on it.

for each row need multiple hits db (almost containing nested queries); if info validation fails update remarks field in same table (by using update query immediately), , if validation successful inserting/updating info in other table.

i tried on 0.25 1000000 records, , noticed takes more 1 hr process it.

i need improve performance of stored procedure. please allow me know how accomplish this.

i have thought this.

making multiple sets of record (10 k in each set) , process each set way utilize multi threading.

is possible? if yes how?

very likely, procedure can made faster utilize of pl/sql batch processing capabilities. run code in parallel, @ dbms_job , dbms_scheduler packages. also, check if parts of code can speed parallel query and/or parallel dml. line line slowest thing, if used explicit cursor.

.net multithreading oracle stored-procedures plsql