Can user run two scripts at the same time to reorg objects?
You can run two scripts at the same time as long as you're not reorging the same table. The best practice is not to reorg objects that have a foreign key link to another table, it may cause problems. You should not run more than 2 scripts, this also depends upon the object size and the amount of resource available, so if your objects are huge, then running two scripts may take a little longer.
In addition, there is the scheduler process (qexecd) which runs all the time and is what schedules and runs scripts. When a script is run the scheduler forks (process duplicates itself) and the forked process runs sqlexe. Sqlexe is multi-threaded and creates many threads. About 10 threads, maybe more or less depending on many factors. When a connection is made to the Oracle database, Oracle creates many processes. A LiveReorg script will create around 5 connections to Oracle. More or less depending on many factors.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center