행위

오라클 코어 - 조나단 루이스

DB CAFE

Dbcafe (토론 | 기여)님의 2024년 5월 7일 (화) 23:51 판 (→‎관련 스크립트)
thumb_up 추천메뉴 바로가기

1 Oracle Core Essential Internals for DBAs and Developers (Apress)[편집]

1.1 관련 스크립트[편집]

1.1.1 core_demo_02.sql (19c 버전에서 sql에러 발생으로 sql 수정함.)[편집]

rem
rem	Script:		core_demo_02.sql
rem	Author:		Jonathan Lewis
rem	Dated:		Feb 2011
rem	Purpose:	
rem
rem	Last tested 
rem		11.2.0.2
rem		10.2.0.3		
rem	Not relevant
rem		 9.2.0.8
rem		 8.1.7.4
rem
rem	Notes:
rem	Can only be run as SYS in this form
rem
rem	Diagnostics for core undo/redo concepts
rem

column indx format 9999

--	Size of in-memory undo and private redo after a small change

-- 19c 버전에서 에러 발생 
-- select
-- 	indx,
-- 	to_number(ktifpupe,'XXXXXXXX') -
-- 	to_number(ktifpupb,'XXXXXXXX')	undo_size,
-- 	to_number(ktifpupc,'XXXXXXXX') -
-- 		to_number(ktifpupb,'XXXXXXXX')	undo_usage,
-- 	to_number(ktifprpe,'XXXXXXXX') -
-- 		to_number(ktifprpb,'XXXXXXXX')	redo_size,
-- 	to_number(ktifprpc,'XXXXXXXX') -
-- 		to_number(ktifprpb,'XXXXXXXX')	redo_usage
-- 	from
-- 		x$ktifp
-- ;

-- 19c 버전에서 실행 
select indx,
-- KTIFPTXFLG,ADDR,KTIFPNO, KTIFPSTA, KTIFPXCB xctaddr,
  to_number(KTIFPUPE, 'XXXXXXXXXXXXXXXX') -
  to_number(KTIFPUPB, 'XXXXXXXXXXXXXXXX') undo_size,
  (to_number(KTIFPUPB, 'XXXXXXXXXXXXXXXX') -  to_number(KTIFPUPC, 'XXXXXXXXXXXXXXXX'))*-1 undo_usage,
  to_number(KTIFPRPE, 'XXXXXXXXXXXXXXXX') - to_number(KTIFPRPB, 'XXXXXXXXXXXXXXXX') redo_size,
  (to_number(KTIFPRPB, 'XXXXXXXXXXXXXXXX') -to_number(KTIFPRPC, 'XXXXXXXXXXXXXXXX'))*-1 redo_usage
--  , KTIFPPSI,KTIFPRBS,KTIFPTCN
 from x$ktifp
;


--	Sizes of private redo


select
	indx,
	PNEXT_BUF_KCRFA_CLN,
	PTR_KCRF_PVT_STRAND,
	FIRST_BUF_KCRFA,
	LAST_BUF_KCRFA,
--	LASTCHANGE_KCRFA,			not available in 11.2
	STRAND_SIZE_KCRFA	strand_size,
	SPACE_KCRF_PVT_STRAND	strand_space
from
	x$kcrfstrand
;
원본 주소 "http://dbcafe.co.kr/wiki/index.php?title=오라클_코어_-_조나단_루이스&oldid=11535"