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!
show parameter processes
Thanks a lot for your helf and that awesome support!
alter system set processes = 5000 scope=SPFILE;
there are 70% of Process usage by 10 Tablespaces at every timeHonestly 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 ?