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.
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.