Trace Analyzer 11.2 Report: trcanlzr_84029.html

app10g_ora_19065.trc (3448653 bytes)
Total Trace Response Time: 1138.932 secs.
2008-JUN-13 13:43:54.298 (start of first db call in trace).
2008-JUN-13 14:02:53.230 (end of last db call in trace).

Glossary of Terms Used
Response Time Summary
Overall Time and Totals
Non-Recursive Time and Totals
Recursive Time and Totals
Top SQL
Non-Recursive SQL
SQL Genealogy
Individual SQL
Overall Segment I/O Wait Summary
Hot I/O Blocks
Gaps in Trace
ORA errors in Trace
Transactions Summary
Non-default Initialization Params
Trace Header
Tool Execution Environment
Tool Configuration Parameters

Glossary of Terms Used

[+]

Response Time Summary

Response Time Component	Time (in secs)	pct of total resp time
CPU Time:	1138.496	100.0%
Non-idle Wait Time:	1.364	0.1%
Idle Wait Time:	1.899	0.2%
Response Time Unaccounted-for:	-2.827	-0.2%
Total Trace Response Time:	1138.932	100.0%

Trace Response Time Accounted-for = 1139.019
Back to Top

Overall Time and Totals (Non-Recursive and Recursive)

[-]

Call	Total Response Time³	Response Time Accounted-for²	Elapsed Time¹	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time	Response Time Unaccounted-for
Parse:		1.847	0.012	0.011	0.000	0.001	1.835
Execute:		1.400	1.400	1.439	0.000	-0.039	0.000
Fetch:		1135.773	1135.709	1137.046	1.364	-2.701	0.064
Total:	1138.932	1139.019	1137.120	1138.496	1.364	-2.740	1.899	-0.087

(1) Elapsed Time = "CPU Time" + "Non-Idle Wait Time" + "Elapsed Time Unaccounted-for".
(2) Response Time Accounted-for = "Elapsed Time" + "Idle Wait Time".
(3) Total Response Time = "Response Time Accounted-for" + "Response Time Unaccounted-for".

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	33	0	4	0	11	1	6
Execute:	5036	0	22	4	8	4	0
Fetch:	5047	488	619807	11317	0	493	4
Total:	10116	488	619833	11321	19	498	10

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time	Blocks	Average Blocks
SQL*Net message from client:	Idle			1.899	10	0.189862	1.078743
db file sequential read:	User I/O	1.364	488			0.002796	0.041973	488	1
SQL*Net message to client:	Network	0.000	10			0.000003	0.000004
Total:		1.364	498	1.899	10

Non-Recursive Time and Totals (depth = 0)

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.760	0.004	0.002	0.000	0.002	0.756
Execute:	0.271	0.271	0.254	0.000	0.017	0.000
Fetch:	1135.613	1135.550	1136.907	1.329	-2.686	0.064
Total:	1136.644	1135.825	1137.163	1.329	-2.667	0.820

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	7	0	0	0	6	1	5
Execute:	7	0	0	4	5	4	0
Fetch:	6	484	609726	38	0	489	4
Total:	20	484	609726	42	11	494	9

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time	Blocks	Average Blocks
db file sequential read:	User I/O	1.329	484			0.002745	0.041973	484	1
SQL*Net message from client:	Idle			0.820	9	0.091097	0.446061
SQL*Net message to client:	Network	0.000	10			0.000003	0.000004
Total:		1.329	494	0.820	9

Recursive Time and Totals (depth > 0)

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	1.087	0.008	0.009	0.000	-0.001	1.079
Execute:	1.129	1.129	1.185	0.000	-0.056	0.000
Fetch:	0.159	0.159	0.139	0.036	-0.015	0.000
Total:	2.375	1.296	1.333	0.036	-0.073	1.079

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	26	0	0	0	5	0	1
Execute:	5029	0	0	0	3	0	0
Fetch:	5041	4	10107	11279	0	4	0
Total:	10096	4	10107	11279	8	4	1

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time	Blocks	Average Blocks
SQL*Net message from client:	Idle			1.079	1	1.078743	1.078743
db file sequential read:	User I/O	0.036	4			0.008897	0.010518	4	1
Total:		0.036	4	1.079	1

Top SQL

[-]
There is only one SQL statement with "Response Time Accounted-for" larger than threshold of 5.0% of the "Trace Response Time Accounted-for".

Rank	Trace RT Pct¹	Self Response Time²	Elapsed Time	CPU Time	Non-Idle Wait Time	Idle Wait Time	Progeny Response Time³	Exec Count	User	Depth	SQL Text	Hash Value
1:	99.8%	1136.327	1135.817	1137.157	1.329	0.509	2.374	1	360	0	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717

(1) Percent of "Trace Response Time Accounted-for", which is 1139.019 secs.
(2) "Self Response Time Accounted-for" in secs (caused by this SQL statement).
(3) "Progeny Response Time Accounted-for" in secs (caused by recursive SQL invoked by this statement).
Back to Top

Non-Recursive SQL (depth = 0)

[-]
List of individual executions of non-recursive SQL in chronological order by first db call timestamp.

#	Total Response Time¹	Trace RT Pct²	Self Response Time³	Progeny Response Time⁴	User	SQL Text	Hash Value	Start Timestamp	End Timestamp
1:	1137.177	99.8%	1136.327	2.374	360	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_I	1504410717	2008-JUN-13 13:43:56.032	2008-JUN-13 14:02:53.209

(1) "Total Response Time" in secs, as per start and end timestamps of db calls. It includes "Unaccounted-for" times.
(1) This list is constrained by threshold configuration parameter with current value of 0.1s.
(2) Percent of "Trace Response Time Accounted-for", which is 1139.019 secs.
(3) "Self Response Time Accounted-for" in secs (caused by this non-recursive SQL statement).
(4) "Progeny Response Time Accounted-for" in secs (caused by recursive SQL invoked by this statement).
Back to Top

SQL Genealogy

[-]
Aggregate view of non-recursive SQL statements (depth = 0) and their recursive SQL at all depths.

#	Trace RT Pct¹	Self Response Time²	Progeny Response Time³	Exec Count	User	Depth	SQL Text	Hash Value
1:	0.0%	0.003	0.000	1	360	0	BEGIN :A00 := 2043; END;	773382301
2:	0.0%	0.094	0.000	1	360	0	BEGIN :A01 := NULL; END;	258244595
3:	0.0%	0.199	0.000	1	360	0	BEGIN :A02 := NULL; END;	3091468126
4:	0.0%	0.005	0.000	1	360	0	BEGIN :A03 := NULL; END;	1894445249
5:	99.8%	1136.327	2.374	1	360	0	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.SECURITY_GROUP_ID, R	1504410717
6:	0.1%	1.080	0.000	5	0	1	. select text from view$ where rowid=:1	1398610540
7:	0.0%	0.001	0.000	2	0	1	. select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$	4216473919
8:	0.0%	0.002	0.000	2	0	1	. select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj#	3136611056
9:	0.0%	0.002	0.000	1	360	1	. SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROF	462069957
10:	0.0%	0.001	0.000	4	360	1	. SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG	2468783182
11:	0.1%	0.740	0.000	2502	360	1	. SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTIO	303338305
12:	0.0%	0.132	0.040	1250	360	1	. SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
13:	0.0%	0.021	0.000	1	0	2	... select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.	3159716790
14:	0.0%	0.000	0.000	1	0	2	... select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1	2280069326
15:	0.0%	0.000	0.000	1	0	2	... select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nv	2512561537
16:	0.0%	0.000	0.000	1	0	2	... select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.data	854877822
17:	0.0%	0.000	0.000	1	0	2	... select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL	2888850659
18:	0.0%	0.000	0.000	1	0	2	... select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1	1471956217
19:	0.0%	0.000	0.000	1	0	2	... select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0	2107929772
20:	0.0%	0.008	0.000	3	0	2	... select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1	3849548163
21:	0.0%	0.009	0.000	2	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
22:	0.0%	0.377	0.000	1250	360	1	. SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTIO	3575592451
23:	0.0%	0.016	0.000	1	360	0	select * from dual	942515969
24:	0.0%	0.000	0.000	1	0	1	. select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sampl	864012087
25:	0.0%	0.000	0.000	1	360	0	ALTER SESSION SET SQL_TRACE = FALSE	4067503723

Individual SQL

[-]
List of individual SQL in order of first appearance in trace.

#	Rank	Trace RT Pct¹	Self Response Time²	Elapsed Time	CPU Time	Non-Idle Wait Time	Idle Wait Time	Exec Count	User	Depth	SQL Text	Hash Value
1:	7	0.0%	0.094	0.001	0.002	0.000	0.093	1	360	0	BEGIN :A01 := NULL; END;	258244595
2:	13	0.0%	0.003	0.003	0.002	0.000	0.000	1	360	0	BEGIN :A00 := 2043; END;	773382301
3:	5	0.0%	0.199	0.001	0.001	0.000	0.198	1	360	0	BEGIN :A02 := NULL; END;	3091468126
4:	12	0.0%	0.005	0.001	0.001	0.000	0.004	1	360	0	BEGIN :A03 := NULL; END;	1894445249
5:	1	99.8%	1136.327	1135.817	1137.157	1.329	0.509	1	360	0	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
6:	2	0.1%	1.080	0.001	0.001	0.000	1.079	5	0	1	select text from view$ where rowid=:1	1398610540
7:	17	0.0%	0.001	0.001	0.001	0.000	0.000	2	0	1	select u.name, o.name, a.interface_version#, o.obj# from ass	4216473919
8:	14	0.0%	0.002	0.002	0.002	0.000	0.000	2	0	1	select a.default_cpu_cost, a.default_io_cost from associatio	3136611056
9:	15	0.0%	0.002	0.002	0.002	0.000	0.000	1	360	1	SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VAL	462069957
10:	16	0.0%	0.001	0.001	0.002	0.000	0.000	4	360	1	SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG	2468783182
11:	3	0.1%	0.740	0.740	0.747	0.000	0.000	2502	360	1	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES W	303338305
12:	8	0.0%	0.021	0.021	0.001	0.019	0.000	1	0	2	select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.fla	3159716790
13:	19	0.0%	0.000	0.000	0.000	0.000	0.000	1	0	2	select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where	2280069326
14:	20	0.0%	0.000	0.000	0.000	0.000	0.000	1	0	2	select name,intcol#,segcol#,type#,length,nvl(precision#,0),d	2512561537
15:	21	0.0%	0.000	0.000	0.001	0.000	0.000	1	0	2	select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,	854877822
16:	18	0.0%	0.000	0.000	0.000	0.000	0.000	1	0	2	select type#,blocks,extents,minexts,maxexts,extsize,extpct,u	2888850659
17:	23	0.0%	0.000	0.000	0.000	0.000	0.000	1	0	2	select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where	1471956217
18:	22	0.0%	0.000	0.000	0.000	0.000	0.000	1	0	2	select con#,type#,condlength,intcols,robj#,rcon#,match#,refa	2107929772
19:	11	0.0%	0.008	0.008	0.001	0.008	0.000	3	0	2	select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ whe	3849548163
20:	10	0.0%	0.010	0.010	0.002	0.009	0.000	3	0	2	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt,	864012087
21:	6	0.0%	0.132	0.132	0.150	0.000	0.000	1250	360	1	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
22:	4	0.0%	0.377	0.377	0.423	0.000	0.000	1250	360	1	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES W	3575592451
23:	9	0.0%	0.016	0.001	0.000	0.000	0.015	1	360	0	select * from dual	942515969
24:	24	0.0%	0.000	0.000	0.000	0.000	0.000	1	360	0	ALTER SESSION SET SQL_TRACE = FALSE	4067503723

(1) Percent of "Trace Response Time Accounted-for", which is 1139.019 secs.
(2) "Self Response Time Accounted-for" in secs (caused by this SQL statement).
Back to Top

258244595

Rank:7(0.0%) Self:0.094s Progeny:0.000s Invoker:360 Definer:360 Depth:0

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

BEGIN :A01 := NULL; END;

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.094	0.000	0.001	-0.001	0.093
Execute:	0.001	0.001	0.001	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000
Total:	0.094	0.001	0.002	-0.001	0.093

Call	Call Count	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	1	0	1	1	1
Execute:	1	1	1	1	0
Fetch:	0	0	0	0	0
Total:	2	1	2	2	1

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time
SQL*Net message from client:	Idle			0.093	1	0.093175	0.093175
SQL*Net message to client:	Network	0.000	2			0.000003	0.000003
Total:		0.000	2	0.093	1

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	1	VARCHAR2	0	(null)

