Re: Keep losing connection to database automatically???

From: Maurício Bellissimo Falleiros <mbf_at_uniconsult.com.br>
Date: Mon, 04 Oct 1999 11:47:10 -0300
Message-ID: <37F8BDEE.4AD475A_at_uniconsult.com.br>

Hi Ashish,

Do you have a profile associated to your user? There are some parameters there that might be responsible for the disconnection...

An excert of CREATE PROFILE help follows... ...
SESSIONS_PER_USER
    limits a user to integer concurrent sessions.

CPU_PER_SESSION
    limits the CPU time for a session. This value is expressed in     hundredths of seconds.

CPU_PER_CALL
    limits the CPU time for a call (a parse, execute, or fetch). This     value is expressed in hundredths of seconds.

CONNECT_TIME
    limits the total elapsed time of a session. This value is expressed     in minutes.

IDLE_TIME
    limits periods of continuous inactive time during a session. This     value is expressed in minutes. Long-running queries and other     operations are not subject to this limit.

LOGICAL_READS_PER_SESSION
    limits the number of data blocks read in a session, including blocks     read from memory and disk, to integer blocks.

LOGICAL_READS_PER_CALL
    limits the number of data blocks read for a call to process a SQL     statement (a parse, execute, or fetch) to integer blocks.

PRIVATE_SGA
    limits the amount of private space a session can allocate in the     shared pool of the System Global Area (SGA) to integer bytes. You     can also use the K or M to specify this limit in kilobytes or     megabytes. This limit only applies if you are using the multithreaded      server architecture. The private space for a session in     the SGA includes private SQL and PL/SQL areas, but not shared SQL     and PL/SQL areas.

COMPOSITE_LIMIT
    limits the total resource cost for a session. You must express the     value of this parameter in service units.

    Oracle calculates the total resource cost as a weighted sum of these     resources:

• CPU_PER_SESSION
• CONNECT_TIME
• LOGICAL_READS_PER_SESSION
• PRIVATE_SGA

    For information on how to specify the weight for each session     resource see the ALTER RESOURCE COST command.

UNLIMITED
    indicates that a user assigned this profile can use an unlimited     amount of this resource.

DEFAULT
    omits a limit for this resource in this profile. A user assigned     this profile is subject to the limit for this resource specified in     the DEFAULT profile.

Hope this helps,
Maurício.

-- 
Maurício Bellissimo Falleiros <mailto:mbf_at_uniconsult.com.br>

Uniconsult Sistemas e Serviços <mailto:uss_at_uniconsult.com.br>
R. Demóstenes, 627 cj.134/142 - Campo Belo - São Paulo/SP - 04614-013
Brasil
Fone/Fax: +55-11-5350885 +55-11-5333335

"Em um minuto apenas há tempo
Para decisões e revisões que um minuto revoga."
T.S.Eliot



* Sent from RemarQ http://www.remarq.com * The Internet's Discussion Network *
*  The fastest and easiest way to search and participate in Usenet - Free!   *

Received on Mon Oct 04 1999 - 16:47:10 CEST