Вернуться

Скрипт 7. Мониторинг использования сегментов отката

SELECT	SUBSTR(v$rollname.name,1,12)		"ROLLNAME"
	,MIN(v$transaction.xidusn)			"ROLLNUM"
	,MIN(v$rollstat.xacts)				"TRANSACTIONS"
	,SUM(v$transaction.used_ublk)			"Used, blocks"
	,MIN(v$rollstat.rssize/db_block_size.value)	"Size, blocks"
	,MIN(v$rollstat.hwmsize/db_block_size.value)	"HWM, blocks"
FROM	v$rollname
	,v$transaction
	,v$rollstat
	,(select to_number(value) value
  	from sys.v_$parameter
	where name='db_block_size'
  	) db_block_size
WHERE	(v$transaction.xidusn=v$rollname.usn)
	 and (v$rollstat.usn=v$rollname.usn)
GROUP BY v$rollname.name
	,v$rollstat.xacts
	,v$rollstat.rssize/db_block_size.value
  	,v$rollstat.hwmsize/db_block_size.value
	,v$transaction.xidusn
;

Вернуться