773382301

Rank:13(0.0%) Self:0.003s Progeny:0.000s Invoker:360 Definer:360 Depth:0

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

BEGIN :A00 := 2043; END;

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Elapsed Time Unaccounted-for
Parse:	0.001	0.001	0.000	0.001
Execute:	0.002	0.002	0.002	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.003	0.003	0.002	0.001

Call	Call Count	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	1	0	1	0
Execute:	1	1	1	1
Fetch:	0	0	0	0
Total:	2	1	2	1

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time	Blocks	Average Blocks
SQL*Net message to client:	Network	0.000	1			0.000003	0.000003
Total:		0.000	1

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	2	NUMBER	0	(null)

3091468126

Rank:5(0.0%) Self:0.199s Progeny:0.000s Invoker:360 Definer:360 Depth:0

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

BEGIN :A02 := NULL; END;

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Idle Wait Time
Parse:	0.199	0.000	0.000	0.198
Execute:	0.001	0.001	0.001	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.199	0.001	0.001	0.198

Call	Call Count	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	1	0	1	0	1
Execute:	1	1	1	1	0
Fetch:	0	0	0	0	0
Total:	2	1	2	1	1

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time
SQL*Net message from client:	Idle			0.198	1	0.198344	0.198344
SQL*Net message to client:	Network	0.000	1			0.000003	0.000003
Total:		0.000	1	0.198	1

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	1	VARCHAR2	0	(null)

1894445249

Rank:12(0.0%) Self:0.005s Progeny:0.000s Invoker:360 Definer:360 Depth:0

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

BEGIN :A03 := NULL; END;

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Idle Wait Time
Parse:	0.004	0.000	0.000	0.004
Execute:	0.001	0.001	0.001	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.005	0.001	0.001	0.004

Call	Call Count	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	1	0	1	0	1
Execute:	1	1	1	1	0
Fetch:	0	0	0	0	0
Total:	2	1	2	1	1

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time
SQL*Net message from client:	Idle			0.004	1	0.003830	0.003830
SQL*Net message to client:	Network	0.000	1			0.000003	0.000003
Total:		0.000	1	0.004	1

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	2	NUMBER	0	(null)

1504410717

Rank:1(99.8%) Self:1136.327s Progeny:2.374s Invoker:360 Definer:360 Depth:0

SQL Self - Time, Totals, Waits, Binds and Row Source Plan
Explain Plan
Tables and Indexes
SQL Progeny - Time and Totals
Segment I/O Wait Summary

[-]

    SELECT  /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.SECURITY_GROUP_ID,
      R.RESPONSIBILITY_NAME, S.SECURITY_GROUP_NAME
    FROM
     FND_RESPONSIBILITY_VL R, FND_USER_RESP_GROUPS U, FND_SECURITY_GROUPS_VL S
      WHERE U.USER_ID = :A00 AND SYSDATE BETWEEN U.START_DATE AND
NVL(U.END_DATE,
      SYSDATE) AND R.VERSION IN ('4', 'W')  AND R.APPLICATION_ID =
      U.RESPONSIBILITY_APPLICATION_ID AND R.RESPONSIBILITY_ID =
      U.RESPONSIBILITY_ID AND SYSDATE BETWEEN R.START_DATE AND NVL(R.END_DATE,
      SYSDATE) AND U.SECURITY_GROUP_ID = S.SECURITY_GROUP_ID AND
      S.SECURITY_GROUP_ID >= 0 AND S.SECURITY_GROUP_KEY = NVL(:A01,
      S.SECURITY_GROUP_KEY) AND R.RESPONSIBILITY_KEY = NVL(:A02,
      R.RESPONSIBILITY_KEY) AND R.APPLICATION_ID = NVL(:A03, R.APPLICATION_ID)
      AND NVL(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'), 1) <=
      NVL(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL', U.USER_ID,
      R.RESPONSIBILITY_ID,R.APPLICATION_ID),1)   ORDER BY RESPONSIBILITY_NAME,
      SECURITY_GROUP_NAME

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.447	0.001	0.001	0.000	0.000	0.446
Execute:	0.267	0.267	0.249	0.000	0.018	0.000
Fetch:	1135.613	1135.550	1136.907	1.329	-2.686	0.063
Total:	1136.327	1135.817	1137.157	1.329	-2.669	0.509

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	1	0	0	0	1	0	1
Execute:	1	0	0	0	1	0	0
Fetch:	4	484	609723	37	0	488	3
Total:	6	484	609723	37	2	488	4

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time	Blocks	Average Blocks
db file sequential read:	User I/O	1.329	484			0.002745	0.041973	484	1
SQL*Net message from client:	Idle			0.509	4	0.127373	0.446061
SQL*Net message to client:	Network	0.000	4			0.000003	0.000004
Total:		1.329	488	0.509	4

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	2	NUMBER	3	2043
1:	1	VARCHAR2	0	(null)
2:	1	VARCHAR2	0	(null)
3:	2	NUMBER	0	(null)

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	37	SORT ORDER BY	619804	488	1136.842	0
2:	1	37	CONCATENATION	619804	488	90.111	0
3:	2	37	. FILTER	619804	488	90.111	0
4:	3	37	.. NESTED LOOPS	619804	488	90.110	0
5:	4	37	... NESTED LOOPS	619765	488	90.108	0
6:	5	37	.... NESTED LOOPS	619687	488	90.104	0
7:	6	1399	....+ NESTED LOOPS	615418	460	2435.162	0
8:	7	1250	....+. NESTED LOOPS	12610	16	3.411	0
9:	8	1250	....+.. NESTED LOOPS	10108	6	2.051	0
10:	9	1	....+... TABLE ACCESS BY INDEX ROWID FND_USER	3	2	0.029	524310
11:	10	1	....+.... INDEX UNIQUE SCAN FND_USER_U1	2	1	0.020	524317
12:	9	1250	....+... TABLE ACCESS FULL FND_RESPONSIBILITY	10105	4	2.016	524298
13:	8	1250	....+.. TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL	2502	10	0.154	524301
14:	13	1250	....+... INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U1	1252	0	0.020	524302
15:	7	1399	....+. PARTITION RANGE ALL PARTITION: 1 14	602808	444	1134.044	0
16:	15	1399	....+.. TABLE ACCESS BY LOCAL INDEX ROWID WF_USER_ROLE_ASSIGNMENTS PARTITION: 1 14	602808	444	1134.025	524424
17:	16	1850	....+... INDEX RANGE SCAN WF_USER_ROLE_ASSIGNMENTS_N2 PARTITION: 1 14	601251	415	1133.550	524454
18:	17	65000	....+.... TABLE ACCESS BY INDEX ROWID FND_APPLICATION	65001	0	924.786	524295
19:	18	65000	....+....+ INDEX UNIQUE SCAN FND_APPLICATION_U3	1	0	442.865	524297
20:	6	37	....+ PARTITION RANGE SINGLE PARTITION: 3 3	4269	28	0.307	0
21:	20	37	....+. TABLE ACCESS BY LOCAL INDEX ROWID WF_LOCAL_USER_ROLES PARTITION: 3 3	4269	28	0.289	524319
22:	21	37	....+.. INDEX RANGE SCAN WF_LOCAL_USER_ROLES_U1 PARTITION: 3 3	4232	3	0.056	524409
23:	5	37	.... TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS	78	0	0.003	524304
24:	23	37	....+ INDEX UNIQUE SCAN FND_SECURITY_GROUPS_U1	41	0	0.002	524305
25:	24	37	....+. TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS	39	0	0.001	524304
26:	25	37	....+.. INDEX UNIQUE SCAN FND_SECURITY_GROUPS_U2	2	0	0.001	524306
27:	4	37	... TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS_TL	39	0	0.001	524307
28:	27	37	.... INDEX UNIQUE SCAN FND_SECURITY_GROUPS_TL_U1	2	0	0.001	524308
29:	2	0	. FILTER	0	0	0.000	0
30:	29	0	.. NESTED LOOPS	0	0	0.000	0
31:	30	0	... NESTED LOOPS	0	0	0.000	0
32:	31	0	.... NESTED LOOPS	0	0	0.000	0
33:	32	0	....+ NESTED LOOPS	0	0	0.000	0
34:	33	0	....+. NESTED LOOPS	0	0	0.000	0
35:	34	0	....+.. NESTED LOOPS	0	0	0.000	0
36:	35	0	....+... TABLE ACCESS BY INDEX ROWID FND_USER	0	0	0.000	524310
37:	36	0	....+.... INDEX UNIQUE SCAN FND_USER_U1	0	0	0.000	524317
38:	35	0	....+... TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY	0	0	0.000	524298
39:	38	0	....+.... INDEX RANGE SCAN FND_RESPONSIBILITY_U2	0	0	0.000	524300
40:	34	0	....+.. PARTITION RANGE ALL PARTITION: 1 14	0	0	0.000	0
41:	40	0	....+... TABLE ACCESS BY LOCAL INDEX ROWID WF_USER_ROLE_ASSIGNMENTS PARTITION: 1 14	0	0	0.000	524424
42:	41	0	....+.... INDEX RANGE SCAN WF_USER_ROLE_ASSIGNMENTS_N2 PARTITION: 1 14	0	0	0.000	524454
43:	42	65000	....+....+ TABLE ACCESS BY INDEX ROWID FND_APPLICATION	65001	0	924.786	524295
44:	18	65000	....+....+ INDEX UNIQUE SCAN FND_APPLICATION_U3	1	0	442.865	524297
45:	33	0	....+. PARTITION RANGE SINGLE PARTITION: 3 3	0	0	0.000	0
46:	45	0	....+.. TABLE ACCESS BY LOCAL INDEX ROWID WF_LOCAL_USER_ROLES PARTITION: 3 3	0	0	0.000	524319
47:	46	0	....+... INDEX RANGE SCAN WF_LOCAL_USER_ROLES_U1 PARTITION: 3 3	0	0	0.000	524409
48:	32	0	....+ TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL	0	0	0.000	524301
49:	48	0	....+. INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U1	0	0	0.000	524302
50:	31	0	.... TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS	0	0	0.000	524304
51:	50	0	....+ INDEX UNIQUE SCAN FND_SECURITY_GROUPS_U1	0	0	0.000	524305
52:	51	37	....+. TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS	39	0	0.001	524304
53:	25	37	....+.. INDEX UNIQUE SCAN FND_SECURITY_GROUPS_U2	2	0	0.001	524306
54:	30	0	... TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS_TL	0	0	0.000	524307
55:	54	0	.... INDEX UNIQUE SCAN FND_SECURITY_GROUPS_TL_U1	0	0	0.000	524308

Explain Plan

