Help - Search - Members - Calendar
Full Version: Profile
Oracle DBA Forums > Oracle > Oracle Forum
Vugar
I dont understood profile

CPU_PER_CALL,CPU_PER_SESSION,COMPOSITE_LIMIT,PRIVATE_SGA.Please understood me
dave
arent they obvious?
dba@mumbai
Hi,

Find this

CPU_PER_CALL

Specify the CPU time limit for a call (a parse, execute, or fetch), expressed in hundredths of seconds.

CPU_PER_SESSION

Specify the CPU time limit for a session, expressed in hundredth of seconds.

PRIVATE_SGA

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.

COMPOSITE_LIMIT

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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.