WHEN DO I NEED TO INCREASE THE NUMBER OF ARCHIVE PROCESSES ?
This is not a problem at this moment but just want to prevent ahead.
The current processes are the following.
SQL> !ps -ef | grep ora_
oracle 4805 1 0 Jul 25 ? 552:43 ora_i10a_xappsprd
oracle 4795 1 0 Jul 25 ? 671:18 ora_i105_xappsprd
oracle 4799 1 0 Jul 25 ? 646:00 ora_i107_xappsprd
oracle 4797 1 0 Jul 25 ? 672:16 ora_i106_xappsprd
oracle 29675 1 0 Oct 02 ? 0:01 ora_q003_xappsprd
oracle 4727 1 5 Jul 25 ? 1206:35 ora_arc1_xappsprd
oracle 10495 1 0 18:30:07 ? 0:00 ora_q002_xappsprd
oracle 4725 1 0 Jul 25 ? 1202:25 ora_arc0_xappsprd
oracle 18289 16826 0 12:07:23 pts/3 0:00 grep ora_
oracle 4807 1 0 Jul 25 ? 523:45 ora_i10b_xappsprd
oracle 4793 1 0 Jul 25 ? 677:58 ora_i104_xappsprd
oracle 4717 1 0 Jul 25 ? 66:52 ora_cjq0_xappsprd
oracle 4791 1 0 Jul 25 ? 822:08 ora_i103_xappsprd
oracle 4801 1 0 Jul 25 ? 617:10 ora_i108_xappsprd
oracle 4733 1 0 Jul 25 ? 0:00 ora_qmnc_xappsprd
The current processes are the following.
SQL> !ps -ef | grep ora_
oracle 4805 1 0 Jul 25 ? 552:43 ora_i10a_xappsprd
oracle 4795 1 0 Jul 25 ? 671:18 ora_i105_xappsprd
oracle 4799 1 0 Jul 25 ? 646:00 ora_i107_xappsprd
oracle 4797 1 0 Jul 25 ? 672:16 ora_i106_xappsprd
oracle 29675 1 0 Oct 02 ? 0:01 ora_q003_xappsprd
oracle 4727 1 5 Jul 25 ? 1206:35 ora_arc1_xappsprd
oracle 10495 1 0 18:30:07 ? 0:00 ora_q002_xappsprd
oracle 4725 1 0 Jul 25 ? 1202:25 ora_arc0_xappsprd
oracle 18289 16826 0 12:07:23 pts/3 0:00 grep ora_
oracle 4807 1 0 Jul 25 ? 523:45 ora_i10b_xappsprd
oracle 4793 1 0 Jul 25 ? 677:58 ora_i104_xappsprd
oracle 4717 1 0 Jul 25 ? 66:52 ora_cjq0_xappsprd
oracle 4791 1 0 Jul 25 ? 822:08 ora_i103_xappsprd
oracle 4801 1 0 Jul 25 ? 617:10 ora_i108_xappsprd
oracle 4733 1 0 Jul 25 ? 0:00 ora_qmnc_xappsprd
0