ID	PID	Actual Rows²	Estim Card	Cost	Explain Plan Operation	Search Cols¹	Indexed Cols	Predicates
0:			2	91	SELECT STATEMENT
1:	0	37	2	91	SORT ORDER BY
2:	1	37			. CONCATENATION
3:	2	37			.. FILTER			[+]
4:	3	37	1	47	... NESTED LOOPS
5:	4	37	1	46	.... NESTED LOOPS
6:	5	37	1	45	....+ NESTED LOOPS
7:	6	1399	1	42	....+. NESTED LOOPS
8:	7	1250	1	13	....+.. NESTED LOOPS
9:	8	1250	1	12	....+... NESTED LOOPS
10:	9	1	1	2	....+.... TABLE ACCESS BY INDEX ROWID FND_USER
11:	10	1	1	1	....+....+ INDEX UNIQUE SCAN FND_USER_U1	1/1	[+]	[+]
12:	9	1250	1	10	....+.... TABLE ACCESS FULL FND_RESPONSIBILITY			[+]
13:	8	1250	1	1	....+... TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL
14:	13	1250	1	0	....+.... INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U1	3/3	[+]	[+]
15:	7	1399	1	29	....+.. PARTITION RANGE ALL PARTITION: 1 14
16:	15	1399	1	29	....+... TABLE ACCESS BY LOCAL INDEX ROWID WF_USER_ROLE_ASSIGNMENTS PARTITION: 1 14			[+]
17:	16	1850	1	28	....+.... INDEX RANGE SCAN WF_USER_ROLE_ASSIGNMENTS_N2 PARTITION: 1 14	1/2	[+]	[+]
18:	17	65000	1	1	....+....+ TABLE ACCESS BY INDEX ROWID FND_APPLICATION
19:	18	65000	1	0	....+....+. INDEX UNIQUE SCAN FND_APPLICATION_U3	1/1	[+]	[+]
20:	6	37	1	3	....+. PARTITION RANGE SINGLE PARTITION: 3 3
21:	20	37	1	3	....+.. TABLE ACCESS BY LOCAL INDEX ROWID WF_LOCAL_USER_ROLES PARTITION: 3 3			[+]
22:	21	37	1	2	....+... INDEX RANGE SCAN WF_LOCAL_USER_ROLES_U1 PARTITION: 3 3	5/7	[+]	[+]
23:	5	37	1	1	....+ TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS			[+]
24:	23	37	1	0	....+. INDEX UNIQUE SCAN FND_SECURITY_GROUPS_U1	1/1	[+]	[+]
25:	24	37	1	1	....+.. TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS
26:	25	37	1	0	....+... INDEX UNIQUE SCAN FND_SECURITY_GROUPS_U2	1/1	[+]	[+]
27:	4	37	1	1	.... TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS_TL
28:	27	37	1	0	....+ INDEX UNIQUE SCAN FND_SECURITY_GROUPS_TL_U1	2/2	[+]	[+]
29:	2	0			.. FILTER			[+]
30:	29	0	1	39	... NESTED LOOPS
31:	30	0	1	38	.... NESTED LOOPS
32:	31	0	1	37	....+ NESTED LOOPS
33:	32	0	1	36	....+. NESTED LOOPS
34:	33	0	1	33	....+.. NESTED LOOPS
35:	34	0	1	4	....+... NESTED LOOPS
36:	35	0	1	2	....+.... TABLE ACCESS BY INDEX ROWID FND_USER
37:	36	0	1	1	....+....+ INDEX UNIQUE SCAN FND_USER_U1	1/1	[+]	[+]
38:	35	0	1	2	....+.... TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY			[+]
39:	38	0	1	1	....+....+ INDEX RANGE SCAN FND_RESPONSIBILITY_U2	1/2	[+]	[+]
40:	34	0	1	29	....+... PARTITION RANGE ALL PARTITION: 1 14
41:	40	0	1	29	....+.... TABLE ACCESS BY LOCAL INDEX ROWID WF_USER_ROLE_ASSIGNMENTS PARTITION: 1 14			[+]
42:	41	0	1	28	....+....+ INDEX RANGE SCAN WF_USER_ROLE_ASSIGNMENTS_N2 PARTITION: 1 14	1/2	[+]	[+]
43:	42	65000	1	1	....+....+. TABLE ACCESS BY INDEX ROWID FND_APPLICATION
44:	43	65000	1	0	....+....+.. INDEX UNIQUE SCAN FND_APPLICATION_U3	1/1	[+]	[+]
45:	33	0	1	3	....+.. PARTITION RANGE SINGLE PARTITION: 3 3
46:	45	0	1	3	....+... TABLE ACCESS BY LOCAL INDEX ROWID WF_LOCAL_USER_ROLES PARTITION: 3 3			[+]
47:	46	0	1	2	....+.... INDEX RANGE SCAN WF_LOCAL_USER_ROLES_U1 PARTITION: 3 3	5/7	[+]	[+]
48:	32	0	1	1	....+. TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL
49:	48	0	1	0	....+.. INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U1	3/3	[+]	[+]
50:	31	0	1	1	....+ TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS			[+]
51:	50	0	1	0	....+. INDEX UNIQUE SCAN FND_SECURITY_GROUPS_U1	1/1	[+]	[+]
52:	51	37	1	1	....+.. TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS
53:	52	37	1	0	....+... INDEX UNIQUE SCAN FND_SECURITY_GROUPS_U2	1/1	[+]	[+]
54:	30	0	1	1	.... TABLE ACCESS BY INDEX ROWID FND_SECURITY_GROUPS_TL
55:	54	0	1	0	....+ INDEX UNIQUE SCAN FND_SECURITY_GROUPS_TL_U1	2/2	[+]	[+]

(1) X/Y: Where X is the number of searched columns from index, which has a total of Y columns.
(2) Actual rows returned by operation (average if there were more than 1 execution).

Tables and Indexes

[-]

#	Owner.Table Name	in Row Source Plan	in Explain Plan	Current Count(*)²	Num Rows¹	Sample Size¹	Last Analyzed¹	Avg Row Len¹	Blocks¹	Empty Blocks¹	Avg Space¹	Global Stats¹	Part	Temp
1:	APPLSYS.FND_APPLICATION	Y	N	263	258	258	04-MAY-08 03:16:37	43	32	0	0	YES	NO	N
2:	APPLSYS.FND_RESPONSIBILITY	Y	N	3400	3398	3398	19-MAR-08 09:49:22	87	43	0	0	YES	NO	N
3:	APPLSYS.FND_RESPONSIBILITY_TL	Y	N	6796	6794	6794	19-MAR-08 09:49:22	104	160	0	0	YES	NO	N
4:	APPLSYS.FND_SECURITY_GROUPS	Y	N	2	2	2	19-MAR-08 09:49:23	39	13	0	0	YES	NO	N
5:	APPLSYS.FND_SECURITY_GROUPS_TL	Y	N	4	4	4	19-MAR-08 09:49:23	70	13	0	0	YES	NO	N
6:	APPLSYS.FND_USER	Y	N	1860	1860	1860	14-MAY-08 09:55:36	289	73	0	0	YES	NO	N
7:	XXFND.FND_APPLICATION	Y	Y	255	255	255	27-APR-08 21:24:01	43	4	0	0	YES	NO	N
8:	XXFND.FND_RESPONSIBILITY	Y	Y	1601	1601	1601	27-APR-08 21:31:46	81	29	0	0	YES	NO	N
9:	XXFND.FND_RESPONSIBILITY_TL	Y	Y	1601	1601	1601	27-APR-08 21:31:47	92	29	0	0	YES	NO	N
10:	XXFND.FND_SECURITY_GROUPS	Y	Y	1	1	1	27-APR-08 21:31:59	35	1	0	0	YES	NO	N
11:	XXFND.FND_SECURITY_GROUPS_TL	Y	Y	1	1	1	27-APR-08 21:31:59	64	1	0	0	YES	NO	N
12:	XXFND.FND_USER	Y	Y	6974	6941	6941	27-APR-08 21:32:58	314	319	135	1044	YES	NO	N

(1) CBO statistics.
(2) COUNT(*) up to threshold value of 1000000 (tool configuartion parameter).
Back to Top

[-]

#	Owner.Table Name	Owner.Index Name	in Row Source Plan	in Explain Plan	Index Type	Uniqueness	Cols Count	Indexed Columns
1:	APPLSYS.FND_APPLICATION	APPLSYS.FND_APPLICATION_U1	N	N	NORMAL	UNIQUE	1	APPLICATION_ID
2:	APPLSYS.FND_APPLICATION	APPLSYS.FND_APPLICATION_U3	Y	N	NORMAL	UNIQUE	1	APPLICATION_SHORT_NAME
3:	APPLSYS.FND_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U1	N	N	NORMAL	UNIQUE	2	APPLICATION_ID RESPONSIBILITY_ID
4:	APPLSYS.FND_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U2	Y	N	NORMAL	UNIQUE	2	RESPONSIBILITY_KEY APPLICATION_ID
5:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U1	Y	N	NORMAL	UNIQUE	3	APPLICATION_ID RESPONSIBILITY_ID LANGUAGE
6:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U2	N	N	NORMAL	UNIQUE	3	APPLICATION_ID RESPONSIBILITY_NAME LANGUAGE
7:	APPLSYS.FND_SECURITY_GROUPS	APPLSYS.FND_SECURITY_GROUPS_U1	Y	N	NORMAL	UNIQUE	1	SECURITY_GROUP_ID
8:	APPLSYS.FND_SECURITY_GROUPS	APPLSYS.FND_SECURITY_GROUPS_U2	Y	N	NORMAL	UNIQUE	1	SECURITY_GROUP_KEY
9:	APPLSYS.FND_SECURITY_GROUPS_TL	APPLSYS.FND_SECURITY_GROUPS_TL_U1	Y	N	NORMAL	UNIQUE	2	SECURITY_GROUP_ID LANGUAGE
10:	APPLSYS.FND_SECURITY_GROUPS_TL	APPLSYS.FND_SECURITY_GROUPS_TL_U2	N	N	NORMAL	UNIQUE	2	SECURITY_GROUP_NAME LANGUAGE
11:	APPLSYS.FND_USER	APPLSYS.FND_USER_F1	N	N	FUNCTION-BASED NORMAL	NONUNIQUE	1	SYS_NC00029$
12:	APPLSYS.FND_USER	APPLSYS.FND_USER_N1	N	N	NORMAL	NONUNIQUE	1	EMPLOYEE_ID
13:	APPLSYS.FND_USER	APPLSYS.FND_USER_N2	N	N	NORMAL	NONUNIQUE	1	CUSTOMER_ID
14:	APPLSYS.FND_USER	APPLSYS.FND_USER_N3	N	N	NORMAL	NONUNIQUE	1	SUPPLIER_ID
15:	APPLSYS.FND_USER	APPLSYS.FND_USER_N4	N	N	NORMAL	NONUNIQUE	1	PERSON_PARTY_ID
16:	APPLSYS.FND_USER	APPLSYS.FND_USER_N5	N	N	NORMAL	NONUNIQUE	1	USER_GUID
17:	APPLSYS.FND_USER	APPLSYS.FND_USER_U1	Y	N	NORMAL	UNIQUE	1	USER_ID
18:	APPLSYS.FND_USER	APPLSYS.FND_USER_U2	N	N	NORMAL	UNIQUE	1	USER_NAME
19:	XXFND.FND_APPLICATION	XXFND.FND_APPLICATION_U1	N	N	NORMAL	UNIQUE	1	APPLICATION_ID
20:	XXFND.FND_APPLICATION	XXFND.FND_APPLICATION_U3	Y	Y	NORMAL	UNIQUE	1	APPLICATION_SHORT_NAME
21:	XXFND.FND_RESPONSIBILITY	XXFND.FND_RESPONSIBILITY_U1	N	N	NORMAL	UNIQUE	2	APPLICATION_ID RESPONSIBILITY_ID
22:	XXFND.FND_RESPONSIBILITY	XXFND.FND_RESPONSIBILITY_U2	Y	Y	NORMAL	UNIQUE	2	RESPONSIBILITY_KEY APPLICATION_ID
23:	XXFND.FND_RESPONSIBILITY_TL	XXFND.FND_RESPONSIBILITY_TL_U1	Y	Y	NORMAL	UNIQUE	3	APPLICATION_ID RESPONSIBILITY_ID LANGUAGE
24:	XXFND.FND_RESPONSIBILITY_TL	XXFND.FND_RESPONSIBILITY_TL_U2	N	N	NORMAL	UNIQUE	3	APPLICATION_ID RESPONSIBILITY_NAME LANGUAGE
25:	XXFND.FND_SECURITY_GROUPS	XXFND.FND_SECURITY_GROUPS_U1	Y	Y	NORMAL	UNIQUE	1	SECURITY_GROUP_ID
26:	XXFND.FND_SECURITY_GROUPS	XXFND.FND_SECURITY_GROUPS_U2	Y	Y	NORMAL	UNIQUE	1	SECURITY_GROUP_KEY
27:	XXFND.FND_SECURITY_GROUPS_TL	XXFND.FND_SECURITY_GROUPS_TL_U1	Y	Y	NORMAL	UNIQUE	2	SECURITY_GROUP_ID LANGUAGE
28:	XXFND.FND_SECURITY_GROUPS_TL	XXFND.FND_SECURITY_GROUPS_TL_U2	N	N	NORMAL	UNIQUE	2	SECURITY_GROUP_NAME LANGUAGE
29:	XXFND.FND_USER	XXFND.FND_USER_F1	N	N	FUNCTION-BASED NORMAL	NONUNIQUE	1	SYS_NC00028$
30:	XXFND.FND_USER	XXFND.FND_USER_N1	N	N	NORMAL	NONUNIQUE	1	EMPLOYEE_ID
31:	XXFND.FND_USER	XXFND.FND_USER_N2	N	N	NORMAL	NONUNIQUE	1	CUSTOMER_ID
32:	XXFND.FND_USER	XXFND.FND_USER_N3	N	N	NORMAL	NONUNIQUE	1	SUPPLIER_ID
33:	XXFND.FND_USER	XXFND.FND_USER_N4	N	N	NORMAL	NONUNIQUE	1	PERSON_PARTY_ID
34:	XXFND.FND_USER	XXFND.FND_USER_N5	N	N	NORMAL	NONUNIQUE	1	USER_GUID
35:	XXFND.FND_USER	XXFND.FND_USER_U1	Y	Y	NORMAL	UNIQUE	1	USER_ID
36:	XXFND.FND_USER	XXFND.FND_USER_U2	N	N	NORMAL	UNIQUE	1	USER_NAME

