Set maximum forms sessions limit

Asked By s_nelson96 0 points N/A Posted on - 07/22/2011

Hi everyone,

For two years, I used Oracle database 10g and I am familiar with it but I am a new to Oracle Application Server 10g Release2, I have installed and deployed Oracle Forms 10g Applications on Oracle Application server. Where can I set the max session limit? Moreover how can I check “memory usage of forms session”?

Regards.

• Status: Open
• Question Views: 2987
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By zahidjunnun 0 points N/A #84977

Set maximum forms sessions limit

Hi,

Please check this out I think It could help you to set max session limit.

set linesize 121
col name format a30
col value format a30

SELECT name, value
FROM gv$parameter
WHERE name = 'resource_limit';

ALTER SYSTEM SET resource_limit=TRUE SCOPE=BOTH;

SELECT name, value
FROM gv$parameter
WHERE name = 'resource_limit';

CPU_PER_SESSION	Maximum CPU time per session (100ths of a second) cpu_per_session <value | UNLIMITED | DEFAULT>
	ALTER PROFILE developer LIMIT cpu_per_session UNLIMITED;

 

SESSIONS_PER_USER	Number of concurrent multiple sessions allowed per user sessions_per_user <value | UNLIMITED | DEFAULT>
	ALTER PROFILE developer LIMIT sessions_per_user 1;

You can also take help from this website:

Thanks.

About zahidjunnun

Questions
1

Answers
6

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/04/2011
• Question Category: Oracle Database