VIEW: SYS.EXU7PRR

Source

View Text - Preformatted

SELECT profile#, DECODE(resource#,
		0, 'COMPOSITE_LIMIT',
		1, 'SESSIONS_PER_USER',
		2, 'CPU_PER_SESSION',
		3, 'CPU_PER_CALL',
		4, 'LOGICAL_READS_PER_SESSION',
		5, 'LOGICAL_READS_PER_CALL',
		6, 'IDLE_TIME',
		7, 'CONNECT_TIME',
		8, 'PRIVATE_SGA', 'UNDEFINED'), limit#
	FROM sys.profile$
	WHERE resource# != 9 and type# = 0

View Text - HTML Formatted

SELECT PROFILE#
, DECODE(RESOURCE#
, 0
, 'COMPOSITE_LIMIT'
, 1
, 'SESSIONS_PER_USER'
, 2
, 'CPU_PER_SESSION'
, 3
, 'CPU_PER_CALL'
, 4
, 'LOGICAL_READS_PER_SESSION'
, 5
, 'LOGICAL_READS_PER_CALL'
, 6
, 'IDLE_TIME'
, 7
, 'CONNECT_TIME'
, 8
, 'PRIVATE_SGA'
, 'UNDEFINED')
, LIMIT# FROM SYS.PROFILE$ WHERE RESOURCE# != 9
AND TYPE# = 0