1 2 Previous Next 16 Replies Latest reply: Mar 18, 2013 9:34 AM by Nicolas.Gasparotto Go to original post RSS
      • 15. Re: Process Usage is at 70% in normal status
        David_Pasternak
        I was just thinking some more about the problem: The SQL Stantement at beginning shows the percentage of the used maximum processes, that Oracle can execute. So i've looked for the processes parameter:
        show parameter processes
        There i've seen that there is a standard parameter configured at 150. And thats shourly not enough, our old database server with Oracle 10g has 5000 configured!

        So i've changed that parameter and everything is fine again!!!
        alter system set processes = 5000 scope=SPFILE;
        Thanks a lot for your helf and that awesome support!

        Regards,
        David
        • 16. Re: Process Usage is at 70% in normal status
          Nicolas.Gasparotto
          there are 70% of Process usage by 10 Tablespaces at every time
          Honestly I even do not understand that sentence. How do link tablespace and process usage... ? And what is going to the picture the number of processes ? Why 5000 ? How can we ever say that's good or not ?
          Briefly speaking, what's the problem which leads you in creating this thread ?

          Nicolas.
          1 2 Previous Next