Листинг 6. Реализация возможности AUTOTRACE

SQL> 	SET AUTOTRACE ON

SQL> 	SELECT COUNT(NAME) FROM EMP7 WHERE NAME = 'BRANCHES';



Output: 

COUNT(NAME)

100



Execution Plan

0		SELECT		STATEMENT Optimizer=CHOOSE 

1		0		SORT (AGGREGATE) 

2		1		INDEX (RANGE SCAN) OF 'EMP7_I1' (NON-UNIQUE)



Statistics

		0	recursive calls

		0	db block gets

		1	consistent gets

		1	physical reads 

		1	sorts (memory)

		0	sorts (disk)

		1	rows processed