#	Owner.Table Name	Owner.Index Name	Num Rows¹	Sample Size¹	Last Analyzed¹	Distinct Keys¹	Blevel¹	Leaf Blocks¹	Avg Leaf Blocks per Key¹	Avg Data Blocks per Key¹	Clustering Factor¹	Global Stats¹	Part	Temp
1:	APPLSYS.FND_APPLICATION	APPLSYS.FND_APPLICATION_U1	258	258	04-MAY-08 03:16:37	258	0	1	1	1	83	YES	NO	N
2:	APPLSYS.FND_APPLICATION	APPLSYS.FND_APPLICATION_U3	258	258	04-MAY-08 03:16:37	258	0	1	1	1	130	YES	NO	N
3:	APPLSYS.FND_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U1	3398	3398	19-MAR-08 09:49:22	3398	1	15	1	1	1603	YES	NO	N
4:	APPLSYS.FND_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U2	3398	3398	19-MAR-08 09:49:22	3398	1	16	1	1	2524	YES	NO	N
5:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U1	6794	6794	19-MAR-08 09:49:22	6794	1	29	1	1	6794	YES	NO	N
6:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U2	6794	6794	19-MAR-08 09:49:22	6794	1	58	1	1	6794	YES	NO	N
7:	APPLSYS.FND_SECURITY_GROUPS	APPLSYS.FND_SECURITY_GROUPS_U1	2	2	19-MAR-08 09:49:23	2	0	1	1	1	1	YES	NO	N
8:	APPLSYS.FND_SECURITY_GROUPS	APPLSYS.FND_SECURITY_GROUPS_U2	2	2	19-MAR-08 09:49:23	2	0	1	1	1	1	YES	NO	N
9:	APPLSYS.FND_SECURITY_GROUPS_TL	APPLSYS.FND_SECURITY_GROUPS_TL_U1	4	4	19-MAR-08 09:49:23	4	0	1	1	1	4	YES	NO	N
10:	APPLSYS.FND_SECURITY_GROUPS_TL	APPLSYS.FND_SECURITY_GROUPS_TL_U2	4	4	19-MAR-08 09:49:23	4	0	1	1	1	4	YES	NO	N
11:	APPLSYS.FND_USER	APPLSYS.FND_USER_F1	705	705	14-MAY-08 09:55:37	695	1	4	1	1	618	YES	NO	N
12:	APPLSYS.FND_USER	APPLSYS.FND_USER_N1	942	942	14-MAY-08 09:55:37	932	1	2	1	1	558	YES	NO	N
13:	APPLSYS.FND_USER	APPLSYS.FND_USER_N2	560	560	14-MAY-08 09:55:37	545	1	3	1	1	336	YES	NO	N
14:	APPLSYS.FND_USER	APPLSYS.FND_USER_N3	5	5	14-MAY-08 09:55:37	5	0	1	1	1	5	YES	NO	N
15:	APPLSYS.FND_USER	APPLSYS.FND_USER_N4	1454	1454	14-MAY-08 09:55:37	1428	1	5	1	1	965	YES	NO	N
16:	APPLSYS.FND_USER	APPLSYS.FND_USER_N5	0	0	14-MAY-08 09:55:36	0	0	0	0	0	0	YES	NO	N
17:	APPLSYS.FND_USER	APPLSYS.FND_USER_U1	1860	1860	14-MAY-08 09:55:37	1860	1	4	1	1	713	YES	NO	N
18:	APPLSYS.FND_USER	APPLSYS.FND_USER_U2	1860	1860	14-MAY-08 09:55:37	1860	1	9	1	1	1659	YES	NO	N
19:	XXFND.FND_APPLICATION	XXFND.FND_APPLICATION_U1	255	255	27-APR-08 21:24:01	255	0	1	1	1	83	YES	NO	N
20:	XXFND.FND_APPLICATION	XXFND.FND_APPLICATION_U3	255	255	27-APR-08 21:24:01	255	0	1	1	1	127	YES	NO	N
21:	XXFND.FND_RESPONSIBILITY	XXFND.FND_RESPONSIBILITY_U1	1601	1601	27-APR-08 21:31:47	1601	1	7	1	1	558	YES	NO	N
22:	XXFND.FND_RESPONSIBILITY	XXFND.FND_RESPONSIBILITY_U2	1601	1601	27-APR-08 21:31:47	1601	1	10	1	1	895	YES	NO	N
23:	XXFND.FND_RESPONSIBILITY_TL	XXFND.FND_RESPONSIBILITY_TL_U1	1601	1601	27-APR-08 21:31:47	1601	1	7	1	1	559	YES	NO	N
24:	XXFND.FND_RESPONSIBILITY_TL	XXFND.FND_RESPONSIBILITY_TL_U2	1601	1601	27-APR-08 21:31:48	1601	1	13	1	1	801	YES	NO	N
25:	XXFND.FND_SECURITY_GROUPS	XXFND.FND_SECURITY_GROUPS_U1	1	1	27-APR-08 21:31:59	1	0	1	1	1	1	YES	NO	N
26:	XXFND.FND_SECURITY_GROUPS	XXFND.FND_SECURITY_GROUPS_U2	1	1	27-APR-08 21:31:59	1	0	1	1	1	1	YES	NO	N
27:	XXFND.FND_SECURITY_GROUPS_TL	XXFND.FND_SECURITY_GROUPS_TL_U1	1	1	27-APR-08 21:31:59	1	0	1	1	1	1	YES	NO	N
28:	XXFND.FND_SECURITY_GROUPS_TL	XXFND.FND_SECURITY_GROUPS_TL_U2	1	1	27-APR-08 21:31:59	1	0	1	1	1	1	YES	NO	N
29:	XXFND.FND_USER	XXFND.FND_USER_F1	6527	6527	27-APR-08 21:32:58	6482	1	41	1	1	6477	YES	NO	N
30:	XXFND.FND_USER	XXFND.FND_USER_N1	6505	6505	27-APR-08 21:32:58	6502	1	24	1	1	4837	YES	NO	N
31:	XXFND.FND_USER	XXFND.FND_USER_N2	50	50	27-APR-08 21:32:58	50	0	1	1	1	40	YES	NO	N
32:	XXFND.FND_USER	XXFND.FND_USER_N3	0	0	27-APR-08 21:32:58	0	0	0	0	0	0	YES	NO	N
33:	XXFND.FND_USER	XXFND.FND_USER_N4	6554	6554	27-APR-08 21:32:59	6550	1	40	1	1	4875	YES	NO	N
34:	XXFND.FND_USER	XXFND.FND_USER_N5	1168	1168	27-APR-08 21:32:59	1167	1	5	1	1	1059	YES	NO	N
35:	XXFND.FND_USER	XXFND.FND_USER_U1	6941	6941	27-APR-08 21:32:58	6941	1	16	1	1	4492	YES	NO	N
36:	XXFND.FND_USER	XXFND.FND_USER_U2	6941	6941	27-APR-08 21:32:58	6941	1	33	1	1	6890	YES	NO	N

(1) CBO statistics.
Back to Top

[-]

