1366133.1 SQLHC 11.4.4.1 Report: sqlhc_jde900_jdedb_11.2.0.3.0_ccvq8pqppq5ag_20130819005718.html

License : "y"
SQL_ID  : "ccvq8pqppq5ag"
RDBMS   : "11.2.0.3.0"
Platform: "LINUX"
OFE     : "11.2.0.3"
DYN_SAMP: "2"
EBS:      ""
SIEBEL  : ""
PSFT    : ""
Date    : "2013-08-19/00:57:18"

Observations

Observations below are the outcome of several heath-checks on the schema objects accessed by your SQL and its environment. Review them carefully and take action when appropriate. Then re-execute your SQL and generate this report again.

#	Type	Name	Observation	More
1	CBO PARAMETER	DEFERRED_SEGMENT_CREATION	CBO initialization parameter "deferred_segment_creation" with a non-default value of "false" as per V$SYS_OPTIMIZER_ENV.	Review the correctness of this non-default value "false". Unset this parameter unless there is a strong reason for keeping its current value. Default value is "true" as per V$SYS_OPTIMIZER_ENV.
2	CBO PARAMETER	_PGA_MAX_SIZE	CBO initialization parameter "_pga_max_size" with a non-default value of "1428680 KB" as per V$SYS_OPTIMIZER_ENV.	Review the correctness of this non-default value "1428680 KB". Unset this parameter unless there is a strong reason for keeping its current value. Default value is "204800 KB" as per V$SYS_OPTIMIZER_ENV.
3	DBMS_STATS	DBA_AUTOTASK_CLIENT	Automatic gathering of CBO statistics is enabled.	Be aware that small sample sizes could produce poor quality histograms, which combined with bind sensitive predicates could render suboptimal plans. See 465787.1.
4	DBMS_STATS	SYSTEM STATISTICS	Workload CBO System Statistics are not gathered. CBO is using default values.	Consider gathering workload system statistics using DBMS_STATS.GATHER_SYSTEM_STATS. See also 465787.1.

SQL Text

UPDATE PRODDTA.F0911  SET GLPOST=:BND1,GLALT4=:BND2,GLUSER=:BND3,GLPID=:BND4,GLJOBN=:BND5,GLUPMJ=:BND6,GLUPMT=:BND7 WHERE  ( GLPOST = :KEY1 AND GLICUT = :KEY2 AND GLICU = :KEY3 )

Tables Summary

Values below have two purposes:
1. Provide a quick view of the state of Table level CBO statistics, as well as their indexes and columns.
2. Ease a compare between two systems that are believed to be similar.

#	Table Name	Owner	Num Rows	Table Sample Size	Last Analyzed	Indexes	Avg Index Sample Size	Table Columns	Columns with Histogram	Avg Column Sample Size

Indexes Summary

Values below have two purposes:
1. Provide a quick view of the state of Index level CBO statistics, as well as their columns.
2. Ease a compare between two systems that are believed to be similar.

#	Table Name	Table Owner	Index Name	Index Owner	In MEM Plan	In AWR Plan	Num Rows	Index Sample Size	Last Analyzed	Index Columns	Columns with Histogram	Avg Column Sample Size

Current SQL Statistics (GV$SQL)

Performance metrics of child cursors of ccvq8pqppq5ag while still in memory.

#	Inst ID	Child Num	Plan HV	Execs	Fetch	Loads	Inval	Parse Calls	Buffer Gets	Disk Reads	Direct Writes	Rows Proc	Elapsed Time (secs)	CPU Time (secs)	IO Time (secs)	Conc Time (secs)	Appl Time (secs)	Clus Time (secs)	PLSQL Time (secs)	Java Time (secs)	Optimizer Mode	Cost	Opt Env HV	Parsing Schema Name	Module	Action	Outline	Profile	First Load	Last Load	Last Active

Historical SQL Statistics (DBA_HIST_SQLSTAT)

Performance metrics of execution plans of ccvq8pqppq5ag captured by AWR.

#	Snap ID	Snaphot	Inst ID	Plan HV	Vers Cnt	Execs	Fetch	Loads	Inval	Parse Calls	Buffer Gets	Disk Reads	Direct Writes	Rows Proc	Elapsed Time (secs)	CPU Time (secs)	IO Time (secs)	Conc Time (secs)	Appl Time (secs)	Clus Time (secs)	PLSQL Time (secs)	Java Time (secs)	Optimizer Mode	Cost	Opt Env HV	Parsing Schema Name	Module	Action	Profile

Current Execution Plans (last execution)

Captured while still in memory. Metrics below are for the last execution of each child cursor.
If STATISTICS_LEVEL was set to ALL at the time of the hard-parse then A-Rows column is populated.

Current Execution Plans (all executions)

Captured while still in memory. Metrics below are an aggregate for all the execution of each child cursor.
If STATISTICS_LEVEL was set to ALL at the time of the hard-parse then A-Rows column is populated.

Historical Execution Plans

Captured by AWR.

1366133.1 SQLHC 11.4.4.1 2013-08-19/00:57:18