No question at this time
DBA Top 10
1 M. Cadot 20800
2 A. Kavsek 14900
3 M. Hidayathullah ... 10800
4 B. Vroman 7900
5 P. Wisse 5300
6 T. Boles 4200
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1600
10 A. Hudspith 1500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48052
Total active users1733
Act. users last 24h10
Act. users last hour1
Registered user hits last week395
Registered user hits last month1204
Go up

maximum processes
Next thread: DB Validation
Prev thread: oracle to mysql migration

Message Score Author Date
Hi Guys I have the database server that keeps o...... Tso P Oct 12, 2017, 14:26
Hi Tso, please check link below, not exactly sa...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Mirza Hidayathullah Baig Oct 12, 2017, 15:42
Hello Tso, if I understand, your issue is at OS...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Oct 12, 2017, 18:29

Follow up by mail Click here


Subject: maximum processes
Author: Tso P, South Africa
Date: Oct 12, 2017, 14:26, 4 days ago
Os info: solaris 10
Oracle info: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Message: Hi Guys

I have the database server that keeps on giving me issues. Every time we have about 700 processes we can't fork new processes.

How do I see what is the maximum processes that can run simultaneously on the server?

Please help!!!!

Thanks in advance...
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: maximum processes
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Oct 12, 2017, 15:42, 4 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Tso,

please check link below, not exactly same but similar issue has discussed

https://community.oracle.com/thread/2212062

check below for process parameter.

https://asktom.oracle.com/pls/asktom/asktom.search?tag=oracle-process-parameter

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: maximum processes
Author: Bruno Vroman, Belgium
Date: Oct 12, 2017, 18:29, 4 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hello Tso,

if I understand, your issue is at OS level, about the resources allocated to the user running the database (presumably "oracle"). In this case you have to talk with your system administrator.

If your issue is at database level, changing the value of init parameters can be the thing to do. To have an idea of the current usage and maximum usage seen since startup for some resources, you can run the following:
SET PAGES 32000 LINES 130

COL limit FOR A12
COL pctmax FOR 990.0
SELECT resource_name, current_utilization current_used, max_utilization max_used, limit_value limit
, CASE WHEN TRIM( limit_value ) = 'UNLIMITED' THEN 0
WHEN TRIM( limit_value ) = '0' THEN 0
ELSE max_utilization * 100 / TO_NUMBER( limit_value )
END pctmax
FROM v$resource_limit
ORDER BY 1;
Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here