#	Owner.Index Name	Col Pos	Column Name	Asc/ Desc	Num Rows¹	Sample Size¹	Last Analyzed¹	Num Nulls¹	Num Distinct¹	Density¹	Num Buckets¹	Histogram¹
1:	APPLSYS.FND_APPLICATION_U1	1	APPLICATION_ID	ASC	258	258	04-MAY-08 03:16:37	0	258	3.8760e-03	1	NONE
2:	APPLSYS.FND_APPLICATION_U3	1	APPLICATION_SHORT_NAME	ASC	258	258	04-MAY-08 03:16:37	0	258	3.8760e-03	1	NONE
3:	APPLSYS.FND_RESPONSIBILITY_TL_U1	1	APPLICATION_ID	ASC	6794	6794	19-MAR-08 09:49:22	0	177	5.6497e-03	1	NONE
4:	APPLSYS.FND_RESPONSIBILITY_TL_U1	2	RESPONSIBILITY_ID	ASC	6794	6794	19-MAR-08 09:49:22	0	3387	2.9525e-04	1	NONE
5:	APPLSYS.FND_RESPONSIBILITY_TL_U1	3	LANGUAGE	ASC	6794	6794	19-MAR-08 09:49:22	0	2	5.0000e-01	1	NONE
6:	APPLSYS.FND_RESPONSIBILITY_TL_U2	1	APPLICATION_ID	ASC	6794	6794	19-MAR-08 09:49:22	0	177	5.6497e-03	1	NONE
7:	APPLSYS.FND_RESPONSIBILITY_TL_U2	2	RESPONSIBILITY_NAME	ASC	6794	6794	19-MAR-08 09:49:22	0	3380	2.9586e-04	1	NONE
8:	APPLSYS.FND_RESPONSIBILITY_TL_U2	3	LANGUAGE	ASC	6794	6794	19-MAR-08 09:49:22	0	2	5.0000e-01	1	NONE
9:	APPLSYS.FND_RESPONSIBILITY_U1	1	APPLICATION_ID	ASC	3398	3398	19-MAR-08 09:49:22	0	177	5.6497e-03	1	NONE
10:	APPLSYS.FND_RESPONSIBILITY_U1	2	RESPONSIBILITY_ID	ASC	3398	3398	19-MAR-08 09:49:22	0	3387	2.9525e-04	1	NONE
11:	APPLSYS.FND_RESPONSIBILITY_U2	1	RESPONSIBILITY_KEY	ASC	3398	3398	19-MAR-08 09:49:22	0	3382	2.9568e-04	1	NONE
12:	APPLSYS.FND_RESPONSIBILITY_U2	2	APPLICATION_ID	ASC	3398	3398	19-MAR-08 09:49:22	0	177	5.6497e-03	1	NONE
13:	APPLSYS.FND_SECURITY_GROUPS_TL_U1	1	SECURITY_GROUP_ID	ASC	4	4	19-MAR-08 09:49:23	0	2	5.0000e-01	1	NONE
14:	APPLSYS.FND_SECURITY_GROUPS_TL_U1	2	LANGUAGE	ASC	4	4	19-MAR-08 09:49:23	0	2	5.0000e-01	1	NONE
15:	APPLSYS.FND_SECURITY_GROUPS_TL_U2	1	SECURITY_GROUP_NAME	ASC	4	4	19-MAR-08 09:49:23	0	2	5.0000e-01	1	NONE
16:	APPLSYS.FND_SECURITY_GROUPS_TL_U2	2	LANGUAGE	ASC	4	4	19-MAR-08 09:49:23	0	2	5.0000e-01	1	NONE
17:	APPLSYS.FND_SECURITY_GROUPS_U1	1	SECURITY_GROUP_ID	ASC	2	2	19-MAR-08 09:49:23	0	2	5.0000e-01	1	NONE
18:	APPLSYS.FND_SECURITY_GROUPS_U2	1	SECURITY_GROUP_KEY	ASC	2	2	19-MAR-08 09:49:23	0	2	5.0000e-01	1	NONE
19:	APPLSYS.FND_USER_F1	1	SYS_NC00029$	ASC	1860	705	14-MAY-08 09:55:36	1155	695	1.4388e-03	1	NONE
20:	APPLSYS.FND_USER_N1	1	EMPLOYEE_ID	ASC	1860	942	14-MAY-08 09:55:36	918	932	1.0730e-03	1	NONE
21:	APPLSYS.FND_USER_N2	1	CUSTOMER_ID	ASC	1860	560	14-MAY-08 09:55:36	1300	545	1.8349e-03	1	NONE
22:	APPLSYS.FND_USER_N3	1	SUPPLIER_ID	ASC	1860	5	14-MAY-08 09:55:36	1855	5	2.0000e-01	1	NONE
23:	APPLSYS.FND_USER_N4	1	PERSON_PARTY_ID	ASC	1860	1454	14-MAY-08 09:55:36	406	1428	7.0028e-04	1	NONE
24:	APPLSYS.FND_USER_N5	1	USER_GUID	ASC	1860		14-MAY-08 09:55:36	1860	0	0.0000e+00	0	NONE
25:	APPLSYS.FND_USER_U1	1	USER_ID	ASC	1860	1860	14-MAY-08 09:55:36	0	1860	5.3763e-04	1	NONE
26:	APPLSYS.FND_USER_U2	1	USER_NAME	ASC	1860	1860	14-MAY-08 09:55:36	0	1860	5.3763e-04	1	NONE
27:	XXFND.FND_APPLICATION_U1	1	APPLICATION_ID	ASC	255	255	27-APR-08 21:24:01	0	255	3.9216e-03	1	NONE
28:	XXFND.FND_APPLICATION_U3	1	APPLICATION_SHORT_NAME	ASC	255	255	27-APR-08 21:24:01	0	255	3.9216e-03	1	NONE
29:	XXFND.FND_RESPONSIBILITY_TL_U1	1	APPLICATION_ID	ASC	1601	1601	27-APR-08 21:31:47	0	165	6.0606e-03	1	NONE
30:	XXFND.FND_RESPONSIBILITY_TL_U1	2	RESPONSIBILITY_ID	ASC	1601	1601	27-APR-08 21:31:47	0	1588	6.2972e-04	1	NONE
31:	XXFND.FND_RESPONSIBILITY_TL_U1	3	LANGUAGE	ASC	1601	1601	27-APR-08 21:31:47	0	1	1.0000e+00	1	NONE
32:	XXFND.FND_RESPONSIBILITY_TL_U2	1	APPLICATION_ID	ASC	1601	1601	27-APR-08 21:31:47	0	165	6.0606e-03	1	NONE
33:	XXFND.FND_RESPONSIBILITY_TL_U2	2	RESPONSIBILITY_NAME	ASC	1601	1601	27-APR-08 21:31:47	0	1589	6.2933e-04	1	NONE
34:	XXFND.FND_RESPONSIBILITY_TL_U2	3	LANGUAGE	ASC	1601	1601	27-APR-08 21:31:47	0	1	1.0000e+00	1	NONE
35:	XXFND.FND_RESPONSIBILITY_U1	1	APPLICATION_ID	ASC	1601	1601	27-APR-08 21:31:46	0	165	6.0606e-03	1	NONE
36:	XXFND.FND_RESPONSIBILITY_U1	2	RESPONSIBILITY_ID	ASC	1601	1601	27-APR-08 21:31:46	0	1588	6.2972e-04	1	NONE
37:	XXFND.FND_RESPONSIBILITY_U2	1	RESPONSIBILITY_KEY	ASC	1601	1601	27-APR-08 21:31:46	0	1595	6.2696e-04	1	NONE
38:	XXFND.FND_RESPONSIBILITY_U2	2	APPLICATION_ID	ASC	1601	1601	27-APR-08 21:31:46	0	165	6.0606e-03	1	NONE
39:	XXFND.FND_SECURITY_GROUPS_TL_U1	1	SECURITY_GROUP_ID	ASC	1	1	27-APR-08 21:31:59	0	1	1.0000e+00	1	NONE
40:	XXFND.FND_SECURITY_GROUPS_TL_U1	2	LANGUAGE	ASC	1	1	27-APR-08 21:31:59	0	1	1.0000e+00	1	NONE
41:	XXFND.FND_SECURITY_GROUPS_TL_U2	1	SECURITY_GROUP_NAME	ASC	1	1	27-APR-08 21:31:59	0	1	1.0000e+00	1	NONE
42:	XXFND.FND_SECURITY_GROUPS_TL_U2	2	LANGUAGE	ASC	1	1	27-APR-08 21:31:59	0	1	1.0000e+00	1	NONE
43:	XXFND.FND_SECURITY_GROUPS_U1	1	SECURITY_GROUP_ID	ASC	1	1	27-APR-08 21:31:59	0	1	1.0000e+00	1	NONE
44:	XXFND.FND_SECURITY_GROUPS_U2	1	SECURITY_GROUP_KEY	ASC	1	1	27-APR-08 21:31:59	0	1	1.0000e+00	1	NONE
45:	XXFND.FND_USER_F1	1	SYS_NC00028$	ASC	6941	1009	14-MAY-08 19:48:09	401	6484	1.5423e-04	1	NONE
46:	XXFND.FND_USER_N1	1	EMPLOYEE_ID	ASC	6941	6505	27-APR-08 21:32:58	436	6502	1.5380e-04	1	NONE
47:	XXFND.FND_USER_N2	1	CUSTOMER_ID	ASC	6941	50	27-APR-08 21:32:58	6891	50	2.0000e-02	1	NONE
48:	XXFND.FND_USER_N3	1	SUPPLIER_ID	ASC	6941		27-APR-08 21:32:58	6941	0	0.0000e+00	0	NONE
49:	XXFND.FND_USER_N4	1	PERSON_PARTY_ID	ASC	6941	6554	27-APR-08 21:32:58	387	6550	1.5267e-04	1	NONE
50:	XXFND.FND_USER_N5	1	USER_GUID	ASC	6941	1168	27-APR-08 21:32:58	5773	1167	8.5690e-04	1	NONE
51:	XXFND.FND_USER_U1	1	USER_ID	ASC	6941	6941	27-APR-08 21:32:58	0	6941	1.4407e-04	1	NONE
52:	XXFND.FND_USER_U2	1	USER_NAME	ASC	6941	6941	27-APR-08 21:32:58	0	6941	1.4407e-04	1	NONE

(1) CBO statistics.
Back to Top

SQL Progeny - Time and Totals

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.000	0.000	0.000	0.000	0.000	0.000
Execute:	1.082	0.003	0.004	0.000	-0.001	1.079
Fetch:	1.292	1.292	1.328	0.036	-0.071	0.000
Total:	2.374	1.295	1.332	0.036	-0.072	1.079

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	0	0	0	0	0	0	0
Execute:	27	0	22	5	2	0	1
Fetch:	10066	4	10081	11273	6	4	0
Total:	10093	4	10103	11278	8	4	1

Segment I/O Wait Summary

[-]

#	Obj	Type	Segment Name¹	Event Name	Wait Time²	Times Waited	Average Wait Time	Max Wait Time	Blocks	Average Blocks
1	524455	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.WF_LOCAL_ROLES	db file sequential read	0.615	409	0.001503	0.022818	409	1
2	524427	TABLE PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS.FND_RESP	db file sequential read	0.244	29	0.008399	0.021413	29	1
3	524322	TABLE PARTITION	XXFND.WF_LOCAL_USER_ROLES.FND_RESP	db file sequential read	0.215	25	0.008592	0.032687	25	1
4	524301	TABLE	XXFND.FND_RESPONSIBILITY_TL	db file sequential read	0.110	10	0.010961	0.041973	10	1
5	524457	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.FND_RESP	db file sequential read	0.036	3	0.012107	0.018588	3	1
6	524412	INDEX PARTITION	XXFND.WF_LOCAL_USER_ROLES_U1.FND_RESP	db file sequential read	0.032	3	0.010687	0.018504	3	1
7	524459	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.POS	db file sequential read	0.029	1	0.028713	0.028713	1	1
8	524317	INDEX	XXFND.FND_USER_U1	db file sequential read	0.020	1	0.019552	0.019552	1	1
9	524464	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.HZ_PARTY	db file sequential read	0.015	1	0.015101	0.015101	1	1

(1) Content requires the Trace Analyzer to be executed on same system/database where trace was generated.
(2) This list is constrained by threshold configuration parameter with current value of 0.01s.

#	Obj	Type	Segment Name¹	Start Timestamp	End Timestamp	Response Time²	Wait Time³	Blocks
10	524317	INDEX	XXFND.FND_USER_U1	2008-JUN-13 13:43:56.304	2008-JUN-13 13:43:56.323	0.020	0.020	1
11	524301	TABLE	XXFND.FND_RESPONSIBILITY_TL	2008-JUN-13 13:43:56.385	2008-JUN-13 13:59:13.174	916.789	0.110	10
12	524455	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.WF_LOCAL_ROLES	2008-JUN-13 13:43:56.397	2008-JUN-13 13:43:57.985	1.588	0.615	409
13	524457	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.FND_RESP	2008-JUN-13 13:43:57.994	2008-JUN-13 13:43:58.034	0.040	0.036	3
14	524459	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.POS	2008-JUN-13 13:43:58.034	2008-JUN-13 13:43:58.063	0.029	0.029	1
15	524464	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.HZ_PARTY	2008-JUN-13 13:43:58.063	2008-JUN-13 13:43:58.078	0.015	0.015	1
16	524427	TABLE PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS.FND_RESP	2008-JUN-13 13:43:59.906	2008-JUN-13 13:55:19.650	679.744	0.244	29
17	524412	INDEX PARTITION	XXFND.WF_LOCAL_USER_ROLES_U1.FND_RESP	2008-JUN-13 13:43:59.920	2008-JUN-13 13:44:05.393	5.474	0.032	3
18	524322	TABLE PARTITION	XXFND.WF_LOCAL_USER_ROLES.FND_RESP	2008-JUN-13 13:44:53.644	2008-JUN-13 14:00:51.286	957.642	0.215	25

(1) Content requires the Trace Analyzer to be executed on same system/database where trace was generated.
(2) According to timestamps of first and last wait in this segment.
(3) This list is constrained by threshold configuration parameter with current value of 0.01s.
Back to Top

1398610540

Rank:2(0.1%) Self:1.080s Progeny:0.000s Invoker:0 Definer:0 Depth:1

[-]

select text from view$ where rowid=:1

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Idle Wait Time
Parse:	1.079	0.000	0.000	1.079
Execute:	0.001	0.001	0.001	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	1.080	0.001	0.001	1.079

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Times Waited Idle
Parse:	5	0	0	1
Execute:	5	0	0	0
Fetch:	5	10	5	0
Total:	15	10	5	1

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time	Blocks	Average Blocks
SQL*Net message from client:	Idle			1.079	1	1.078743	1.078743
Total:				1.079	1

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	5	TABLE ACCESS BY USER ROWID VIEW$	5	0	0	0.000	62

4216473919

Rank:17(0.0%) Self:0.001s Progeny:0.000s Invoker:0 Definer:0 Depth:1

[-]

select u.name, o.name, a.interface_version#, o.obj#      from association$ a, user$ u,
 obj$ o                     where a.obj# = :1                                          and a.property = :2                                      and 
a.statstype# = o.obj#                                and u.user# = o.owner#

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Elapsed Time Unaccounted-for
Parse:	0.000	0.000	0.000	0.000
Execute:	0.000	0.000	0.001	-0.001
Fetch:	0.000	0.000	0.000	0.000
Total:	0.001	0.001	0.001	0.000

Call	Call Count	BG Consistent Read Mode (query)
Parse:	2	0
Execute:	2	0
Fetch:	2	6
Total:	6	6

ID	PID	Row Source Operation	BG Consistent Read Mode (cr)	Obj
1:	0	NESTED LOOPS	6	0
2:	1	NESTED LOOPS	6	0
3:	2	. TABLE ACCESS FULL ASSOCIATION$	6	380
4:	2	. TABLE ACCESS BY INDEX ROWID OBJ$	0	18
5:	4	.. INDEX UNIQUE SCAN I_OBJ1	0	36
6:	1	TABLE ACCESS CLUSTER USER$	0	22
7:	6	. INDEX UNIQUE SCAN I_USER#	0	11

3136611056

Rank:14(0.0%) Self:0.002s Progeny:0.000s Invoker:0 Definer:0 Depth:1

[-]

select a.default_cpu_cost,
 a.default_io_cost             from association$ a                                      where a.obj# = :1                                          and
 a.property = :2

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time
Parse:	0.001	0.001	0.001
Execute:	0.001	0.001	0.001
Fetch:	0.000	0.000	0.000
Total:	0.002	0.002	0.002

Call	Call Count	BG Consistent Read Mode (query)	Library Cache Misses
Parse:	2	0	1
Execute:	2	0	1
Fetch:	2	6	0
Total:	6	6	2

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	0	TABLE ACCESS FULL ASSOCIATION$	6	0	0	0.000	380

462069957

Rank:15(0.0%) Self:0.002s Progeny:0.000s Invoker:360 Definer:360 Depth:1

[-]

SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV,
 FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID
 = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time
Parse:	0.002	0.002	0.002
Execute:	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000
Total:	0.002	0.002	0.002

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	0	1
Execute:	1	0	0	0
Fetch:	1	6	1	0
Total:	3	6	1	1

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	Obj
1:	0	1	NESTED LOOPS	6	0
2:	1	1	TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS	3	48205
3:	2	1	. INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U2	2	48243
4:	1	1	TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES	3	48272
5:	4	1	. INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1	2	380410

