Jun 27 2008, 12:14 PM
I dont understood profile
CPU_PER_CALL,CPU_PER_SESSION,COMPOSITE_LIMIT,PRIVATE_SGA.Please understood me
Jul 7 2008, 01:54 AM
Specify the CPU time limit for a call (a parse, execute, or fetch), expressed in hundredths of seconds.
Specify the CPU time limit for a session, expressed in hundredth of seconds.
Specify the amount of private space a session can allocate in the shared pool of the system global area (SGA), expressed in bytes.
This limit applies only if you are using shared 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.
Specify the total resource cost for a session, expressed in service units. Oracle Database calculates the total service units as a weighted sum of CPU_PER_SESSION, CONNECT_TIME, LOGICAL_READS_PER_SESSION, and PRIVATE_SGA.