For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
While executing procedure it is taking more time. during finding found that 'DB file sequential read" wait event.More over two tables having high clustering factor on index.