2468783182

Rank:16(0.0%) Self:0.001s Progeny:0.000s Invoker:360 Definer:360 Depth:1

[-]

SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , 
SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND 
START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Elapsed Time Unaccounted-for
Parse:	0.000	0.000	0.000	0.000
Execute:	0.001	0.001	0.001	0.000
Fetch:	0.000	0.000	0.001	-0.001
Total:	0.001	0.001	0.002	-0.001

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned
Parse:	2	0	0
Execute:	4	0	0
Fetch:	4	12	4
Total:	10	12	4

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	4	TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS	12	0	0	0.000	48205
2:	1	4	INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U2	8	0	0	0.000	48243

303338305

Rank:3(0.1%) Self:0.740s Progeny:0.000s Invoker:360 Definer:360 Depth:1

[-]

SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE =
 :B1 AND PROFILE_OPTION_VALUE IS NOT NULL

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Elapsed Time Unaccounted-for
Parse:	0.000	0.000	0.000	0.000
Execute:	0.684	0.684	0.679	0.005
Fetch:	0.056	0.056	0.068	-0.012
Total:	0.740	0.740	0.747	-0.007

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses
Parse:	2	0	0	1
Execute:	2502	0	0	1
Fetch:	2502	6256	1252	0
Total:	5006	6256	1252	2

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	1252	TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES	6256	0	0	0.069	48272
2:	1	1252	INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1	5004	0	0	0.034	380410

3159716790

Rank:8(0.0%) Self:0.021s Progeny:0.000s Invoker:0 Definer:0 Depth:2

[-]

select 
i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,
i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),
i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),
i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),
ist.cachedblk,ist.cachehit,ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols,min(to_number(bitand(defer,1))) 
deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) 
and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for
Parse:	0.000	0.000	0.000	0.000	0.000
Execute:	0.000	0.000	0.000	0.000	0.000
Fetch:	0.021	0.021	0.001	0.019	0.001
Total:	0.021	0.021	0.001	0.019	0.001

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Times Waited Non-Idle
Parse:	1	0	0	0	0
Execute:	1	0	0	0	0
Fetch:	2	2	9	1	2
Total:	4	2	9	1	2

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time	Blocks	Average Blocks
db file sequential read:	User I/O	0.019	2			0.009506	0.010518	2	1
Total:		0.019	2

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	2	NUMBER	4	335686
1:				(No oacdef for this bind)

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	1	SORT ORDER BY	9	2	0.021	0
2:	1	1	HASH JOIN OUTER	9	2	0.021	0
3:	2	1	. NESTED LOOPS OUTER	5	0	0.000	0
4:	3	1	.. TABLE ACCESS CLUSTER IND$	4	0	0.000	19
5:	4	1	... INDEX UNIQUE SCAN I_OBJ#	2	0	0.000	3
6:	3	0	.. TABLE ACCESS BY INDEX ROWID IND_STATS$	1	0	0.000	412514
7:	6	0	... INDEX UNIQUE SCAN I_IND_STATS$_OBJ#	1	0	0.000	412515
8:	2	1	. VIEW	4	2	0.020	0
9:	8	1	.. SORT GROUP BY	4	2	0.020	0
10:	9	1	... TABLE ACCESS CLUSTER CDEF$	4	2	0.020	31
11:	10	1	.... INDEX UNIQUE SCAN I_COBJ#	2	0	0.000	30

2280069326

Rank:19(0.0%) Self:0.000s Progeny:0.000s Invoker:0 Definer:0 Depth:2

[-]

select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.000	0.000	0.000	0.000	0.000	0.000
Execute:	0.000	0.000	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000	0.000
Total:	0.000	0.000	0.000	0.000	0.000	0.000

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned
Parse:	1	0	0
Execute:	1	0	0
Fetch:	3	6	2
Total:	5	6	2

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	2	NUMBER	4	335687

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	2	TABLE ACCESS BY INDEX ROWID ICOL$	6	0	0	0.000	20
2:	1	2	INDEX RANGE SCAN I_ICOL1	4	0	0	0.000	40

2512561537

Rank:20(0.0%) Self:0.000s Progeny:0.000s Invoker:0 Definer:0 Depth:2

[-]

select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),
178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),
default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol#

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.000	0.000	0.000	0.000	0.000	0.000
Execute:	0.000	0.000	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000	0.000
Total:	0.000	0.000	0.000	0.000	0.000	0.000

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned
Parse:	1	0	0
Execute:	1	0	0
Fetch:	3	3	2
Total:	5	3	2

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	2	NUMBER	4	335686

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	Obj
1:	0	2	SORT ORDER BY	3	0
2:	1	2	TABLE ACCESS CLUSTER COL$	3	21
3:	2	1	. INDEX UNIQUE SCAN I_OBJ#	2	3

854877822

Rank:21(0.0%) Self:0.000s Progeny:0.000s Invoker:0 Definer:0 Depth:2

[-]

select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	CPU Time	Elapsed Time Unaccounted-for
Parse:	0.001	-0.001
Execute:	0.000	0.000
Fetch:	0.000	0.000
Total:	0.001	-0.001

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned
Parse:	1	0	0
Execute:	1	0	0
Fetch:	1	4	1
Total:	3	4	1

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	2	NUMBER	4	335687

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	1	TABLE ACCESS BY INDEX ROWID OBJ$	4	0	0	0.000	18
2:	1	1	INDEX UNIQUE SCAN I_OBJ1	3	0	0	0.000	36

2888850659

Rank:18(0.0%) Self:0.000s Progeny:0.000s Invoker:0 Definer:0 Depth:2

[-]

select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),
NVL(scanhint,0) from seg$ where ts#=:1 and file#=:2 and block#=:3

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.000	0.000	0.000	0.000	0.000	0.000
Execute:	0.000	0.000	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000	0.000
Total:	0.000	0.000	0.000	0.000	0.000	0.000

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned
Parse:	1	0	0
Execute:	1	0	0
Fetch:	1	3	1
Total:	3	3	1

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	2	NUMBER	2	9
1:	2	NUMBER	2	36
2:	2	NUMBER	3	5051

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	1	TABLE ACCESS CLUSTER SEG$	3	0	0	0.000	14
2:	1	1	INDEX UNIQUE SCAN I_FILE#_BLOCK#	2	0	0	0.000	9

1471956217

Rank:23(0.0%) Self:0.000s Progeny:0.000s Invoker:0 Definer:0 Depth:2

[-]

select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.000	0.000	0.000	0.000	0.000	0.000
Execute:	0.000	0.000	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000	0.000
Total:	0.000	0.000	0.000	0.000	0.000	0.000

Call	Call Count	BG Consistent Read Mode (query)
Parse:	1	0
Execute:	1	0
Fetch:	1	2
Total:	3	2

Bind Pos	DTY Code	Data Type	Actual Value Length	Value
0:	2	NUMBER	4	335686

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	0	TABLE ACCESS BY INDEX ROWID CDEF$	2	0	0	0.000	31
2:	1	0	INDEX RANGE SCAN I_CDEF3	2	0	0	0.000	52

2107929772

Rank:22(0.0%) Self:0.000s Progeny:0.000s Invoker:0 Definer:0 Depth:2

[-]

select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.000	0.000	0.000	0.000	0.000	0.000
Execute:	0.000	0.000	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000	0.000
Total:	0.000	0.000	0.000	0.000	0.000	0.000

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned
Parse:	1	0	0
Execute:	1	0	0
Fetch:	4	7	3
Total:	6	7	3

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	3	TABLE ACCESS CLUSTER CDEF$	7	0	0	0.000	31
2:	1	1	INDEX UNIQUE SCAN I_COBJ#	2	0	0	0.000	30

3849548163

Rank:11(0.0%) Self:0.008s Progeny:0.000s Invoker:0 Definer:0 Depth:2

[-]

select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for
Parse:	0.000	0.000	0.001	0.000	-0.001
Execute:	0.000	0.000	0.000	0.000	0.000
Fetch:	0.008	0.008	0.000	0.008	0.000
Total:	0.008	0.008	0.001	0.008	0.000

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Times Waited Non-Idle
Parse:	1	0	0	0	0
Execute:	3	0	0	0	0
Fetch:	7	1	15	4	1
Total:	11	1	15	4	1

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time	Blocks	Average Blocks
db file sequential read:	User I/O	0.008	1			0.007810	0.007810	1	1
Total:		0.008	1

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	1	TABLE ACCESS BY INDEX ROWID CCOL$	4	1	0	0.008	32
2:	1	1	INDEX RANGE SCAN I_CCOL1	3	1	0	0.008	54

864012087

Rank:10(0.0%) Self:0.010s Progeny:0.000s Invoker:0 Definer:0 Depth:2

[-]

select /*+ rule */
 bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln 
from hist_head$ where obj#=:1 and intcol#=:2

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for
Parse:	0.000	0.000	0.000	0.000	0.000
Execute:	0.000	0.000	0.000	0.000	0.000
Fetch:	0.009	0.009	0.002	0.009	-0.002
Total:	0.010	0.010	0.002	0.009	-0.001

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Times Waited Non-Idle
Parse:	2	0	0	0	0
Execute:	3	0	0	0	0
Fetch:	3	1	12	3	1
Total:	8	1	12	3	1

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time	Blocks	Average Blocks
db file sequential read:	User I/O	0.009	1			0.008765	0.008765	1	1
Total:		0.009	1

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	4	TABLE ACCESS BY INDEX ROWID HIST_HEAD$	16	2	0	0.018	219
2:	1	4	INDEX RANGE SCAN I_HH_OBJ#_INTCOL#	12	0	0	0.000	221

1440489778

Rank:6(0.0%) Self:0.132s Progeny:0.040s Invoker:360 Definer:360 Depth:1

[-]

SELECT NAME, VERSION FROM FND_CACHE_VERSIONS

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Elapsed Time Unaccounted-for
Parse:	0.004	0.004	0.004	0.000
Execute:	0.089	0.089	0.110	-0.021
Fetch:	0.039	0.039	0.036	0.003
Total:	0.132	0.132	0.150	-0.018

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	0	1
Execute:	1250	0	0	0
Fetch:	1250	1250	10000	0
Total:	2501	1250	10000	1

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	10000	INDEX FULL SCAN FND_CACHE_VERSIONS_PK1	1250	0	0	0.048	335687

3575592451

Rank:4(0.0%) Self:0.377s Progeny:0.000s Invoker:360 Definer:360 Depth:1

[-]

SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE
 = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Elapsed Time Unaccounted-for
Parse:	0.000	0.000	0.000	0.000
Execute:	0.352	0.352	0.392	-0.040
Fetch:	0.025	0.025	0.031	-0.006
Total:	0.377	0.377	0.423	-0.046

Call	Call Count	BG Consistent Read Mode (query)	Library Cache Misses
Parse:	1	0	1
Execute:	1250	0	1
Fetch:	1250	2500	0
Total:	2501	2500	2

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	0	TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES	2500	0	0	0.034	48272
2:	1	0	INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1	2500	0	0	0.021	380410

942515969

Rank:9(0.0%) Self:0.016s Progeny:0.000s Invoker:360 Definer:360 Depth:0

SQL Self - Time, Totals, Waits, Binds and Row Source Plan
Explain Plan
Tables and Indexes
SQL Progeny - Time and Totals

[-]

select * from dual

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.016	0.001	0.001	0.015
Execute:	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.016	0.001	0.001	0.015

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	1	0	0	1	0	1
Execute:	1	0	0	0	0	0
Fetch:	2	3	1	0	1	1
Total:	4	3	1	1	1	2

Event Name	Wait Class	Non-Idle Wait Time	Times Waited Non-Idle	Idle Wait Time	Times Waited Idle	Average Wait Time	Max Wait Time
SQL*Net message from client:	Idle			0.015	2	0.007515	0.014896
SQL*Net message to client:	Network	0.000	1			0.000002	0.000002
Total:		0.000	1	0.015	2

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	OS Write Calls (pw)	Time (secs)	Obj
1:	0	1	TABLE ACCESS FULL DUAL	3	0	0	0.000	222

Explain Plan

ID	PID	Actual Rows²	Estim Card	Cost	Explain Plan Operation	Search Cols¹	Indexed Cols	Predicates
0:			1	2	SELECT STATEMENT
1:	0	1	1	2	TABLE ACCESS FULL DUAL

