Database Reference
In-Depth Information
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.1')
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
INDEX(@"SEL$1" "L"@"SEL$1" ("LOCATIONS"."CITY"))
INDEX(@"SEL$1" "D"@"SEL$1" ("DEPARTMENTS"."LOCATION_ID"))
INDEX(@"SEL$1" "EMP"@"SEL$1" ("EMPLOYEES"."DEPARTMENT_ID"))
INDEX(@"SEL$1" "J"@"SEL$1" ("JOBS"."JOB_ID"))
INDEX(@"SEL$1" "MGR"@"SEL$1" ("EMPLOYEES"."EMPLOYEE_ID"))
LEADING(@"SEL$1" "L"@"SEL$1" "D"@"SEL$1" "EMP"@"SEL$1" "J"@"SEL$1" "MGR"@"SEL$1")
USE_NL(@"SEL$1" "D"@"SEL$1")
USE_NL(@"SEL$1" "EMP"@"SEL$1")
USE_NL(@"SEL$1" "J"@"SEL$1")
USE_NL(@"SEL$1" "MGR"@"SEL$1")
END_OUTLINE_DATA
*/
Source Code Depot
Table 7-3 lists this chapter's source files and their functionality.
Table 7-3.
Event 10053 Source Code Depot
File Name
Functionality
hr_5way_join.sql
5-way join of tables in the sample schema HR
set_system_stats.sql
This script sets workload system statistics in the
data dictionary
gather_get_system_stats.sql
This script collects system statistics during several
subsequent intervals (default: 4 intervals, 15 minutes
each) and stores them in a statistics table outside of
the data dictionary
hr.dmp
Conventional export dump file that contains tables
from the sample schema HR (created with Oracle10
g
Release 2)