(1) X/Y: Where X is the number of searched columns from index, which has a total of Y columns.
(2) Actual rows returned by operation (average if there were more than 1 execution).

Tables and Indexes

[-]

#	Owner.Table Name	in Row Source Plan	in Explain Plan	Current Count(*)²	Num Rows¹	Sample Size¹	Last Analyzed¹	Avg Row Len¹	Chain Count¹	Blocks¹	Empty Blocks¹	Avg Space¹	Global Stats¹	Part	Temp
1:	SYS.DUAL	Y	Y		1	1	03-AUG-07 19:38:56	2	0	1	0	0	YES	NO	N

(1) CBO statistics.
(2) COUNT(*) up to threshold value of 1000000 (tool configuartion parameter).
Back to Top

SQL Progeny - Time and Totals

[-]

Call	CPU Time	Elapsed Time Unaccounted-for
Parse:	0.001	-0.001
Execute:	0.000	0.000
Fetch:	0.000	0.000
Total:	0.001	-0.001

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned
Parse:	3	4	1
Execute:	0	0	0
Fetch:	0	0	0
Total:	3	4	1

4067503723

Rank:24(0.0%) Self:0.000s Progeny:0.000s Invoker:360 Definer:360 Depth:0

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

ALTER SESSION SET SQL_TRACE = FALSE

SQL Self - Time, Totals, Waits, Binds and Row Source Plan

[-]

Call	Response Time Accounted-for	Elapsed Time	CPU Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.000	0.000	0.000	0.000	0.000	0.000
Execute:	0.000	0.000	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000	0.000
Total:	0.000	0.000	0.000	0.000	0.000	0.000

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	BG Current Mode (current)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	1	0	0	0	0	0	0	0
Execute:	1	0	0	0	0	0	0	0
Fetch:	0	0	0	0	0	0	0	0
Total:	2	0	0	0	0	0	0	0

Overall Segment I/O Wait Summary

[-]
Aggregate view of I/O wait events per segment, ordered by wait time.

#	Obj	Type	Segment Name¹	Event Name	Wait Time²	Times Waited	Average Wait Time	Max Wait Time	Blocks	Average Blocks
1:	524455	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.WF_LOCAL_ROLES	db file sequential read	0.615	409	0.001503	0.022818	409	1
2:	524427	TABLE PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS.FND_RESP	db file sequential read	0.244	29	0.008399	0.021413	29	1
3:	524322	TABLE PARTITION	XXFND.WF_LOCAL_USER_ROLES.FND_RESP	db file sequential read	0.215	25	0.008592	0.032687	25	1
4:	524301	TABLE	XXFND.FND_RESPONSIBILITY_TL	db file sequential read	0.110	10	0.010961	0.041973	10	1
5:	524457	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.FND_RESP	db file sequential read	0.036	3	0.012107	0.018588	3	1
6:	524412	INDEX PARTITION	XXFND.WF_LOCAL_USER_ROLES_U1.FND_RESP	db file sequential read	0.032	3	0.010687	0.018504	3	1
7:	524459	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.POS	db file sequential read	0.029	1	0.028713	0.028713	1	1
8:	524317	INDEX	XXFND.FND_USER_U1	db file sequential read	0.020	1	0.019552	0.019552	1	1
9:		CLUSTER	SYS.C_COBJ#	db file sequential read	0.019	2	0.009506	0.010518	2	1
10:	524464	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.HZ_PARTY	db file sequential read	0.015	1	0.015101	0.015101	1	1

(1) Content requires the Trace Analyzer to be executed on same system/database where the trace was generated.
(2) This list is constrained by threshold configuration parameter with current value of 0.01s.
Back to Top

Hot I/O Blocks

[-]
List of blocks with largest wait time or times waited.

#	File	Block	Obj	Type	Segment Name¹	Wait Time	Times Waited	Max Wait Time
1:	2	170255	524301	TABLE	XXFND.FND_RESPONSIBILITY_TL	0.042	1	0.041973
2:	5	143329	524322	TABLE PARTITION	XXFND.WF_LOCAL_USER_ROLES.FND_RESP	0.033	1	0.032687
3:	4	158824	524459	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.POS	0.029	1	0.028713
4:	1	169683	524455	INDEX PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS_N2.WF_LOCAL_ROLES	0.023	1	0.022818
5:	5	171032	524427	TABLE PARTITION	XXFND.WF_USER_ROLE_ASSIGNMENTS.FND_RESP	0.021	1	0.021413

(1) Segment names require the Trace Analyzer to be executed on same system/database where the trace was generated.
Back to Top

Gaps in Trace

[-]
List of up to 100 gaps found in trace(s) with corresponding approximate duration in seconds.

#	Gap Timestamp	Gap Time¹
1:	2008-JUN-13 13:44:04.687	0.908
2:	2008-JUN-13 13:44:15.053	0.931
3:	2008-JUN-13 13:44:25.228	0.885
4:	2008-JUN-13 13:44:35.520	0.887
5:	2008-JUN-13 13:44:45.743	0.889
6:	2008-JUN-13 13:44:56.022	0.888
7:	2008-JUN-13 13:45:06.258	0.889
8:	2008-JUN-13 13:45:16.537	0.892
9:	2008-JUN-13 13:45:26.798	0.886
10:	2008-JUN-13 13:45:37.014	0.889
11:	2008-JUN-13 13:45:47.287	0.886
12:	2008-JUN-13 13:45:57.467	0.886
13:	2008-JUN-13 13:46:07.670	0.886
14:	2008-JUN-13 13:46:17.936	0.892
15:	2008-JUN-13 13:46:28.252	0.908
16:	2008-JUN-13 13:46:38.459	0.912
17:	2008-JUN-13 13:46:48.709	0.885
18:	2008-JUN-13 13:46:58.979	0.887
19:	2008-JUN-13 13:47:09.208	0.906
20:	2008-JUN-13 13:47:19.465	0.886
21:	2008-JUN-13 13:47:29.619	0.895
22:	2008-JUN-13 13:47:39.869	0.914
23:	2008-JUN-13 13:47:50.150	0.970
24:	2008-JUN-13 13:48:00.374	0.924
25:	2008-JUN-13 13:48:10.560	0.911
26:	2008-JUN-13 13:48:20.732	0.914
27:	2008-JUN-13 13:48:31.012	0.933
28:	2008-JUN-13 13:48:41.187	0.912
29:	2008-JUN-13 13:48:51.382	0.920
30:	2008-JUN-13 13:49:01.617	0.918
31:	2008-JUN-13 13:49:11.895	0.935
32:	2008-JUN-13 13:49:22.136	0.949
33:	2008-JUN-13 13:49:32.328	0.919
34:	2008-JUN-13 13:49:42.492	0.918
35:	2008-JUN-13 13:49:52.656	0.898
36:	2008-JUN-13 13:50:02.988	0.957
37:	2008-JUN-13 13:50:13.331	0.933
38:	2008-JUN-13 13:50:23.599	0.915
39:	2008-JUN-13 13:50:33.801	0.887
40:	2008-JUN-13 13:50:44.053	0.888
41:	2008-JUN-13 13:50:54.304	0.895
42:	2008-JUN-13 13:51:04.520	0.888
43:	2008-JUN-13 13:51:14.755	0.887
44:	2008-JUN-13 13:51:24.970	0.887
45:	2008-JUN-13 13:51:35.122	0.889
46:	2008-JUN-13 13:51:45.340	0.914
47:	2008-JUN-13 13:51:55.592	0.888
48:	2008-JUN-13 13:52:05.800	0.887
49:	2008-JUN-13 13:52:15.983	0.894
50:	2008-JUN-13 13:52:26.188	0.906
51:	2008-JUN-13 13:52:36.393	0.888
52:	2008-JUN-13 13:52:46.548	0.897
53:	2008-JUN-13 13:52:56.766	0.889
54:	2008-JUN-13 13:53:06.952	0.918
55:	2008-JUN-13 13:53:17.219	0.909
56:	2008-JUN-13 13:53:27.466	0.917
57:	2008-JUN-13 13:53:37.741	0.949
58:	2008-JUN-13 13:53:47.991	0.918
59:	2008-JUN-13 13:53:58.341	0.966
60:	2008-JUN-13 13:54:08.629	0.912
61:	2008-JUN-13 13:54:18.866	0.930
62:	2008-JUN-13 13:54:29.126	0.927
63:	2008-JUN-13 13:54:39.390	0.970
64:	2008-JUN-13 13:54:49.603	0.904
65:	2008-JUN-13 13:54:59.828	0.913
66:	2008-JUN-13 13:55:10.133	0.935
67:	2008-JUN-13 13:55:20.369	0.887
68:	2008-JUN-13 13:55:30.545	0.887
69:	2008-JUN-13 13:55:40.754	0.887
70:	2008-JUN-13 13:55:50.931	0.888
71:	2008-JUN-13 13:56:01.225	0.889
72:	2008-JUN-13 13:56:11.404	0.890
73:	2008-JUN-13 13:56:21.632	0.912
74:	2008-JUN-13 13:56:31.824	0.888
75:	2008-JUN-13 13:56:42.213	0.887
76:	2008-JUN-13 13:56:52.490	0.888
77:	2008-JUN-13 13:57:02.673	0.889
78:	2008-JUN-13 13:57:12.876	0.921
79:	2008-JUN-13 13:57:23.052	0.895
80:	2008-JUN-13 13:57:33.335	0.886
81:	2008-JUN-13 13:57:43.572	0.886
82:	2008-JUN-13 13:57:53.746	0.893
83:	2008-JUN-13 13:58:04.031	0.888
84:	2008-JUN-13 13:58:14.292	0.888
85:	2008-JUN-13 13:58:24.475	0.892
86:	2008-JUN-13 13:58:34.710	0.888
87:	2008-JUN-13 13:58:44.956	0.929
88:	2008-JUN-13 13:58:55.301	0.944
89:	2008-JUN-13 13:59:05.493	0.916
90:	2008-JUN-13 13:59:15.731	0.915
91:	2008-JUN-13 13:59:25.975	0.914
92:	2008-JUN-13 13:59:36.165	0.909
93:	2008-JUN-13 13:59:46.355	0.932
94:	2008-JUN-13 13:59:56.631	0.928
95:	2008-JUN-13 14:00:06.769	0.899
96:	2008-JUN-13 14:00:16.933	0.917
97:	2008-JUN-13 14:00:27.107	0.903
98:	2008-JUN-13 14:00:37.361	0.925
99:	2008-JUN-13 14:00:47.635	0.967
100:	2008-JUN-13 14:00:57.875	0.914

(1) Blank if duration cannot be computed.

List of up to 100 recursive calls related to gaps found in trace.

#	Gap Timestamp	Call Depth	Call Type	CPU	Elapsed	Call Timestamp	SQL Text	Hash Value
1:	2008-JUN-13 13:44:04.687	1	Execute	0.000	0.000	2008-JUN-13 13:44:04.437	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
2:	2008-JUN-13 13:44:04.687	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
3:	2008-JUN-13 13:44:15.053	1	Execute	0.000	0.000	2008-JUN-13 13:44:14.560	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
4:	2008-JUN-13 13:44:15.053	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
5:	2008-JUN-13 13:44:25.228	1	Execute	0.000	0.000	2008-JUN-13 13:44:24.497	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
6:	2008-JUN-13 13:44:25.228	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
7:	2008-JUN-13 13:44:35.520	1	Execute	0.000	0.000	2008-JUN-13 13:44:34.547	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
8:	2008-JUN-13 13:44:35.520	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
9:	2008-JUN-13 13:44:45.743	1	Execute	0.000	0.000	2008-JUN-13 13:44:44.531	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
10:	2008-JUN-13 13:44:45.743	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
11:	2008-JUN-13 13:44:56.022	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
12:	2008-JUN-13 13:45:06.258	1	Execute	0.000	0.000	2008-JUN-13 13:45:04.565	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
13:	2008-JUN-13 13:45:06.258	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
14:	2008-JUN-13 13:45:16.537	1	Execute	0.000	0.000	2008-JUN-13 13:45:14.602	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
15:	2008-JUN-13 13:45:16.537	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
16:	2008-JUN-13 13:45:26.798	1	Execute	0.000	0.000	2008-JUN-13 13:45:24.624	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
17:	2008-JUN-13 13:45:26.798	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
18:	2008-JUN-13 13:45:37.014	1	Execute	0.000	0.000	2008-JUN-13 13:45:34.600	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
19:	2008-JUN-13 13:45:37.014	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
20:	2008-JUN-13 13:45:47.287	1	Execute	0.000	0.000	2008-JUN-13 13:45:44.632	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
21:	2008-JUN-13 13:45:47.287	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
22:	2008-JUN-13 13:45:57.467	1	Execute	0.000	0.000	2008-JUN-13 13:45:54.573	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
23:	2008-JUN-13 13:45:57.467	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
24:	2008-JUN-13 13:46:07.670	1	Execute	0.000	0.000	2008-JUN-13 13:46:04.537	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
25:	2008-JUN-13 13:46:07.670	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
26:	2008-JUN-13 13:46:17.936	1	Execute	0.000	0.000	2008-JUN-13 13:46:14.562	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
27:	2008-JUN-13 13:46:17.936	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
28:	2008-JUN-13 13:46:28.252	1	Execute	0.000	0.000	2008-JUN-13 13:46:24.637	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
29:	2008-JUN-13 13:46:28.252	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
30:	2008-JUN-13 13:46:38.459	1	Execute	0.000	0.000	2008-JUN-13 13:46:34.605	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
31:	2008-JUN-13 13:46:38.459	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
32:	2008-JUN-13 13:46:48.709	1	Execute	0.000	0.000	2008-JUN-13 13:46:44.614	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
33:	2008-JUN-13 13:46:48.709	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
34:	2008-JUN-13 13:46:58.979	1	Execute	0.001	0.000	2008-JUN-13 13:46:54.644	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
35:	2008-JUN-13 13:46:58.979	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
36:	2008-JUN-13 13:47:09.208	1	Execute	0.000	0.000	2008-JUN-13 13:47:04.633	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
37:	2008-JUN-13 13:47:09.208	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
38:	2008-JUN-13 13:47:19.465	1	Execute	0.000	0.000	2008-JUN-13 13:47:14.649	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
39:	2008-JUN-13 13:47:19.465	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
40:	2008-JUN-13 13:47:29.619	1	Execute	0.000	0.000	2008-JUN-13 13:47:24.565	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
41:	2008-JUN-13 13:47:29.619	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
42:	2008-JUN-13 13:47:39.869	1	Execute	0.001	0.000	2008-JUN-13 13:47:34.575	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
43:	2008-JUN-13 13:47:39.869	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
44:	2008-JUN-13 13:47:50.150	1	Execute	0.000	0.000	2008-JUN-13 13:47:44.616	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
45:	2008-JUN-13 13:47:50.150	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
46:	2008-JUN-13 13:48:00.374	1	Execute	0.000	0.000	2008-JUN-13 13:47:54.600	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
47:	2008-JUN-13 13:48:00.374	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
48:	2008-JUN-13 13:48:10.560	1	Execute	0.000	0.000	2008-JUN-13 13:48:04.548	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
49:	2008-JUN-13 13:48:10.560	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
50:	2008-JUN-13 13:48:20.732	1	Execute	0.000	0.000	2008-JUN-13 13:48:14.480	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
51:	2008-JUN-13 13:48:20.732	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
52:	2008-JUN-13 13:48:31.012	1	Execute	0.000	0.000	2008-JUN-13 13:48:24.520	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
53:	2008-JUN-13 13:48:31.012	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
54:	2008-JUN-13 13:48:41.187	1	Execute	0.000	0.000	2008-JUN-13 13:48:34.456	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
55:	2008-JUN-13 13:48:41.187	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
56:	2008-JUN-13 13:48:51.382	1	Execute	0.000	0.000	2008-JUN-13 13:48:44.412	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
57:	2008-JUN-13 13:48:51.382	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
58:	2008-JUN-13 13:49:01.617	1	Execute	0.000	0.000	2008-JUN-13 13:48:54.408	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
59:	2008-JUN-13 13:49:01.617	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
60:	2008-JUN-13 13:49:11.895	1	Execute	0.000	0.000	2008-JUN-13 13:49:04.444	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
61:	2008-JUN-13 13:49:11.895	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
62:	2008-JUN-13 13:49:22.136	1	Execute	0.000	0.000	2008-JUN-13 13:49:14.445	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
63:	2008-JUN-13 13:49:22.136	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
64:	2008-JUN-13 13:49:32.328	1	Execute	0.000	0.000	2008-JUN-13 13:49:24.399	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
65:	2008-JUN-13 13:49:32.328	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
66:	2008-JUN-13 13:49:42.492	1	Execute	0.000	0.000	2008-JUN-13 13:49:34.324	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
67:	2008-JUN-13 13:49:42.492	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
68:	2008-JUN-13 13:49:52.656	1	Execute	0.000	0.000	2008-JUN-13 13:49:44.250	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
69:	2008-JUN-13 13:49:52.656	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
70:	2008-JUN-13 13:50:02.988	1	Execute	0.000	0.000	2008-JUN-13 13:49:54.340	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
71:	2008-JUN-13 13:50:02.988	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
72:	2008-JUN-13 13:50:13.331	1	Execute	0.000	0.000	2008-JUN-13 13:50:04.441	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
73:	2008-JUN-13 13:50:13.331	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
74:	2008-JUN-13 13:50:23.599	1	Execute	0.001	0.000	2008-JUN-13 13:50:14.468	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
75:	2008-JUN-13 13:50:23.599	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
76:	2008-JUN-13 13:50:33.801	1	Execute	0.000	0.000	2008-JUN-13 13:50:24.431	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
77:	2008-JUN-13 13:50:33.801	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
78:	2008-JUN-13 13:50:44.053	1	Execute	0.001	0.000	2008-JUN-13 13:50:34.442	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
79:	2008-JUN-13 13:50:44.053	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
80:	2008-JUN-13 13:50:54.304	1	Execute	0.000	0.000	2008-JUN-13 13:50:44.453	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
81:	2008-JUN-13 13:50:54.304	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
82:	2008-JUN-13 13:51:04.520	1	Execute	0.000	0.000	2008-JUN-13 13:50:54.430	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
83:	2008-JUN-13 13:51:04.520	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
84:	2008-JUN-13 13:51:14.755	1	Execute	0.000	0.000	2008-JUN-13 13:51:04.425	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
85:	2008-JUN-13 13:51:14.755	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
86:	2008-JUN-13 13:51:24.970	1	Execute	0.000	0.000	2008-JUN-13 13:51:14.401	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
87:	2008-JUN-13 13:51:24.970	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
88:	2008-JUN-13 13:51:35.122	1	Execute	0.000	0.000	2008-JUN-13 13:51:24.314	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
89:	2008-JUN-13 13:51:35.122	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
90:	2008-JUN-13 13:51:45.340	1	Execute	0.000	0.000	2008-JUN-13 13:51:34.293	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
91:	2008-JUN-13 13:51:45.340	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
92:	2008-JUN-13 13:51:55.592	1	Execute	0.001	0.000	2008-JUN-13 13:51:44.304	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
93:	2008-JUN-13 13:51:55.592	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
94:	2008-JUN-13 13:52:05.800	1	Execute	0.000	0.000	2008-JUN-13 13:51:54.273	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
95:	2008-JUN-13 13:52:05.800	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
96:	2008-JUN-13 13:52:15.983	1	Execute	0.000	0.000	2008-JUN-13 13:52:04.218	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
97:	2008-JUN-13 13:52:15.983	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
98:	2008-JUN-13 13:52:26.188	1	Execute	0.000	0.000	2008-JUN-13 13:52:14.184	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
99:	2008-JUN-13 13:52:26.188	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717
100:	2008-JUN-13 13:52:36.393	0	Fetch	1138.235	1136.842	2008-JUN-13 14:02:53.145	SELECT /* slow */ R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.	1504410717

ORA errors in Trace

[-]
There are no Oracle errors in trace.

Transactions Summary

[-]
List of sessions recognized in trace(s), including transaction counts per type.

#	SID	Serial#	Session Timestamp	Type Read-only Committed	Type Read-only Rolled-back	Type Update Committed	Type Update Rolled-back
1:	328	6389	2008-JUN-13 13:43:54.046	1	0	0	0

Non-default Initialization Params

[-]
List of non-default parameters in APPERF.

#	Parameter	Value¹
1:	_b_tree_bitmap_plans	FALSE
2:	_fast_full_scan_enabled	FALSE
3:	_index_join_enabled	FALSE
4:	_kks_use_mutex_pin	TRUE
5:	_like_with_bind_as_equality	TRUE
6:	_sort_elimination_cost_ratio	5
7:	_sqlexec_progression_cost	2147483647
8:	_system_trig_enabled	TRUE
9:	_trace_files_public	TRUE
10:	aq_tm_processes	1
11:	background_dump_dest	/u02/oracle2/oracle/product/10.2.0/database/admin/APP10G_apperf/bdump
12:	compatible	10.2.0
13:	control_files	/u02/olc10gdata/cntrl01.dbf
14:	control_files	/u02/olc10gdata/cntrl02.dbf
15:	control_files	/u02/olc10gdata/cntrl03.dbf
16:	core_dump_dest	/u02/oracle2/oracle/product/10.2.0/database/admin/APP10G_apperf/cdump
17:	cursor_sharing	EXACT
18:	db_block_checking	FALSE
19:	db_block_checksum	TRUE
20:	db_block_size	8192
21:	db_file_multiblock_read_count	8
22:	db_files	512
23:	db_name	APP10G
24:	dml_locks	10000
25:	ifile	/u02/oracle2/oracle/product/10.2.0/database/dbs/APP10G_apperf_ifile.ora
26:	job_queue_processes	2
27:	log_checkpoint_interval	100000
28:	log_checkpoint_timeout	1200
29:	log_checkpoints_to_alert	TRUE
30:	max_dump_file_size	20480
31:	nls_comp	binary
32:	nls_date_format	DD-MON-RR
33:	nls_language	american
34:	nls_length_semantics	BYTE
35:	nls_numeric_characters	.,
36:	nls_sort	binary
37:	nls_territory	america
38:	olap_page_pool_size	4194304
39:	open_cursors	800
40:	parallel_max_servers	8
41:	parallel_min_servers	0
42:	pga_aggregate_target	1073741824
43:	plsql_code_type	INTERPRETED
44:	plsql_native_library_dir	/u02/oracle2/oracle/product/10.2.0/database/plsql/nativelib
45:	plsql_native_library_subdir_count	149
46:	plsql_optimize_level	2
47:	processes	200
48:	query_rewrite_enabled	true
49:	remote_login_passwordfile	EXCLUSIVE
50:	session_cached_cursors	600
51:	sessions	400
52:	sga_target	599785472
53:	timed_statistics	TRUE
54:	undo_management	AUTO
55:	undo_tablespace	APPS_UNDOTS1
56:	user_dump_dest	/u02/oracle2/oracle/product/10.2.0/database/admin/APP10G_apperf/udump
57:	utl_file_dir	/u02/oracle2/oracle/product/10.2.0/database/appsutil/outbound/APP10G_apperf
58:	utl_file_dir	/usr/tmp
59:	workarea_size_policy	AUTO

(1) These parameters are not extracted from the trace, but from the system where Trace Analyzer was executed (APPERF).

Trace Header

[-]

app10g_ora_19065.trc (3448653 bytes)

/u02/oracle2/oracle/product/10.2.0/database/admin/APP10G_apperf/udump/app10g_ora_19065.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u02/oracle2/oracle/product/10.2.0/database
System name: Linux
Node name: apperf.us.oracle.com
Release: 2.6.9-55.0.0.0.2.ELhugemem
Version: #1 SMP Wed May 2 15:04:06 PDT 2007
Machine: i686
Instance name: APP10G
Redo thread mounted by this instance: 1
Oracle process number: 52
Unix process pid: 19065, image: oracle@apperf.us.oracle.com (TNS V1-V3)

*** ACTION NAME:() 2008-06-13 13:43:54.046
*** MODULE NAME:(SQL*Plus) 2008-06-13 13:43:54.046
*** SERVICE NAME:(SYS$USERS) 2008-06-13 13:43:54.046

Back to Top

Tool Execution Environment

[-]

Execution ID:	84029
Host Name:	apperf
Platform:	Linux
Product Version:	Oracle Database 10g Enterprise Edition (Prod)
RDBMS Version:	10.2.0.3.0(10.2.X)
RDBMS Release:	10.2
User:	XXFND(360)
Input Directory:	/u02/oracle2/oracle/product/10.2.0/database/csierra/traces
Output Directory:	/u02/oracle2/oracle/product/10.2.0/database/csierra/traces

Tool Configuration Parameters

[+]