Trace Analyzer 11.2.4 Report: trcanlzr_72850.html

ddev_ora_15806_APPS.trc (442581 bytes)
Total Trace Response Time: 462.984 secs.
2008-NOV-24 15:24:17.378 (start of first db call in trace).
2008-NOV-24 15:32:00.362 (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	Time (in secs)	pct of total resp time	Time (in secs)	pct of total resp time
CPU Time:	469.220	101.3%
Non-idle Wait Time:	0.651	0.1%
ET Unaccounted-for Time:	-7.052	-1.5%
Total Elapsed Time¹:			462.819	100.0%
Idle Wait Time:			0.075	0.0%
RT Unaccounted-for Time:			0.090	0.0%
Total Response Time²:					462.984	100.0%

(1) Total Elapsed Time = "CPU Time" + "Non-Idle Wait Time" + "ET Unaccounted-for Time".
(2) Total Response Time = "Total Elapsed Time" + "Idle Wait Time" + "RT Unaccounted-for Time".
Total Accounted-for Time = "CPU Time" + "Non-Idle Wait Time" + "Idle Wait Time" = 462.894 secs.
Total Unccounted-for Time = "ET Unaccounted-for Time" + "RT Unaccounted-for Time" = -6.961 secs.
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:		0.443	0.386	0.380	0.045	-0.039	0.057
Execute:		1.638	1.626	1.520	0.000	0.106	0.011
Fetch:		460.814	460.807	467.320	0.606	-7.119	0.007
Total:	462.984	462.894	462.819	469.220	0.651	-7.052	0.075	0.090

(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)	BG Current Mode (current)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	162	27	556	0	0	56	4	8
Execute:	641	58	1601	6	20	38	16	14
Fetch:	898	62	24970180	0	3541	0	172	8
Total:	1701	147	24972337	6	3561	94	192	30

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.600	141			0.004258	0.038493	141	1
SQL*Net message from client:	Idle			0.075	30	0.002493	0.032023	0
SQL*Net more data from client:	Network	0.045	1			0.044564	0.044564	0
latch free:	Other	0.004	3			0.001460	0.004087	0
SQL*Net more data to client:	Network	0.001	8			0.000110	0.000240	0
latch: cache buffers chains:	Concurrency	0.000	8			0.000053	0.000178	0
SQL*Net message to client:	Network	0.000	31			0.000007	0.000013	0
Total:		0.651	192	0.075	30

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.094	0.083	0.080	0.000	0.003	0.012
Execute:	0.813	0.801	0.660	0.000	0.141	0.011
Fetch:	460.450	460.443	467.170	0.417	-7.144	0.007
Total:	461.357	461.327	467.910	0.417	-7.001	0.030

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:	8	0	0	0	5	3	5
Execute:	23	6	32	19	3	16	14
Fetch:	12	62	24970180	380	0	93	8
Total:	43	68	24970212	399	8	112	27

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.411	62			0.006637	0.038493	62	1
SQL*Net message from client:	Idle			0.030	27	0.001111	0.006800	0
latch free:	Other	0.004	3			0.001460	0.004087	0
SQL*Net more data to client:	Network	0.001	8			0.000110	0.000240	0
latch: cache buffers chains:	Concurrency	0.000	8			0.000053	0.000178	0
SQL*Net message to client:	Network	0.000	31			0.000007	0.000013	0
Total:		0.417	112	0.030	27

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.348	0.303	0.300	0.045	-0.041	0.045
Execute:	0.825	0.825	0.860	0.000	-0.035	0.000
Fetch:	0.364	0.364	0.150	0.189	0.025	0.000
Total:	1.537	1.492	1.310	0.233	-0.051	0.045

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:	154	0	0	0	0	51	1	3
Execute:	618	0	7	6	1	35	0	0
Fetch:	886	79	2118	0	3161	0	79	0
Total:	1658	79	2125	6	3162	86	80	3

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.189	79			0.002392	0.013529	79	1
SQL*Net message from client:	Idle			0.045	3	0.014932	0.032023	0
SQL*Net more data from client:	Network	0.045	1			0.044564	0.044564	0
Total:		0.233	80	0.045	3

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.6%	460.895	460.888	467.620	0.417	0.006	0.003	1	70	0	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945

(1) Percent of "Trace Response Time Accounted-for", which is 462.894 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	Start Timestamp	End Timestamp	Hash Value
1:	0.185	0.0%	0.185	0.000	70	begin FND_TRACE.START_TRACE; end;	NOV-24 15:24:17.378	NOV-24 15:24:17.562	1991901736
2:	0.569	0.0%	0.109	0.461	70	SELECT /+ USE_NL (A B I) / DISTINCT A.APPLICATION_ID,	NOV-24 15:24:17.605	NOV-24 15:24:18.174	1491496020
3:	0.447	0.0%	0.057	0.392	70	begin fnd_global.bless_next_init('FND_PERMIT_0000'); fn	NOV-24 15:24:18.199	NOV-24 15:24:18.646	3892466830
4:	0.592	0.0%	0.020	0.572	70	begin Fnd_Concurrent.Init_Request; end;	NOV-24 15:24:18.652	NOV-24 15:24:19.243	2865930600
5:	460.910	99.6%	460.895	0.003	70	select distinct substr(fl.meaning, 1, 11) Type, fs.user	NOV-24 15:24:19.350	NOV-24 15:32:00.260	3807717945

(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 462.894 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.185	0.000	1	70	0	begin FND_TRACE.START_TRACE; end;	1991901736
2:	0.0%	0.039	0.010	14	70	0	declare dummy boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :a	1585540352
3:	0.0%	0.003	0.000	14	70	1	. SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
4:	0.0%	0.004	0.000	14	70	1	. SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG	2468783182
5:	0.0%	0.002	0.000	16	70	1	. SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTIO	303338305
6:	0.0%	0.001	0.000	5	70	1	. SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTIO	3575592451
7:	0.0%	0.109	0.461	1	70	0	SELECT /+ USE_NL (A B I) / DISTINCT A.APPLICATION_ID, A.APPLICATION_NAME, B.AP	1491496020
8:	0.0%	0.025	0.000	1	0	1	. select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2	4125641360
9:	0.0%	0.011	0.024	1	0	1	. select node,owner,name from syn$ where obj#=:1	1343089354
10:	0.0%	0.006	0.000	1	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
11:	0.0%	0.017	0.000	2	0	2	... select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=	3150898423
12:	0.0%	0.015	0.000	1	0	1	. select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(prop	2812844157
13:	0.0%	0.000	0.000	1	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
14:	0.0%	0.010	0.001	1	0	1	. select order#,columns,types from access$ where d_obj#=:1	3993603298
15:	0.0%	0.001	0.000	3	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
16:	0.0%	0.055	0.008	1	0	1	. select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pc	3159716790
17:	0.0%	0.002	0.000	6	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
18:	0.0%	0.005	0.000	9	0	2	... select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=	3150898423
19:	0.0%	0.027	0.030	1	0	1	. select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1	2280069326
20:	0.0%	0.002	0.000	7	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
21:	0.0%	0.028	0.000	12	0	2	... select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=	3150898423
22:	0.0%	0.025	0.013	1	0	1	. select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(	2512561537
23:	0.0%	0.002	0.000	7	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
24:	0.0%	0.011	0.000	6	0	2	... select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=	3150898423
25:	0.0%	0.042	0.026	2	0	1	. select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(l	2888850659
26:	0.0%	0.003	0.000	15	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
27:	0.0%	0.023	0.000	12	0	2	... select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=	3150898423
28:	0.0%	0.013	0.000	1	0	1	. select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataob	854877822
29:	0.0%	0.027	0.012	1	0	1	. select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1	1471956217
30:	0.0%	0.001	0.000	3	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
31:	0.0%	0.011	0.000	21	0	2	... select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=	3150898423
32:	0.0%	0.036	0.028	1	0	1	. select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),	2107929772
33:	0.0%	0.002	0.000	8	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
34:	0.0%	0.026	0.000	6	0	2	... select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=	3150898423
35:	0.0%	0.017	0.017	7	0	1	. select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1	3849548163
36:	0.0%	0.001	0.000	5	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
37:	0.0%	0.016	0.000	5	0	2	... select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=	3150898423
38:	0.0%	0.001	0.000	2	0	1	. select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sampl	864012087
39:	0.0%	0.057	0.392	1	70	0	begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:sess	3892466830
40:	0.0%	0.010	0.018	1	70	1	. SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN ( 'NLS_LANGUAGE', 'NLS_DATE_	2591538919
41:	0.0%	0.001	0.000	1	0	2	... select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nv	2512561537
42:	0.0%	0.009	0.001	1	0	2	... select text from view$ where rowid=:1	1398610540
43:	0.0%	0.001	0.000	2	0	3	....+ select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, s	864012087
44:	0.0%	0.004	0.004	1	0	2	... select PARAMETER , VALUE from GV$NLS_PARAMETERS where inst_id = USERENV('Ins	594004695
45:	0.0%	0.004	0.000	1	0	3	....+ select inst_id,parameter, value from x$nls_parameters where parameter != '	2437258759
46:	0.0%	0.006	0.001	1	70	1	. SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ORDER BY PRODUCT_GROUP_ID	2243784289
47:	0.0%	0.001	0.000	1	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
48:	0.0%	0.009	0.001	1	70	1	. SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, :B2 ) EMPLOYEE_ID, NVL(U.CUSTOMER_ID, :	237168714
49:	0.0%	0.001	0.000	2	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
50:	0.0%	0.005	0.000	1	70	1	. SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.APPLICATION_ID	2259373880
51:	0.0%	0.001	0.000	3	70	1	. SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
52:	0.0%	0.012	0.000	14	70	1	. SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG	2468783182
53:	0.0%	0.000	0.000	1	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
54:	0.0%	0.010	0.000	11	70	1	. SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTIO	3575592451
55:	0.0%	0.011	0.000	29	70	1	. SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTIO	303338305
56:	0.0%	0.015	0.000	1	70	1	. select name from hr_operating_units where organization_id = :v_org_id	1865285778
57:	0.0%	0.000	0.000	1	0	2	... select text from view$ where rowid=:1	1398610540
58:	0.0%	0.009	0.000	1	70	1	. SELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILI	2730441719
59:	0.0%	0.000	0.000	1	0	2	... select text from view$ where rowid=:1	1398610540
60:	0.0%	0.004	0.000	1	70	1	. SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1	2358053208
61:	0.0%	0.007	0.001	1	70	1	. SELECT NVL(MULTI_ORG_FLAG, 'N'), NVL(MULTI_CURRENCY_FLAG, 'N') FROM FND_PRODUC	677706861
62:	0.0%	0.001	0.000	1	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
63:	0.0%	0.060	0.197	1	70	1	. SELECT DISTINCT PRODUCT_DEPENDENCY, LEVEL FROM FND_PRODUCT_INIT_DEPENDENCY P1	2367301228
64:	0.0%	0.001	0.000	2	0	2	... select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spar	4125641360
65:	0.0%	0.000	0.000	1	0	2	... select node,owner,name from syn$ where obj#=:1	1343089354
66:	0.0%	0.001	0.000	1	0	2	... select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(pr	2812844157
67:	0.0%	0.000	0.000	1	0	2	... select order#,columns,types from access$ where d_obj#=:1	3993603298
68:	0.0%	0.100	0.057	1	0	2	... select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.c	2584065658
69:	0.0%	0.007	0.000	36	0	3	....+ select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, s	864012087
70:	0.0%	0.050	0.000	55	0	3	....+ select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj	3150898423
71:	0.0%	0.004	0.000	1	0	2	... select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.	3159716790
72:	0.0%	0.001	0.000	1	0	2	... select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1	2280069326
73:	0.0%	0.001	0.000	1	0	2	... select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nv	2512561537
74:	0.0%	0.001	0.000	2	0	2	... select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL	2888850659
75:	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
76:	0.0%	0.011	0.001	1	0	2	... select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ w	1173719687
77:	0.0%	0.001	0.000	1	0	3	....+ select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, s	864012087
78:	0.0%	0.001	0.000	1	0	3	....+ select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj	3150898423
79:	0.0%	0.012	0.000	1	0	2	... select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objaut	4139184264
80:	0.0%	0.001	0.000	1	0	2	... select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1	1471956217
81:	0.0%	0.001	0.000	1	0	2	... select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0	2107929772
82:	0.0%	0.002	0.000	6	0	2	... select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1	3849548163
83:	0.0%	0.001	0.000	2	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
84:	0.0%	0.015	0.000	1	70	1	. SELECT INIT_FUNCTION_NAME FROM FND_PRODUCT_INITIALIZATION WHERE APPLICATION_SH	2228953296
85:	0.0%	0.020	0.572	1	70	0	begin Fnd_Concurrent.Init_Request; end;	2865930600
86:	0.0%	0.040	0.001	1	70	1	. SELECT P.PID, P.SPID, AUDSID, PROCESS, SUBSTR(USERENV('LANGUAGE'), INSTR( USER	3433790165
87:	0.0%	0.001	0.000	2	0	2	... select text from view$ where rowid=:1	1398610540
88:	0.0%	0.019	0.041	1	70	1	. UPDATE FND_CONCURRENT_REQUESTS SET ORACLE_SESSION_ID = :B4 , ORACLE_PROCESS_ID	3537383812
89:	0.0%	0.019	0.013	1	0	2	... select u.name, o.name, a.interface_version#, o.obj# from association$ a, use	4216473919
90:	0.0%	0.001	0.000	2	0	3	....+ select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, s	864012087
91:	0.0%	0.012	0.000	1	0	3	....+ select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj	3150898423
92:	0.0%	0.008	0.001	1	0	2	... select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj	3136611056
93:	0.0%	0.001	0.000	2	0	3	....+ select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, s	864012087
94:	0.0%	0.001	0.000	2	70	1	. COMMIT	255718823
95:	0.0%	0.019	0.001	1	70	1	. SELECT P.OPTIMIZER_MODE, P.CONCURRENT_PROGRAM_NAME, UPPER(P.ENABLE_TRACE), UPP	2014916476
96:	0.0%	0.001	0.000	1	0	2	... select u.name, o.name, a.interface_version#, o.obj# from association$ a, use	4216473919
97:	0.0%	0.000	0.000	1	0	2	... select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj	3136611056
98:	0.0%	0.024	0.003	1	70	1	. SELECT PLSQL_LOG, PLSQL_OUT, PLSQL_DIR FROM FND_CONCURRENT_PROCESSES P, FND_CO	1669648200
99:	0.0%	0.001	0.000	1	0	2	... select u.name, o.name, a.interface_version#, o.obj# from association$ a, use	4216473919
100:	0.0%	0.000	0.000	1	0	2	... select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj	3136611056
101:	0.0%	0.002	0.000	3	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
102:	0.0%	0.002	0.000	1	70	1	. ALTER SESSION SET SQL_TRACE = TRUE	3913151867
103:	0.0%	0.000	0.000	1	70	1	. SELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILI	2730441719
104:	0.0%	0.024	0.001	1	70	1	. SELECT SUBSTR(REPLACE(USER_CONCURRENT_PROGRAM_NAME,'''',' '),1,240), SUBSTR(CO	3104242407
105:	0.0%	0.000	0.000	1	0	2	... select text from view$ where rowid=:1	1398610540
106:	0.0%	0.001	0.000	1	0	2	... select u.name, o.name, a.interface_version#, o.obj# from association$ a, use	4216473919
107:	0.0%	0.000	0.000	1	0	2	... select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj	3136611056
108:	0.0%	0.004	0.000	1	70	1	. SELECT TO_CHAR(SYSDATE,'DD-MON-YY:HH24:MI:SS') FROM SYS.DUAL	528822382
109:	0.0%	0.004	0.000	1	70	1	. SELECT 'TRACE_USER_DETAILS: TIMESTAMP=24-NOV-08:15:24:18: USER_NAME=KARUTOORIR	2739132179
110:	0.0%	0.019	0.002	1	70	1	. SELECT Q.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_REQUESTS R, FND_CONCURREN	3842200867
111:	0.0%	0.001	0.000	1	0	2	... select u.name, o.name, a.interface_version#, o.obj# from association$ a, use	4216473919
112:	0.0%	0.000	0.000	1	0	2	... select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj	3136611056
113:	0.0%	0.001	0.000	1	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
114:	0.0%	0.016	0.001	1	70	1	. SELECT P.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURREN	1655318066
115:	0.0%	0.001	0.000	1	0	2	... select u.name, o.name, a.interface_version#, o.obj# from association$ a, use	4216473919
116:	0.0%	0.000	0.000	1	0	2	... select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj	3136611056
117:	0.0%	0.005	0.000	1	70	1	. SELECT DECODE(:B1 , 'P', 'REPORTS', 'I', 'PLSQL_CP', 'J', 'JAVA_STORED_CP', 'K	375034462
118:	0.0%	0.175	0.071	1	70	1	. SELECT ENABLE_ROUTINE, DISABLE_ROUTINE, DRO.DEBUG_OPTION_NAME, DRO.DEBUG_OPTIO	3101773339
119:	0.0%	0.002	0.000	8	0	2	... select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spar	4125641360
120:	0.0%	0.001	0.000	4	0	2	... select node,owner,name from syn$ where obj#=:1	1343089354
121:	0.0%	0.012	0.000	4	0	2	... select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(pr	2812844157
122:	0.0%	0.001	0.000	4	0	2	... select order#,columns,types from access$ where d_obj#=:1	3993603298
123:	0.0%	0.012	0.000	4	0	2	... select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.	3159716790
124:	0.0%	0.002	0.000	6	0	2	... select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1	2280069326
125:	0.0%	0.004	0.000	4	0	2	... select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nv	2512561537
126:	0.0%	0.003	0.000	10	0	2	... select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL	2888850659
127:	0.0%	0.001	0.000	6	0	2	... select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.data	854877822
128:	0.0%	0.001	0.000	4	0	2	... select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ w	1173719687
129:	0.0%	0.003	0.000	4	0	2	... select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objaut	4139184264
130:	0.0%	0.001	0.000	4	0	2	... select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1	1471956217
131:	0.0%	0.003	0.000	4	0	2	... select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0	2107929772
132:	0.0%	0.006	0.000	31	0	2	... select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1	3849548163
133:	0.0%	0.017	0.000	26	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087
134:	0.0%	0.014	0.073	1	70	1	. DELETE FROM FND_DEBUG_RULE_OPTIONS WHERE DEBUG_RULE_ID IN (SELECT DEBUG_RULE_I	1329547714
135:	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
136:	0.0%	0.043	0.029	1	0	2	... select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o	2190775527
137:	0.0%	0.016	0.000	1	0	3	....+ select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,	3159716790
138:	0.0%	0.001	0.000	2	0	3	....+ select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1	2280069326
139:	0.0%	0.002	0.000	1	0	3	....+ select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,	2512561537
140:	0.0%	0.001	0.000	5	0	3	....+ select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, s	864012087
141:	0.0%	0.010	0.000	14	0	3	....+ select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj	3150898423
142:	0.0%	0.011	0.001	1	70	1	. DELETE FROM FND_DEBUG_RULES WHERE (START_TIME IS NOT NULL AND END_TIME < SYSDA	3145064069
143:	0.0%	0.001	0.000	1	0	2	... select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.data	854877822
144:	0.0%	0.001	0.000	1	0	2	... select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o	2190775527
145:	0.0%	0.007	0.021	1	70	0	begin FND_CONCURRENT.SET_PREFERRED_RBS; end;	4046303431
146:	0.0%	0.020	0.001	1	70	1	. SELECT P.ROLLBACK_SEGMENT FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUE	569513399
147:	0.0%	0.001	0.000	1	0	2	... select u.name, o.name, a.interface_version#, o.obj# from association$ a, use	4216473919
148:	0.0%	0.000	0.000	1	0	2	... select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj	3136611056
149:	0.0%	0.019	0.000	1	70	0	select responsibility_name HdrResp from fnd_responsibility_vl where responsibili	1421832602
150:	0.0%	0.000	0.000	1	0	1	. select text from view$ where rowid=:1	1398610540
151:	99.6%	460.895	0.003	1	70	0	select distinct substr(fl.meaning, 1, 11) Type, fs.user_request_set_name Name, f	3807717945
152:	0.0%	0.002	0.000	8	0	1	. select text from view$ where rowid=:1	1398610540
153:	0.0%	0.001	0.000	2	0	1	. select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$	4216473919
154:	0.0%	0.001	0.000	2	0	1	. select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj#	3136611056
155:	0.0%	0.012	0.000	1	70	0	select application_name from fnd_application_vl where application_short_name = :	2508053271
156:	0.0%	0.000	0.000	1	0	1	. select text from view$ where rowid=:1	1398610540
157:	0.0%	0.015	0.077	1	70	0	begin fnd_conc_stat.collect; end;	1884498448
158:	0.0%	0.001	0.000	2	70	1	. SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG	2468783182
159:	0.0%	0.002	0.000	6	70	1	. SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTIO	303338305
160:	0.0%	0.000	0.000	2	70	1	. SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTIO	3575592451
161:	0.0%	0.027	0.047	1	70	1	. SELECT STAT_COLLECT FROM FND_CONCURRENT_PROGRAMS WHERE CONCURRENT_PROGRAM_ID =	255214545
162:	0.0%	0.014	0.000	2	0	2	... select u.name, o.name, a.interface_version#, o.obj# from association$ a, use	4216473919
163:	0.0%	0.033	0.000	2	0	2	... select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj	3136611056
164:	0.0%	0.001	0.000	1	0	2	... select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sam	864012087

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:	3	0.0%	0.185	0.185	0.050	0.000	0.000	1	70	0	begin FND_TRACE.START_TRACE; end;	1991901736
2:	61	0.0%	0.004	0.004	0.000	0.000	0.000	17	70	1	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS	1440489778
3:	33	0.0%	0.016	0.016	0.020	0.000	0.000	30	70	1	SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG	2468783182
4:	16	0.0%	0.039	0.028	0.020	0.000	0.011	14	70	0	declare dummy boolean;begin fnd_profile.get_specific(:name,	1585540352
5:	38	0.0%	0.015	0.015	0.020	0.000	0.000	51	70	1	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES W	303338305
6:	47	0.0%	0.011	0.011	0.010	0.000	0.000	18	70	1	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES W	3575592451
7:	21	0.0%	0.028	0.028	0.010	0.000	0.000	11	0	1	select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oi	4125641360
8:	43	0.0%	0.013	0.013	0.010	0.000	0.000	6	0	1	select node,owner,name from syn$ where obj#=:1	1343089354
9:	10	0.0%	0.057	0.057	0.030	0.014	0.000	144	0	2	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt,	864012087
10:	2	0.0%	0.210	0.210	0.090	0.127	0.000	144	0	2	select /+ rule / bucket, endpoint, col#, epvalue from hist	3150898423
11:	20	0.0%	0.029	0.029	0.020	0.010	0.000	6	0	1	select owner#,name,namespace,remoteowner,linkname,p_timestam	2812844157
12:	46	0.0%	0.011	0.011	0.000	0.000	0.000	6	0	1	select order#,columns,types from access$ where d_obj#=:1	3993603298
13:	7	0.0%	0.088	0.088	0.060	0.023	0.000	7	0	1	select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.fla	3159716790
14:	19	0.0%	0.031	0.031	0.020	0.000	0.000	10	0	1	select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where	2280069326
15:	18	0.0%	0.032	0.032	0.050	0.000	0.000	8	0	1	select name,intcol#,segcol#,type#,length,nvl(precision#,0),d	2512561537
16:	11	0.0%	0.046	0.046	0.040	0.007	0.000	14	0	1	select type#,blocks,extents,minexts,maxexts,extsize,extpct,u	2888850659
17:	35	0.0%	0.015	0.015	0.000	0.005	0.000	10	0	1	select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,	854877822
18:	22	0.0%	0.028	0.028	0.030	0.000	0.000	6	0	1	select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where	1471956217
19:	14	0.0%	0.040	0.040	0.030	0.000	0.000	6	0	1	select con#,type#,condlength,intcols,robj#,rcon#,match#,refa	2107929772
20:	24	0.0%	0.025	0.025	0.030	0.000	0.000	44	0	1	select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ whe	3849548163
21:	5	0.0%	0.109	0.107	0.120	0.001	0.001	1	70	0	SELECT /+ USE_NL (A B I) / DISTINCT A.APPLICATION_ID, A.AP	1491496020
22:	9	0.0%	0.057	0.054	0.050	0.000	0.003	1	70	0	begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_glo	3892466830
23:	42	0.0%	0.013	0.013	0.010	0.000	0.000	16	0	2	select text from view$ where rowid=:1	1398610540
24:	62	0.0%	0.004	0.004	0.000	0.000	0.000	0	0	3	select inst_id,parameter, value from x$nls_parameters where	2437258759
25:	57	0.0%	0.004	0.004	0.010	0.000	0.000	0	0	2	select PARAMETER , VALUE from GV$NLS_PARAMETERS where inst_i	594004695
26:	49	0.0%	0.010	0.010	0.000	0.000	0.000	1	70	1	SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN ( 'NLS_LAN	2591538919
27:	54	0.0%	0.006	0.006	0.010	0.000	0.000	1	70	1	SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ORDER BY PRODUCT	2243784289
28:	51	0.0%	0.009	0.009	0.010	0.000	0.000	1	70	1	SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, :B2 ) EMPLOYEE_ID, NV	237168714
29:	56	0.0%	0.005	0.005	0.010	0.000	0.000	1	70	1	SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE	2259373880
30:	37	0.0%	0.015	0.015	0.020	0.000	0.000	1	70	1	select name from hr_operating_units where organization_id =	1865285778
31:	50	0.0%	0.010	0.010	0.010	0.000	0.000	2	70	1	SELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WH	2730441719
32:	58	0.0%	0.004	0.004	0.000	0.000	0.000	1	70	1	SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1	2358053208
33:	53	0.0%	0.007	0.007	0.010	0.000	0.000	1	70	1	SELECT NVL(MULTI_ORG_FLAG, 'N'), NVL(MULTI_CURRENCY_FLAG, 'N	677706861
34:	8	0.0%	0.060	0.060	0.060	0.000	0.000	1	70	1	SELECT DISTINCT PRODUCT_DEPENDENCY, LEVEL FROM FND_PRODUCT_I	2367301228
35:	6	0.0%	0.100	0.100	0.110	0.000	0.000	1	0	2	select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t	2584065658
36:	44	0.0%	0.012	0.012	0.000	0.000	0.000	5	0	2	select col#, grantee#, privilege#,max(mod(nvl(option$,0),2))	1173719687
37:	40	0.0%	0.014	0.014	0.010	0.000	0.000	5	0	2	select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0	4139184264
38:	36	0.0%	0.015	0.015	0.010	0.000	0.000	1	70	1	SELECT INIT_FUNCTION_NAME FROM FND_PRODUCT_INITIALIZATION WH	2228953296
39:	28	0.0%	0.020	0.019	0.000	0.000	0.001	1	70	0	begin Fnd_Concurrent.Init_Request; end;	2865930600
40:	15	0.0%	0.040	0.040	0.040	0.000	0.000	1	70	1	SELECT P.PID, P.SPID, AUDSID, PROCESS, SUBSTR(USERENV('LANGU	3433790165
41:	29	0.0%	0.019	0.019	0.040	0.000	0.000	1	70	1	UPDATE FND_CONCURRENT_REQUESTS SET ORACLE_SESSION_ID = :B4 ,	3537383812
42:	17	0.0%	0.038	0.025	0.030	0.045	0.013	11	0	2	select u.name, o.name, a.interface_version#, o.obj# from ass	4216473919
43:	13	0.0%	0.043	0.011	0.000	0.000	0.032	11	0	2	select a.default_cpu_cost, a.default_io_cost from associatio	3136611056
44:	64	0.0%	0.001	0.001	0.000	0.000	0.000	2	70	1	COMMIT	255718823
45:	31	0.0%	0.019	0.019	0.020	0.000	0.000	1	70	1	SELECT P.OPTIMIZER_MODE, P.CONCURRENT_PROGRAM_NAME, UPPER(P.	2014916476
46:	25	0.0%	0.024	0.024	0.030	0.000	0.000	1	70	1	SELECT PLSQL_LOG, PLSQL_OUT, PLSQL_DIR FROM FND_CONCURRENT_P	1669648200
47:	63	0.0%	0.002	0.002	0.000	0.000	0.000	1	70	1	ALTER SESSION SET SQL_TRACE = TRUE	3913151867
48:	26	0.0%	0.024	0.024	0.030	0.000	0.000	1	70	1	SELECT SUBSTR(REPLACE(USER_CONCURRENT_PROGRAM_NAME,'''',' ')	3104242407
49:	60	0.0%	0.004	0.004	0.000	0.000	0.000	1	70	1	SELECT TO_CHAR(SYSDATE,'DD-MON-YY:HH24:MI:SS') FROM SYS.DUAL	528822382
50:	59	0.0%	0.004	0.004	0.010	0.000	0.000	1	70	1	SELECT 'TRACE_USER_DETAILS: TIMESTAMP=24-NOV-08:15:24:18: US	2739132179
51:	30	0.0%	0.019	0.019	0.010	0.000	0.000	1	70	1	SELECT Q.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_REQUEST	3842200867
52:	34	0.0%	0.016	0.016	0.020	0.000	0.000	1	70	1	SELECT P.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_PROGRAM	1655318066
53:	55	0.0%	0.005	0.005	0.010	0.000	0.000	1	70	1	SELECT DECODE(:B1 , 'P', 'REPORTS', 'I', 'PLSQL_CP', 'J', 'J	375034462
54:	4	0.0%	0.175	0.175	0.200	0.000	0.000	1	70	1	SELECT ENABLE_ROUTINE, DISABLE_ROUTINE, DRO.DEBUG_OPTION_NAM	3101773339
55:	12	0.0%	0.044	0.044	0.040	0.001	0.000	2	0	2	select u.name,o.name, t.update$, t.insert$, t.delete$, t.ena	2190775527
56:	41	0.0%	0.014	0.014	0.020	0.000	0.000	1	70	1	DELETE FROM FND_DEBUG_RULE_OPTIONS WHERE DEBUG_RULE_ID IN (S	1329547714
57:	48	0.0%	0.011	0.011	0.020	0.000	0.000	1	70	1	DELETE FROM FND_DEBUG_RULES WHERE (START_TIME IS NOT NULL AN	3145064069
58:	52	0.0%	0.007	0.007	0.010	0.000	0.001	1	70	0	begin FND_CONCURRENT.SET_PREFERRED_RBS; end;	4046303431
59:	27	0.0%	0.020	0.020	0.020	0.000	0.000	1	70	1	SELECT P.ROLLBACK_SEGMENT FROM FND_CONCURRENT_PROGRAMS P, FN	569513399
60:	32	0.0%	0.019	0.019	0.020	0.000	0.000	1	70	0	select responsibility_name HdrResp from fnd_responsibility_v	1421832602
61:	1	99.6%	460.895	460.888	467.620	0.417	0.006	1	70	0	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
62:	45	0.0%	0.012	0.012	0.010	0.000	0.000	1	70	0	select application_name from fnd_application_vl where applic	2508053271
63:	39	0.0%	0.015	0.008	0.010	0.000	0.007	1	70	0	begin fnd_conc_stat.collect; end;	1884498448
64:	23	0.0%	0.027	0.027	0.020	0.000	0.000	1	70	1	SELECT STAT_COLLECT FROM FND_CONCURRENT_PROGRAMS WHERE CONCU	255214545

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

1991901736

Rank:3(0.0%) Self:0.185s Progeny:0.000s Invoker:70 Definer:70 Depth:0

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

[-]

begin FND_TRACE.START_TRACE; 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.000	0.000	0.000	0.000
Execute:	0.185	0.185	0.050	0.135
Fetch:	0.000	0.000	0.000	0.000
Total:	0.185	0.185	0.050	0.135

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

1440489778

Rank:61(0.0%) Self:0.004s Progeny:0.000s Invoker:70 Definer:70 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	Elapsed Time Unaccounted-for
Parse:	0.000	0.000	0.000
Execute:	0.002	0.002	0.002
Fetch:	0.002	0.002	0.002
Total:	0.004	0.004	0.004

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned
Parse:	0	0	0
Execute:	17	0	0
Fetch:	17	17	119
Total:	34	17	119

2468783182

Rank:33(0.0%) Self:0.016s Progeny:0.000s Invoker:70 Definer:70 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.001	0.001	0.000	0.001
Execute:	0.011	0.011	0.010	0.001
Fetch:	0.004	0.004	0.010	-0.006
Total:	0.016	0.016	0.020	-0.004

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	0	1
Execute:	30	0	0	1
Fetch:	30	83	23	0
Total:	61	83	23	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	14	TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS	44	0	0	0.002	74786
2:	1	14	INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U2	30	0	0	0.001	150287

1585540352

Rank:16(0.0%) Self:0.039s Progeny:0.010s Invoker:70 Definer:70 Depth:0

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

[-]

declare dummy boolean;begin fnd_profile.get_specific(:name, :userid, :respid,  :applid, :val, dummy, :org_id,:server_id);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.000	0.000	0.000	0.000	0.000
Execute:	0.039	0.028	0.020	0.008	0.011
Fetch:	0.000	0.000	0.000	0.000	0.000
Total:	0.039	0.028	0.020	0.008	0.011

Call	Call Count	Rows Processed or Returned	Times Waited Non-Idle	Times Waited Idle
Parse:	0	0	0	0
Execute:	14	14	14	13
Fetch:	0	0	0	0
Total:	14	14	14	13

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.011	13	0.000857	0.002485
SQL*Net message to client:	Network	0.000	14			0.000006	0.000010
Total:		0.000	14	0.011	13

SQL Progeny - Time and Totals

[-]

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

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned
Parse:	0	0	0
Execute:	98	95	109
Fetch:	0	0	0
Total:	98	95	109

303338305

Rank:38(0.0%) Self:0.015s Progeny:0.000s Invoker:70 Definer:70 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.001	0.001	0.000	0.001
Execute:	0.010	0.010	0.020	-0.010
Fetch:	0.004	0.004	0.000	0.004
Total:	0.015	0.015	0.020	-0.005

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	0	1
Execute:	51	0	0	1
Fetch:	51	118	16	0
Total:	103	118	16	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	10	TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES	76	0	0	0.003	74790
2:	1	10	INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1	66	0	0	0.003	150318

3575592451

Rank:47(0.0%) Self:0.011s Progeny:0.000s Invoker:70 Definer:70 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.001	0.001	0.000	0.001
Execute:	0.008	0.008	0.010	-0.002
Fetch:	0.001	0.001	0.000	0.001
Total:	0.011	0.011	0.010	0.001

Call	Call Count	BG Consistent Read Mode (query)	Library Cache Misses
Parse:	1	0	1
Execute:	18	0	1
Fetch:	18	36	0
Total:	37	36	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	22	0	0	0.001	74790
2:	1	0	INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1	22	0	0	0.001	150318

4125641360

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

[-]

select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner
is null and linkname is null and subname is 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.004	0.004	0.000	0.004
Execute:	0.023	0.023	0.000	0.023
Fetch:	0.002	0.002	0.010	-0.008
Total:	0.028	0.028	0.010	0.018

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses
Parse:	3	0	0	1
Execute:	11	0	0	1
Fetch:	11	44	11	0
Total:	25	44	11	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	40	TABLE ACCESS BY INDEX ROWID OBJ$	160	0	0	0.005	18
2:	1	40	INDEX RANGE SCAN I_OBJ2	120	0	0	0.004	37

1343089354

Rank:43(0.0%) Self:0.013s Progeny:0.024s Invoker:0 Definer:0 Depth:1

[-]

select node,owner,name from syn$ where obj#=:1

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.003	0.003	0.000	0.003
Execute:	0.009	0.009	0.000	0.009
Fetch:	0.001	0.001	0.010	-0.009
Total:	0.013	0.013	0.010	0.002

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	3	0	0	0	1	0
Execute:	6	0	0	0	1	0
Fetch:	6	2	18	6	0	2
Total:	15	2	18	6	2	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.000	2			0.000141	0.000151	2	1
Total:		0.000	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	3	TABLE ACCESS BY INDEX ROWID SYN$	9	2	0	0.001	62
2:	1	3	INDEX UNIQUE SCAN I_SYN1	6	1	0	0.001	101

864012087

Rank:10(0.0%) Self:0.057s 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.004	0.004	0.020	0.000	-0.016
Execute:	0.020	0.020	0.000	0.000	0.020
Fetch:	0.033	0.033	0.010	0.014	0.009
Total:	0.057	0.057	0.030	0.014	0.013

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

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.014	13			0.001062	0.012057	13	1
Total:		0.014	13

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	2796	TABLE ACCESS BY INDEX ROWID HIST_HEAD$	11506	226	0	0.672	255
2:	1	2796	INDEX RANGE SCAN I_HH_OBJ#_INTCOL#	8652	35	0	0.206	257

3150898423

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

[-]

select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

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.003	0.003	0.000	0.000	0.003
Execute:	0.018	0.018	0.020	0.000	-0.002
Fetch:	0.189	0.189	0.070	0.127	-0.008
Total:	0.210	0.210	0.090	0.127	-0.007

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

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.127	29			0.004384	0.013529	29	1
Total:		0.127	29

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	78246	SORT ORDER BY	13209	898	5.541	0
2:	1	78246	TABLE ACCESS CLUSTER HISTGRM$	13209	898	4.942	253
3:	2	4403	. INDEX UNIQUE SCAN I_OBJ#_INTCOL#	8806	0	0.155	252

2812844157

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

[-]

select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),
subname,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

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.004	0.004	0.010	0.000	-0.006
Execute:	0.011	0.011	0.010	0.000	0.001
Fetch:	0.013	0.013	0.000	0.010	0.003
Total:	0.029	0.029	0.020	0.010	-0.001

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

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.010	5			0.001936	0.009065	5	1
Total:		0.010	5

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	6	SORT ORDER BY	42	5	0.013	0
2:	1	6	NESTED LOOPS OUTER	42	5	0.012	0
3:	2	6	. TABLE ACCESS BY INDEX ROWID DEPENDENCY$	24	4	0.011	92
4:	3	6	.. INDEX RANGE SCAN I_DEPENDENCY1	18	2	0.001	122
5:	2	6	. TABLE ACCESS BY INDEX ROWID OBJ$	18	1	0.001	18
6:	5	6	.. INDEX UNIQUE SCAN I_OBJ1	12	1	0.001	36

3993603298

Rank:46(0.0%) Self:0.011s Progeny:0.001s Invoker:0 Definer:0 Depth:1

[-]

select order#,columns,types from access$ where d_obj#=:1

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

[-]

Call	Response Time Accounted-for	Elapsed Time	Elapsed Time Unaccounted-for
Parse:	0.003	0.003	0.003
Execute:	0.008	0.008	0.008
Fetch:	0.001	0.001	0.001
Total:	0.011	0.011	0.011

Call	Call Count	BG Consistent Read Mode (query)	Library Cache Misses
Parse:	6	0	1
Execute:	6	0	1
Fetch:	6	22	0
Total:	18	22	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 ACCESS$	22	0	0	0.001	93
2:	1	0	INDEX RANGE SCAN I_ACCESS1	22	0	0	0.000	124

3159716790

Rank:7(0.0%) Self:0.088s Progeny:0.008s Invoker:0 Definer:0 Depth:1

[-]

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.006	0.006	0.010	0.000	-0.004
Execute:	0.037	0.037	0.040	0.000	-0.003
Fetch:	0.044	0.044	0.010	0.023	0.011
Total:	0.088	0.088	0.060	0.023	0.005

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	4	0	0	0	1	0
Execute:	7	0	0	0	1	0
Fetch:	17	12	68	10	0	12
Total:	28	12	68	10	2	12

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.023	12			0.001939	0.012389	12	1
Total:		0.023	12

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	5	SORT ORDER BY	38	10	0.038	0
2:	1	5	HASH JOIN OUTER	38	10	0.037	0
3:	2	5	. NESTED LOOPS OUTER	25	4	0.024	0
4:	3	5	.. TABLE ACCESS CLUSTER IND$	20	4	0.024	19
5:	4	4	... INDEX UNIQUE SCAN I_OBJ#	8	0	0.000	3
6:	3	0	.. TABLE ACCESS BY INDEX ROWID IND_STATS$	5	0	0.000	710
7:	6	0	... INDEX UNIQUE SCAN I_IND_STATS$_OBJ#	5	0	0.000	711
8:	2	0	. VIEW	13	6	0.004	0
9:	8	0	.. SORT GROUP BY	13	6	0.004	0
10:	9	0	... TABLE ACCESS BY INDEX ROWID CDEF$	13	6	0.002	31
11:	10	28	.... INDEX RANGE SCAN I_CDEF2	8	2	0.001	51

2280069326

Rank:19(0.0%) Self:0.031s Progeny:0.030s Invoker:0 Definer:0 Depth:1

[-]

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	Elapsed Time Unaccounted-for
Parse:	0.004	0.004	0.000	0.004
Execute:	0.025	0.025	0.020	0.005
Fetch:	0.002	0.002	0.000	0.002
Total:	0.031	0.031	0.020	0.011

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	4	0	0	0	1	0
Execute:	10	0	0	0	1	0
Fetch:	30	1	60	20	0	1
Total:	44	1	60	20	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
db file sequential read:	User I/O	0.000	1			0.000119	0.000119	1	1
Total:		0.000	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	9	TABLE ACCESS BY INDEX ROWID ICOL$	30	1	0	0.001	20
2:	1	9	INDEX RANGE SCAN I_ICOL1	21	1	0	0.001	40

2512561537

Rank:18(0.0%) Self:0.032s Progeny:0.013s Invoker:0 Definer:0 Depth:1

[-]

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	Elapsed Time Unaccounted-for
Parse:	0.005	0.005	0.010	-0.005
Execute:	0.021	0.021	0.030	-0.009
Fetch:	0.006	0.006	0.010	-0.004
Total:	0.032	0.032	0.050	-0.018

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	5	0	0	0	1	0
Execute:	8	0	0	0	1	0
Fetch:	103	1	30	95	0	1
Total:	116	1	30	95	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
db file sequential read:	User I/O	0.000	1			0.000089	0.000089	1	1
Total:		0.000	1

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	53	SORT ORDER BY	18	1	0.002	0
2:	1	53	TABLE ACCESS CLUSTER COL$	18	1	0.001	21
3:	2	5	. INDEX UNIQUE SCAN I_OBJ#	10	1	0.001	3

2888850659

Rank:11(0.0%) Self:0.046s Progeny:0.026s Invoker:0 Definer:0 Depth:1

[-]

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
Parse:	0.004	0.004	0.010	0.000	-0.006
Execute:	0.032	0.032	0.030	0.000	0.002
Fetch:	0.010	0.010	0.000	0.007	0.003
Total:	0.046	0.046	0.040	0.007	-0.001

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

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.007	5			0.001435	0.006704	5	1
Total:		0.007	5

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	14	TABLE ACCESS CLUSTER SEG$	42	5	0	0.010	14
2:	1	14	INDEX UNIQUE SCAN I_FILE#_BLOCK#	28	0	0	0.001	9

854877822

Rank:35(0.0%) Self:0.015s Progeny:0.000s Invoker:0 Definer:0 Depth:1

[-]

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	Response Time Accounted-for	Elapsed Time	Non-Idle Wait Time	Elapsed Time Unaccounted-for
Parse:	0.003	0.003	0.000	0.003
Execute:	0.006	0.006	0.000	0.006
Fetch:	0.007	0.007	0.005	0.002
Total:	0.015	0.015	0.005	0.010

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	5	0	0	0	1	0
Execute:	10	0	0	0	1	0
Fetch:	10	2	30	10	0	2
Total:	25	2	30	10	2	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.005	2			0.002531	0.004980	2	1
Total:		0.005	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	5	TABLE ACCESS BY INDEX ROWID OBJ$	15	2	0	0.006	18
2:	1	5	INDEX UNIQUE SCAN I_OBJ1	10	1	0	0.001	36

1471956217

Rank:22(0.0%) Self:0.028s Progeny:0.012s Invoker:0 Definer:0 Depth:1

[-]

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	Elapsed Time Unaccounted-for
Parse:	0.003	0.003	0.000	0.003
Execute:	0.025	0.025	0.030	-0.005
Fetch:	0.000	0.000	0.000	0.000
Total:	0.028	0.028	0.030	-0.002

Call	Call Count	BG Consistent Read Mode (query)	Library Cache Misses
Parse:	3	0	1
Execute:	6	0	1
Fetch:	6	12	0
Total:	15	12	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 CDEF$	6	0	0	0.000	31
2:	1	0	INDEX RANGE SCAN I_CDEF3	6	0	0	0.000	52

2107929772

Rank:14(0.0%) Self:0.040s Progeny:0.028s Invoker:0 Definer:0 Depth:1

[-]

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	Elapsed Time Unaccounted-for
Parse:	0.003	0.003	0.000	0.003
Execute:	0.034	0.034	0.020	0.014
Fetch:	0.004	0.004	0.010	-0.006
Total:	0.040	0.040	0.030	0.010

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses
Parse:	3	0	0	1
Execute:	6	0	0	1
Fetch:	50	100	44	0
Total:	59	100	44	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	20	TABLE ACCESS BY INDEX ROWID CDEF$	46	0	0	0.000	31
2:	1	20	INDEX RANGE SCAN I_CDEF2	26	0	0	0.001	51

3849548163

Rank:24(0.0%) Self:0.025s Progeny:0.017s Invoker:0 Definer:0 Depth:1

[-]

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	Elapsed Time Unaccounted-for
Parse:	0.003	0.003	0.000	0.003
Execute:	0.017	0.017	0.030	-0.013
Fetch:	0.006	0.006	0.000	0.005
Total:	0.025	0.025	0.030	-0.005

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	3	0	0	0	1	0
Execute:	44	0	0	0	1	0
Fetch:	88	2	176	44	0	2
Total:	135	2	176	44	2	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.000	2			0.000143	0.000162	2	1
Total:		0.000	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	3	TABLE ACCESS BY INDEX ROWID CCOL$	12	2	0	0.001	32
2:	1	3	INDEX RANGE SCAN I_CCOL1	9	2	0	0.001	54

1491496020

Rank:5(0.0%) Self:0.109s Progeny:0.461s Invoker:70 Definer:70 Depth:0

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

[-]

SELECT /*+ USE_NL (A B I)
*/ DISTINCT A.APPLICATION_ID, A.APPLICATION_NAME, B.APPLICATION_SHORT_NAME, B.BASEPATH, I.PRODUCT_VERSION FROM FND_APPLICATION_TL A, FND_APPLICATION
B, FND_PRODUCT_INSTALLATIONS I WHERE A.APPLICATION_ID = I.APPLICATION_ID (+)
AND A.APPLICATION_ID = B.APPLICATION_ID AND A.LANGUAGE = USERENV ('LANG')

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.039	0.038	0.050	0.000	-0.012	0.001
Execute:	0.001	0.001	0.000	0.000	0.001	0.000
Fetch:	0.069	0.068	0.070	0.001	-0.002	0.001
Total:	0.109	0.107	0.120	0.001	-0.013	0.001

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	1	1
Execute:	1	0	0	0	0	0
Fetch:	2	1853	262	0	9	1
Total:	4	1853	262	1	10	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.001	2	0.000726	0.000803
SQL*Net more data to client:	Network	0.001	7			0.000091	0.000213
SQL*Net message to client:	Network	0.000	3			0.000008	0.000013
Total:		0.001	10	0.001	2

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	Time (secs)	Obj
1:	0	262	HASH UNIQUE	1853	0.067	0
2:	1	262	NESTED LOOPS OUTER	1853	0.069	0
3:	2	262	. NESTED LOOPS	281	0.011	0
4:	3	262	.. TABLE ACCESS FULL FND_APPLICATION_TL	17	0.002	74722
5:	3	262	.. TABLE ACCESS BY INDEX ROWID FND_APPLICATION	264	0.007	74718
6:	5	262	... INDEX UNIQUE SCAN FND_APPLICATION_U1	2	0.002	140558
7:	2	218	. TABLE ACCESS FULL FND_PRODUCT_INSTALLATIONS	1572	0.047	70016

Explain Plan

ID	PID	Actual Rows²	Estim Card	Cost	Explain Plan Operation	Search Cols¹	Indexed Cols	Predicates
0:			255	689	SELECT STATEMENT
1:	0	262	255	689	HASH UNIQUE
2:	1	262	255	688	. NESTED LOOPS OUTER
3:	2	262	255	263	.. NESTED LOOPS
4:	3	262	255	7	... TABLE ACCESS FULL FND_APPLICATION_TL			[+]
5:	3	262	1	1	... TABLE ACCESS BY INDEX ROWID FND_APPLICATION
6:	5	262	1	0	.... INDEX UNIQUE SCAN FND_APPLICATION_U1	1/1	[+]	[+]
7:	2	218	1	2	.. TABLE ACCESS FULL FND_PRODUCT_INSTALLATIONS			[+]

(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¹	Global Stats¹	Part	Temp
1:	APPLSYS.FND_APPLICATION	Y	Y	262	262	262	15-OCT-08 01:40:46	43	5	YES	NO	N
2:	APPLSYS.FND_APPLICATION_TL	Y	Y	1532	1532	1532	15-OCT-08 01:40:46	55	18	YES	NO	N
3:	APPLSYS.FND_PRODUCT_INSTALLATIONS	Y	Y	218	218	218	15-OCT-08 01:46:08	72	6	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	Y	Y	NORMAL	UNIQUE	1	APPLICATION_ID
2:	APPLSYS.FND_APPLICATION	APPLSYS.FND_APPLICATION_U3	N	N	NORMAL	UNIQUE	1	APPLICATION_SHORT_NAME
3:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U1	N	N	NORMAL	UNIQUE	2	APPLICATION_ID LANGUAGE
4:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U2	N	N	NORMAL	UNIQUE	2	APPLICATION_NAME LANGUAGE
5:	APPLSYS.FND_PRODUCT_INSTALLATIONS	APPLSYS.FND_PRODUCT_INSTALLATIONS_PK	N	N	NORMAL	UNIQUE	2	APPLICATION_ID ORACLE_ID

#	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	262	262	15-OCT-08 01:40:46	262	0	1	1	1	62	YES	NO	N
2:	APPLSYS.FND_APPLICATION	APPLSYS.FND_APPLICATION_U3	262	262	15-OCT-08 01:40:46	262	0	1	1	1	120	YES	NO	N
3:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U1	1532	1532	15-OCT-08 01:40:46	1532	1	4	1	1	1161	YES	NO	N
4:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U2	1532	1532	15-OCT-08 01:40:46	1532	1	8	1	1	1176	YES	NO	N
5:	APPLSYS.FND_PRODUCT_INSTALLATIONS	APPLSYS.FND_PRODUCT_INSTALLATIONS_PK	218	218	15-OCT-08 01:46:08	218	0	1	1	1	72	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 Distinct¹	Density¹	Num Buckets¹	Histogram¹
1:	APPLSYS.FND_APPLICATION_TL_U1	1	APPLICATION_ID	ASC	1532	1532	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
2:	APPLSYS.FND_APPLICATION_TL_U1	2	LANGUAGE	ASC	1532	1532	15-OCT-08 01:40:46	6	1.6667e-01	1	NONE
3:	APPLSYS.FND_APPLICATION_TL_U2	1	APPLICATION_NAME	ASC	1532	1532	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
4:	APPLSYS.FND_APPLICATION_TL_U2	2	LANGUAGE	ASC	1532	1532	15-OCT-08 01:40:46	6	1.6667e-01	1	NONE
5:	APPLSYS.FND_APPLICATION_U1	1	APPLICATION_ID	ASC	262	262	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
6:	APPLSYS.FND_APPLICATION_U3	1	APPLICATION_SHORT_NAME	ASC	262	262	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
7:	APPLSYS.FND_PRODUCT_INSTALLATIONS_PK	1	APPLICATION_ID	ASC	218	218	15-OCT-08 01:46:08	218	4.5872e-03	1	NONE
8:	APPLSYS.FND_PRODUCT_INSTALLATIONS_PK	2	ORACLE_ID	ASC	218	218	15-OCT-08 01:46:08	207	4.8309e-03	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
Parse:	0.461	0.461	0.310	0.115	0.036
Execute:	0.000	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000
Total:	0.461	0.461	0.310	0.115	0.036

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	350	27	540	1336	28	27
Execute:	0	0	0	0	0	0
Fetch:	0	0	0	0	0	0
Total:	350	27	540	1336	28	27

3892466830

Rank:9(0.0%) Self:0.057s Progeny:0.392s Invoker:70 Definer:70 Depth:0

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

[-]

begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id,
:site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id,
:conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID',
:mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); 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.003	0.000	0.000	0.000	0.003
Execute:	0.054	0.054	0.050	0.004	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000
Total:	0.057	0.054	0.050	0.004	0.003

Call	Call Count	Rows Processed or Returned	Times Waited Non-Idle	Times Waited Idle
Parse:	1	0	0	1
Execute:	1	1	2	1
Fetch:	0	0	0	0
Total:	2	1	2	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.003	2	0.001535	0.002806
SQL*Net message to client:	Network	0.000	2			0.000010	0.000013
Total:		0.000	2	0.003	2

SQL Progeny - Time and Totals

[-]

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.392	0.392	0.370	0.025	-0.003
Fetch:	0.000	0.000	0.000	0.000	0.000
Total:	0.392	0.392	0.370	0.025	-0.003

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	0	0	0	0	0	0
Execute:	469	26	624	1156	33	26
Fetch:	0	0	0	0	0	0
Total:	469	26	624	1156	33	26

1398610540

Rank:42(0.0%) Self:0.013s Progeny:0.001s Invoker:0 Definer:0 Depth:2

[-]

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	Elapsed Time Unaccounted-for
Parse:	0.003	0.003	0.000	0.003
Execute:	0.008	0.008	0.010	-0.002
Fetch:	0.002	0.002	0.000	0.002
Total:	0.013	0.013	0.010	0.003

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	16	0	0	0	1	0
Execute:	16	0	0	0	1	0
Fetch:	16	1	32	16	0	1
Total:	48	1	32	16	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
db file sequential read:	User I/O	0.000	1			0.000094	0.000094	1	1
Total:		0.000	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	16	TABLE ACCESS BY USER ROWID VIEW$	16	1	0	0.001	63

2437258759

Rank:62(0.0%) Self:0.004s Progeny:0.000s Invoker:0 Definer:0 Depth:3

[-]

select inst_id,parameter, value from x$nls_parameters where parameter != 'NLS_SPECIAL_CHARS'

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

[-]

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

Call	Call Count	Library Cache Misses
Parse:	1	1
Execute:	0	0
Fetch:	0	0
Total:	1	1

594004695

Rank:57(0.0%) Self:0.004s Progeny:0.004s Invoker:0 Definer:0 Depth:2

[-]

select  PARAMETER , VALUE from GV$NLS_PARAMETERS where inst_id = USERENV('Instance')

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.010	-0.006
Execute:	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.004	0.004	0.010	-0.006

Call	Call Count	Library Cache Misses
Parse:	1	1
Execute:	0	0
Fetch:	0	0
Total:	1	1

2591538919

Rank:49(0.0%) Self:0.010s Progeny:0.018s Invoker:70 Definer:70 Depth:1

[-]

SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN ( 'NLS_LANGUAGE', 'NLS_DATE_LANGUAGE', 'NLS_SORT', 'NLS_TERRITORY', 'NLS_DATE_FORMAT',
'NLS_NUMERIC_CHARACTERS', 'NLS_CHARACTERSET' )

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

[-]

Call	Response Time Accounted-for	Elapsed Time	Elapsed Time Unaccounted-for
Parse:	0.009	0.009	0.009
Execute:	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000
Total:	0.010	0.010	0.010

Call	Call Count	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	1
Execute:	1	0	0
Fetch:	1	7	0
Total:	3	7	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	7	FIXED TABLE FULL X$NLS_PARAMETERS	0	0	0	0.000	0

2243784289

Rank:54(0.0%) Self:0.006s Progeny:0.001s Invoker:70 Definer:70 Depth:1

[-]

SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ORDER BY PRODUCT_GROUP_ID

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.005	0.005	0.010	-0.005
Execute:	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.006	0.006	0.010	-0.004

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:	2	3	1	0
Total:	4	3	1	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	SORT ORDER BY	3	0	0	0.000	0
2:	1	1	TABLE ACCESS FULL FND_PRODUCT_GROUPS	3	0	0	0.000	70014

237168714

Rank:51(0.0%) Self:0.009s Progeny:0.001s Invoker:70 Definer:70 Depth:1

[-]

SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, :B2 ) EMPLOYEE_ID, NVL(U.CUSTOMER_ID, :B2 ) CUSTOMER_ID, NVL(U.SUPPLIER_ID, :B2 )
SUPPLIER_ID, NVL(U.PERSON_PARTY_ID, :B2 ) PERSON_PARTY_ID FROM FND_USER U WHERE U.USER_ID = :B1

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.002	0.002	0.000	0.002
Execute:	0.008	0.008	0.010	-0.002
Fetch:	0.000	0.000	0.000	0.000
Total:	0.009	0.009	0.010	-0.001

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	0	1
Execute:	1	0	0	1
Fetch:	1	3	1	0
Total:	3	3	1	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 BY INDEX ROWID FND_USER	3	0	0	0.000	74965
2:	1	1	INDEX UNIQUE SCAN FND_USER_U1	2	0	0	0.000	150375

2259373880

Rank:56(0.0%) Self:0.005s Progeny:0.000s Invoker:70 Definer:70 Depth:1

[-]

SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.APPLICATION_ID = :B1

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.003	0.003	0.010	-0.007
Fetch:	0.000	0.000	0.000	0.000
Total:	0.005	0.005	0.010	-0.005

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	0	1
Execute:	1	0	0	1
Fetch:	1	2	1	0
Total:	3	2	1	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 BY INDEX ROWID FND_APPLICATION	2	0	0	0.000	74718
2:	1	1	INDEX UNIQUE SCAN FND_APPLICATION_U1	1	0	0	0.000	140558

1865285778

Rank:37(0.0%) Self:0.015s Progeny:0.000s Invoker:70 Definer:70 Depth:1

[-]

select name
                             from hr_operating_units
                            where organization_id = :v_org_id

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.013	0.013	0.020	-0.007
Fetch:	0.000	0.000	0.000	0.000
Total:	0.015	0.015	0.020	-0.005

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

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	Obj
1:	0	1	MERGE JOIN CARTESIAN	9	0
2:	1	1	NESTED LOOPS	6	0
3:	2	1	. NESTED LOOPS	4	0
4:	3	1	.. TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS_TL	3	69531
5:	4	1	... INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK	2	138295
6:	3	1	.. INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK	1	137803
7:	2	1	. INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2	2	139509
8:	1	1	BUFFER SORT	3	0
9:	8	1	. TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION	3	64913
10:	9	2	.. INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2	2	139509

2730441719

Rank:50(0.0%) Self:0.010s Progeny:0.000s Invoker:70 Definer:70 Depth:1

[-]

SELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILITY_ID = :B2 AND R.APPLICATION_ID = :B1

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.008	0.008	0.010	-0.002
Fetch:	0.000	0.000	0.000	0.000
Total:	0.010	0.010	0.010	0.000

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

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	Obj
1:	0	2	NESTED LOOPS	10	0
2:	1	2	INDEX UNIQUE SCAN FND_RESPONSIBILITY_U1	4	150325
3:	1	2	TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL	6	74969
4:	3	2	. INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U1	4	150427

2358053208

Rank:58(0.0%) Self:0.004s Progeny:0.000s Invoker:70 Definer:70 Depth:1

[-]

SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1

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

[-]

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

Call	Call Count	BG Consistent Read Mode (query)	Library Cache Misses
Parse:	1	0	1
Execute:	1	0	1
Fetch:	1	1	0
Total:	3	1	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_NODES	1	0	0	0.000	75463
2:	1	0	INDEX RANGE SCAN FND_NODES_N1	1	0	0	0.000	150540

677706861

Rank:53(0.0%) Self:0.007s Progeny:0.001s Invoker:70 Definer:70 Depth:1

[-]

SELECT NVL(MULTI_ORG_FLAG, 'N'), NVL(MULTI_CURRENCY_FLAG, 'N') FROM FND_PRODUCT_GROUPS

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.007	0.007	0.010	-0.003
Execute:	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.007	0.007	0.010	-0.003

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	3	1	0
Total:	3	3	1	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 FULL FND_PRODUCT_GROUPS	3	0	0	0.000	70014

2367301228

Rank:8(0.0%) Self:0.060s Progeny:0.197s Invoker:70 Definer:70 Depth:1

[-]

SELECT DISTINCT PRODUCT_DEPENDENCY, LEVEL FROM FND_PRODUCT_INIT_DEPENDENCY P1 WHERE LEVEL = (SELECT MAX(LEVEL)
FROM FND_PRODUCT_INIT_DEPENDENCY P2 WHERE P2.PRODUCT_DEPENDENCY = P1.PRODUCT_DEPENDENCY CONNECT BY PRIOR P2.PRODUCT_DEPENDENCY =
P2.APPLICATION_SHORT_NAME START WITH P2.APPLICATION_SHORT_NAME = UPPER(:B1 ))
CONNECT BY PRIOR PRODUCT_DEPENDENCY = APPLICATION_SHORT_NAME START WITH APPLICATION_SHORT_NAME = UPPER(:B1 ) ORDER BY LEVEL DESC

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.003	0.003	0.000	0.003
Execute:	0.057	0.057	0.060	-0.003
Fetch:	0.000	0.000	0.000	0.000
Total:	0.060	0.060	0.060	0.000

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

ID	PID	Row Source Operation	BG Consistent Read Mode (cr)	Obj
1:	0	SORT UNIQUE	1	0
2:	1	FILTER	1	0
3:	2	. CONNECT BY WITHOUT FILTERING	1	0
4:	3	.. INDEX RANGE SCAN FND_PRODUCT_INIT_DEPENDENCY_U1	1	159392
5:	3	.. INDEX FULL SCAN FND_PRODUCT_INIT_DEPENDENCY_U1	0	159392
6:	2	. SORT AGGREGATE	0	0
7:	6	.. FILTER	0	0
8:	7	... CONNECT BY WITH FILTERING	0	0
9:	8	.... INDEX RANGE SCAN FND_PRODUCT_INIT_DEPENDENCY_U1	0	159392
10:	8	.... NESTED LOOPS	0	0
11:	10	....+ BUFFER SORT	0	0
12:	11	....+. CONNECT BY PUMP	0	0
13:	10	....+ INDEX RANGE SCAN FND_PRODUCT_INIT_DEPENDENCY_U1	0	159392
14:	8	.... INDEX FULL SCAN FND_PRODUCT_INIT_DEPENDENCY_U1	0	159392

2584065658

Rank:6(0.0%) Self:0.100s Progeny:0.057s Invoker:0 Definer:0 Depth:2

[-]

select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.clucols,0),
t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,t.samplesize,t.cols,
t.property,nvl(t.degree,1),nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0),nvl(t.spare1,0),nvl(t.spare2,0),
t.spare4,t.spare6,ts.cachedblk,ts.cachehit,ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

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.005	0.005	0.000	0.005
Execute:	0.094	0.094	0.110	-0.016
Fetch:	0.001	0.001	0.000	0.001
Total:	0.100	0.100	0.110	-0.010

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	1	0	0	0	1	0
Execute:	1	0	0	0	1	0
Fetch:	1	2	5	1	0	2
Total:	3	2	5	1	2	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.000	2			0.000122	0.000135	2	1
Total:		0.000	2

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	1	NESTED LOOPS OUTER	5	2	0.001	0
2:	1	1	TABLE ACCESS CLUSTER TAB$	4	2	0.001	4
3:	2	1	. INDEX UNIQUE SCAN I_OBJ#	2	0	0.000	3
4:	1	0	TABLE ACCESS BY INDEX ROWID TAB_STATS$	1	0	0.000	708
5:	4	0	. INDEX UNIQUE SCAN I_TAB_STATS$_OBJ#	1	0	0.000	709

1173719687

Rank:44(0.0%) Self:0.012s Progeny:0.001s Invoker:0 Definer:0 Depth:2

[-]

select col#, grantee#, privilege#,max(mod(nvl(option$,0),
2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

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

[-]

Call	Response Time Accounted-for	Elapsed Time	Elapsed Time Unaccounted-for
Parse:	0.003	0.003	0.003
Execute:	0.009	0.009	0.009
Fetch:	0.001	0.001	0.001
Total:	0.012	0.012	0.012

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Library Cache Misses	Times Waited Non-Idle
Parse:	2	0	0	1	0
Execute:	5	0	0	1	0
Fetch:	5	1	15	0	1
Total:	12	1	15	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
db file sequential read:	User I/O	0.000	1			0.000116	0.000116	1	1
Total:		0.000	1

ID	PID	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	SORT GROUP BY	6	1	0.001	0
2:	1	TABLE ACCESS BY INDEX ROWID OBJAUTH$	6	1	0.001	57
3:	2	. INDEX RANGE SCAN I_OBJAUTH1	6	1	0.000	103

4139184264

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

[-]

select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),
2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#

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.003	0.003	0.000	0.003
Execute:	0.009	0.009	0.010	-0.001
Fetch:	0.003	0.003	0.000	0.003
Total:	0.014	0.014	0.010	0.004

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	2	0	0	0	1	0
Execute:	5	0	0	0	1	0
Fetch:	60	2	20	55	0	2
Total:	67	2	20	55	2	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.000	2			0.000148	0.000156	2	1
Total:		0.000	2

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	22	SORT GROUP BY	8	2	0.002	0
2:	1	22	TABLE ACCESS BY INDEX ROWID OBJAUTH$	8	2	0.001	57
3:	2	22	. INDEX RANGE SCAN I_OBJAUTH1	6	0	0.000	103

2228953296

Rank:36(0.0%) Self:0.015s Progeny:0.000s Invoker:70 Definer:70 Depth:1

[-]

SELECT INIT_FUNCTION_NAME FROM FND_PRODUCT_INITIALIZATION WHERE APPLICATION_SHORT_NAME = :B1 AND EXISTS (SELECT 1 FROM FND_PRODUCT_INIT_CONDITION C
WHERE C.APPLICATION_SHORT_NAME = :B1 AND C.RE_INIT_CONDITION IN (:B7 , :B6 , :B5 , :B4 , :B3 , :B2 ))

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.002	0.002	0.000	0.002
Execute:	0.013	0.013	0.010	0.003
Fetch:	0.000	0.000	0.000	0.000
Total:	0.015	0.015	0.010	0.005

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

ID	PID	Row Source Operation	BG Consistent Read Mode (cr)	Obj
1:	0	FILTER	1	0
2:	1	INDEX RANGE SCAN FND_PRODUCT_INITIALIZATION_U1	0	159390
3:	1	INDEX RANGE SCAN FND_PRODUCT_INIT_CONDITION_U1	1	159391

2865930600

Rank:28(0.0%) Self:0.020s Progeny:0.572s Invoker:70 Definer:70 Depth:0

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

[-]

begin Fnd_Concurrent.Init_Request; end;

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.001	0.000	0.000	0.001
Execute:	0.019	0.019	0.019	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.020	0.019	0.019	0.001

Call	Call Count	Rows Processed or Returned	Times Waited Idle
Parse:	1	0	1
Execute:	1	1	0
Fetch:	0	0	0
Total:	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	Blocks	Average Blocks
SQL*Net message from client:	Idle			0.001	1	0.000726	0.000726
Total:				0.001	1

SQL Progeny - Time and Totals

[-]

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.572	0.572	0.560	0.049	-0.037
Fetch:	0.000	0.000	0.000	0.000	0.000
Total:	0.572	0.572	0.560	0.049	-0.037

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
Parse:	0	0	0	0	0	0	0
Execute:	652	25	780	6	545	23	25
Fetch:	0	0	0	0	0	0	0
Total:	652	25	780	6	545	23	25

3433790165

Rank:15(0.0%) Self:0.040s Progeny:0.001s Invoker:70 Definer:70 Depth:1

[-]

SELECT P.PID, P.SPID, AUDSID, PROCESS, SUBSTR(USERENV('LANGUAGE'), INSTR( USERENV('LANGUAGE'),
 '.') + 1) FROM V$SESSION S, V$PROCESS P WHERE P.ADDR = S.PADDR AND S.AUDSID = USERENV('SESSIONID')

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.021	0.021	0.020	0.001
Execute:	0.001	0.001	0.010	-0.009
Fetch:	0.018	0.018	0.010	0.008
Total:	0.040	0.040	0.040	0.000

Call	Call Count	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	1
Execute:	1	0	0
Fetch:	1	1	0
Total:	3	1	1

ID	PID	Actual Rows	Row Source Operation	Time (secs)
1:	0	1	MERGE JOIN	0.018
2:	1	1	SORT JOIN	0.017
3:	2	1	. MERGE JOIN	0.016
4:	3	118	.. SORT JOIN	0.009
5:	4	265	... FIXED TABLE FULL X$KSUPR	0.002
6:	3	1	.. SORT JOIN	0.009
7:	6	1	... FIXED TABLE FULL X$KSUSE	0.009
8:	1	1	SORT JOIN	0.001
9:	8	878	. FIXED TABLE FULL X$KSLED	0.001

3537383812

Rank:29(0.0%) Self:0.019s Progeny:0.041s Invoker:70 Definer:70 Depth:1

[-]

UPDATE FND_CONCURRENT_REQUESTS SET ORACLE_SESSION_ID = :B4 , ORACLE_PROCESS_ID = :B3 , OS_PROCESS_ID = :B2 , NLS_CODESET = :B1 WHERE REQUEST_ID =
FND_GLOBAL.CONC_REQUEST_ID

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.002	0.002	0.010	-0.008
Execute:	0.018	0.018	0.030	-0.012
Fetch:	0.000	0.000	0.000	0.000
Total:	0.019	0.019	0.040	-0.021

Call	Call Count	BG Consistent Read Mode (query)	BG Current Mode (current)	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	0	0	1
Execute:	1	2	5	1	1
Fetch:	0	0	0	0	0
Total:	2	2	5	1	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	UPDATE FND_CONCURRENT_REQUESTS	2	0	0	0.002	0
2:	1	1	INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1	2	0	0	0.001	154020

4216473919

Rank:17(0.0%) Self:0.038s Progeny:0.013s Invoker:0 Definer:0 Depth:2

[-]

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	Non-Idle Wait Time	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.018	0.005	0.000	0.045	-0.040	0.013
Execute:	0.018	0.018	0.030	0.000	-0.012	0.000
Fetch:	0.003	0.003	0.000	0.000	0.003	0.000
Total:	0.038	0.025	0.030	0.045	-0.049	0.013

Call	Call Count	BG Consistent Read Mode (query)	Library Cache Misses	Times Waited Non-Idle	Times Waited Idle
Parse:	11	0	1	1	2
Execute:	11	0	1	0	0
Fetch:	11	33	0	0	0
Total:	33	33	2	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 more data from client:	Network	0.045	1			0.044564	0.044564
SQL*Net message from client:	Idle			0.013	2	0.006386	0.009330
Total:		0.045	1	0.013	2

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

3136611056

Rank:13(0.0%) Self:0.043s Progeny:0.001s Invoker:0 Definer:0 Depth:2

[-]

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	Elapsed Time Unaccounted-for	Idle Wait Time
Parse:	0.035	0.003	0.003	0.032
Execute:	0.007	0.007	0.007	0.000
Fetch:	0.001	0.001	0.001	0.000
Total:	0.043	0.011	0.011	0.032

Call	Call Count	BG Consistent Read Mode (query)	Library Cache Misses	Times Waited Idle
Parse:	11	0	1	1
Execute:	11	0	1	0
Fetch:	11	33	0	0
Total:	33	33	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 from client:	Idle			0.032	1	0.032023	0.032023
Total:				0.032	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	0	TABLE ACCESS FULL ASSOCIATION$	33	0	0	0.001	386

255718823

Rank:64(0.0%) Self:0.001s Progeny:0.000s Invoker:70 Definer:70 Depth:1

[-]

COMMIT

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

[-]

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

Call	Call Count	BG Current Mode (current)
Parse:	2	0
Execute:	2	1
Fetch:	0	0
Total:	4	1

2014916476

Rank:31(0.0%) Self:0.019s Progeny:0.001s Invoker:70 Definer:70 Depth:1

[-]

SELECT P.OPTIMIZER_MODE, P.CONCURRENT_PROGRAM_NAME, UPPER(P.ENABLE_TRACE), UPPER(R.ENABLE_TRACE), DECODE(UPPER(P.ENABLE_TIME_STATISTICS),
'Y','TRUE',NULL),
 EXECUTION_METHOD_CODE FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID AND
P.APPLICATION_ID = R.PROGRAM_APPLICATION_ID AND R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

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.018	0.018	0.020	-0.002
Execute:	0.001	0.001	0.000	0.001
Fetch:	0.000	0.000	0.000	0.000
Total:	0.019	0.019	0.020	-0.001

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)	Time (secs)	Obj
1:	0	1	NESTED LOOPS	6	0.001	0
2:	1	1	TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS	3	0.000	75555
3:	2	1	. INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1	2	0.000	154020
4:	1	1	TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS	3	0.000	75431
5:	4	1	. INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1	2	0.000	150272

1669648200

Rank:25(0.0%) Self:0.024s Progeny:0.003s Invoker:70 Definer:70 Depth:1

[-]

SELECT PLSQL_LOG, PLSQL_OUT, PLSQL_DIR FROM FND_CONCURRENT_PROCESSES P, FND_CONCURRENT_REQUESTS R WHERE P.CONCURRENT_PROCESS_ID =
R.CONTROLLING_MANAGER AND R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

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.023	0.023	0.030	-0.007
Execute:	0.001	0.001	0.000	0.001
Fetch:	0.000	0.000	0.000	0.000
Total:	0.024	0.024	0.030	-0.006

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)	Time (secs)	Obj
1:	0	1	NESTED LOOPS	6	0.001	0
2:	1	1	TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS	3	0.000	75555
3:	2	1	. INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1	2	0.000	154020
4:	1	1	TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROCESSES	3	0.000	75425
5:	4	1	. INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1	2	0.000	150231

3913151867

Rank:63(0.0%) Self:0.002s Progeny:0.000s Invoker:70 Definer:70 Depth:1

[-]

ALTER SESSION SET SQL_TRACE = TRUE

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

[-]

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

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

3104242407

Rank:26(0.0%) Self:0.024s Progeny:0.001s Invoker:70 Definer:70 Depth:1

[-]

SELECT SUBSTR(REPLACE(USER_CONCURRENT_PROGRAM_NAME,'''',' '),1,240),
 SUBSTR(CONCURRENT_PROGRAM_NAME,1,30) FROM FND_CONCURRENT_PROGRAMS_VL WHERE CONCURRENT_PROGRAM_ID = :B1 AND APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID

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.002	0.002	0.010	-0.008
Execute:	0.022	0.022	0.020	0.002
Fetch:	0.000	0.000	0.000	0.000
Total:	0.024	0.024	0.030	-0.006

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

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	Time (secs)	Obj
1:	0	1	NESTED LOOPS	6	0.001	0
2:	1	1	TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS	3	0.001	75431
3:	2	1	. INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1	2	0.001	150272
4:	1	1	TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL	3	0.000	75467
5:	4	1	. INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1	2	0.000	150553

528822382

Rank:60(0.0%) Self:0.004s Progeny:0.000s Invoker:70 Definer:70 Depth:1

[-]

SELECT TO_CHAR(SYSDATE,'DD-MON-YY:HH24:MI:SS') FROM SYS.DUAL

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

[-]

Call	Response Time Accounted-for	Elapsed Time	Elapsed Time Unaccounted-for
Parse:	0.003	0.003	0.003
Execute:	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000
Total:	0.004	0.004	0.004

Call	Call Count	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	1
Execute:	1	0	0
Fetch:	1	1	0
Total:	3	1	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	FAST DUAL	0	0	0	0.000	0

2739132179

Rank:59(0.0%) Self:0.004s Progeny:0.000s Invoker:70 Definer:70 Depth:1

[-]

SELECT 'TRACE_USER_DETAILS: TIMESTAMP=24-NOV-08:15:24:18: USER_NAME=KARUTOORIR: CONC_REQUEST_ID=67872650: OLTP_OPT_MODE= : CONC_OPT_MODE= :
CONC_PROG_EXE=FNDRSRPS: CONC_PROG_NAME=Reports and Sets by Responsibility: RESPONSIBILITY=System Administrator: APPL_NAME=SYSADMIN' FROM DUAL

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.010	-0.006
Execute:	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.004	0.004	0.010	-0.006

Call	Call Count	Library Cache Misses
Parse:	1	1
Execute:	1	0
Fetch:	0	0
Total:	2	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	0	FAST DUAL	0	0	0	0.000	0

3842200867

Rank:30(0.0%) Self:0.019s Progeny:0.002s Invoker:70 Definer:70 Depth:1

[-]

SELECT Q.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROCESSES P, FND_CONCURRENT_QUEUES Q WHERE R.REQUEST_ID =
FND_GLOBAL.CONC_REQUEST_ID AND R.CONTROLLING_MANAGER = P.CONCURRENT_PROCESS_ID AND Q.CONCURRENT_QUEUE_ID= P.CONCURRENT_QUEUE_ID AND Q.APPLICATION_ID =
 P.QUEUE_APPLICATION_ID

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.019	0.019	0.010	0.009
Execute:	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.019	0.019	0.010	0.009

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	8	1	0
Total:	3	8	1	1

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	Time (secs)	Obj
1:	0	1	NESTED LOOPS	8	0.001	0
2:	1	1	NESTED LOOPS	6	0.000	0
3:	2	1	. TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS	3	0.000	75555
4:	3	1	.. INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1	2	0.000	154020
5:	2	1	. TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROCESSES	3	0.000	75425
6:	5	1	.. INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1	2	0.000	150231
7:	1	1	TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_QUEUES	2	0.000	75439
8:	7	1	. INDEX UNIQUE SCAN FND_CONCURRENT_QUEUES_U1	1	0.000	150305

1655318066

Rank:34(0.0%) Self:0.016s Progeny:0.001s Invoker:70 Definer:70 Depth:1

[-]

SELECT P.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID AND
R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID

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.015	0.015	0.020	-0.005
Execute:	0.000	0.000	0.000	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.016	0.016	0.020	-0.004

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_CONCURRENT_REQUESTS	3	75555
3:	2	1	. INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1	2	154020
4:	1	1	TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS	3	75431
5:	4	1	. INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1	2	150272

375034462

Rank:55(0.0%) Self:0.005s Progeny:0.000s Invoker:70 Definer:70 Depth:1

[-]

SELECT DECODE(:B1 , 'P', 'REPORTS', 'I', 'PLSQL_CP', 'J', 'JAVA_STORED_CP', 'K', 'JAVA_CP', 'Q', 'SQLPLUS_CP', 'E', 'PERL_CP', �
39;S', 'SUBROUTINE_CP',
'A', 'SPAWNED_CP', 'H', 'HOST_CP', 'L', 'LOADER_CP', 'NOT_SUPPORTED') FROM DUAL

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.004	0.004	0.010	-0.006
Fetch:	0.000	0.000	0.000	0.000
Total:	0.005	0.005	0.010	-0.005

Call	Call Count	Rows Processed or Returned	Library Cache Misses
Parse:	1	0	1
Execute:	1	0	1
Fetch:	1	1	0
Total:	3	1	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	FAST DUAL	0	0	0	0.000	0

3101773339

Rank:4(0.0%) Self:0.175s Progeny:0.071s Invoker:70 Definer:70 Depth:1

[-]

SELECT ENABLE_ROUTINE, DISABLE_ROUTINE, DRO.DEBUG_OPTION_NAME, DRO.DEBUG_OPTION_VALUE, DR.DEBUG_RULE_ID, REPEATION_COUNTER, START_TIME, END_TIME,
USER_ID, RESPONSIBILITY_ID, RESP_APPL_ID, COMPONENT_TYPE, COMPONENT_NAME, COMPONENT_ID, COMPONENT_APPL_ID, TRACE_FILE_ROUTINE, TRACE_FILE_NODE,
COMMENTS, NVL(REQUEST_ID,0)
REQID FROM FND_DEBUG_OPTIONS DO, FND_DEBUG_RULES DR, FND_DEBUG_OPTION_VALUES DOV, FND_DEBUG_RULE_OPTIONS DRO WHERE ( DR.USER_ID = :B8 OR
(DR.RESPONSIBILITY_ID = :B7 AND DR.RESP_APPL_ID = :B6 ) OR (DR.USER_ID IS NULL AND DR.RESPONSIBILITY_ID IS NULL) )
AND (( SYSDATE >= DR.START_TIME AND SYSDATE <= DR.END_TIME) OR DR.REPEATION_COUNTER > 0 )
AND ( DR.COMPONENT_NAME = :B5 OR (DR.COMPONENT_ID = :B4 AND DR.COMPONENT_APPL_ID = :B3 ) )
AND DR.COMPONENT_TYPE = :B2 AND DRO.DEBUG_OPTION_NAME = DOV.DEBUG_OPTION_NAME AND DRO.DEBUG_OPTION_VALUE = DOV.DEBUG_OPTION_VALUE AND
DRO.DEBUG_OPTION_NAME = DO.DEBUG_OPTION_NAME AND DO.TYPE = 'D' AND DO.ENABLED_FLAG = 'Y' AND ((DR.REQUEST_ID IS NOT NULL AND :B1 = DR.REQUEST_ID)
OR (DR.REQUEST_ID IS NULL) ) AND DR.DEBUG_RULE_ID = DRO.DEBUG_RULE_ID AND DR.DEBUG_RULE_ID=(SELECT MIN(DEBUG_RULE_ID)
FROM FND_DEBUG_RULES IDR WHERE (IDR.USER_ID = :B8 OR (IDR.RESPONSIBILITY_ID = :B7 AND IDR.RESP_APPL_ID = :B6 )
OR (IDR.USER_ID IS NULL AND IDR.RESPONSIBILITY_ID IS NULL) ) AND (( SYSDATE >= IDR.START_TIME AND SYSDATE <= IDR.END_TIME)
OR IDR.REPEATION_COUNTER > 0 ) AND ( IDR.COMPONENT_NAME = :B5 OR (IDR.COMPONENT_ID = :B4 AND IDR.COMPONENT_APPL_ID = :B3 ) )
AND IDR.COMPONENT_TYPE = :B2 AND ((IDR.REQUEST_ID IS NOT NULL AND :B1 = IDR.REQUEST_ID) OR (IDR.REQUEST_ID IS NULL) ) )
ORDER BY REQID DESC, DR.CREATION_DATE, DR.DEBUG_RULE_ID

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.005	0.005	0.010	-0.005
Execute:	0.170	0.170	0.190	-0.020
Fetch:	0.000	0.000	0.000	0.000
Total:	0.175	0.175	0.200	-0.025

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

ID	PID	Row Source Operation	BG Consistent Read Mode (cr)	Obj
1:	0	SORT ORDER BY	1	0
2:	1	NESTED LOOPS	1	0
3:	2	. NESTED LOOPS	1	0
4:	3	.. NESTED LOOPS	1	0
5:	4	... TABLE ACCESS BY INDEX ROWID FND_DEBUG_RULES	1	108655
6:	5	.... INDEX RANGE SCAN FND_DEBUG_RULES_N1	1	163419
7:	5	.... SORT AGGREGATE	0	0
8:	7	....+ TABLE ACCESS BY INDEX ROWID FND_DEBUG_RULES	0	108655
9:	8	....+. INDEX RANGE SCAN FND_DEBUG_RULES_N1	0	163419
10:	4	... TABLE ACCESS BY INDEX ROWID FND_DEBUG_RULE_OPTIONS	0	108659
11:	10	.... INDEX RANGE SCAN FND_DEBUG_RULE_OPTIONS_U1	0	163422
12:	3	.. TABLE ACCESS BY INDEX ROWID FND_DEBUG_OPTIONS	0	108645
13:	12	... INDEX UNIQUE SCAN FND_DEBUG_OPTIONS_U1	0	163414
14:	2	. TABLE ACCESS BY INDEX ROWID FND_DEBUG_OPTION_VALUES	0	108649
15:	14	.. INDEX UNIQUE SCAN FND_DEBUG_OPTION_VALUES_U1	0	163416

2190775527

Rank:12(0.0%) Self:0.044s Progeny:0.029s Invoker:0 Definer:0 Depth:2

[-]

select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled  from obj$ o,user$ u,trigger$ t  where t.baseobject=:1 and t.obj#=o.obj# and
o.owner#=u.user#  and bitand(property,16)=0 and bitand(property,8)=0  order by o.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.002	0.002	0.000	0.000	0.002
Execute:	0.040	0.040	0.040	0.000	0.000
Fetch:	0.002	0.002	0.000	0.001	0.001
Total:	0.044	0.044	0.040	0.001	0.003

Call	Call Count	OS Buffer Gets (disk)	BG Consistent Read Mode (query)	Library Cache Misses	Times Waited Non-Idle
Parse:	2	0	0	1	0
Execute:	2	0	0	1	0
Fetch:	2	1	4	0	1
Total:	6	1	4	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
db file sequential read:	User I/O	0.001	1			0.001287	0.001287	1	1
Total:		0.001	1

ID	PID	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	SORT ORDER BY	4	1	0.002	0
2:	1	NESTED LOOPS	4	1	0.002	0
3:	2	. NESTED LOOPS	4	1	0.002	0
4:	3	.. TABLE ACCESS BY INDEX ROWID TRIGGER$	4	1	0.002	81
5:	4	... INDEX RANGE SCAN I_TRIGGER1	4	1	0.002	125
6:	3	.. TABLE ACCESS BY INDEX ROWID OBJ$	0	0	0.000	18
7:	6	... INDEX UNIQUE SCAN I_OBJ1	0	0	0.000	36
8:	2	. TABLE ACCESS CLUSTER USER$	0	0	0.000	22
9:	8	.. INDEX UNIQUE SCAN I_USER#	0	0	0.000	11

1329547714

Rank:41(0.0%) Self:0.014s Progeny:0.073s Invoker:70 Definer:70 Depth:1

[-]

DELETE FROM FND_DEBUG_RULE_OPTIONS WHERE DEBUG_RULE_ID IN (SELECT DEBUG_RULE_ID FROM FND_DEBUG_RULES WHERE (START_TIME IS NOT NULL AND END_TIME <
SYSDATE) OR (REPEATION_COUNTER = 0) )

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.013	0.013	0.020	-0.007
Execute:	0.001	0.001	0.000	0.001
Fetch:	0.000	0.000	0.000	0.000
Total:	0.014	0.014	0.020	-0.006

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

ID	PID	Row Source Operation	BG Consistent Read Mode (cr)	Time (secs)	Obj
1:	0	DELETE FND_DEBUG_RULE_OPTIONS	1	0.001	0
2:	1	HASH JOIN SEMI	1	0.001	0
3:	2	. INDEX FULL SCAN FND_DEBUG_RULE_OPTIONS_U1	1	0.000	163422
4:	2	. TABLE ACCESS FULL FND_DEBUG_RULES	0	0.000	108655

3145064069

Rank:48(0.0%) Self:0.011s Progeny:0.001s Invoker:70 Definer:70 Depth:1

[-]

DELETE FROM FND_DEBUG_RULES WHERE (START_TIME IS NOT NULL AND END_TIME < SYSDATE) OR (REPEATION_COUNTER = 0)

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.010	0.010	0.010	0.000
Execute:	0.000	0.000	0.010	-0.010
Fetch:	0.000	0.000	0.000	0.000
Total:	0.011	0.011	0.020	-0.009

Call	Call Count	BG Consistent Read Mode (query)	Library Cache Misses
Parse:	1	0	1
Execute:	1	3	0
Fetch:	0	0	0
Total:	2	3	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	0	DELETE FND_DEBUG_RULES	3	0	0	0.000	0
2:	1	0	TABLE ACCESS FULL FND_DEBUG_RULES	3	0	0	0.000	108655

4046303431

Rank:52(0.0%) Self:0.007s Progeny:0.021s Invoker:70 Definer:70 Depth:0

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

[-]

begin FND_CONCURRENT.SET_PREFERRED_RBS; 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.006	0.005	0.000	0.005	0.001
Execute:	0.001	0.001	0.010	-0.009	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000
Total:	0.007	0.007	0.010	-0.003	0.001

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	0	0	0
Fetch:	0	0	0	0	0
Total:	2	1	1	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.001	1	0.000692	0.000692
SQL*Net message to client:	Network	0.000	1			0.000012	0.000012
Total:		0.000	1	0.001	1

SQL Progeny - Time and Totals

[-]

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

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

569513399

Rank:27(0.0%) Self:0.020s Progeny:0.001s Invoker:70 Definer:70 Depth:1

[-]

SELECT P.ROLLBACK_SEGMENT FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID AND
R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID AND R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID

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.019	0.019	0.020	-0.001
Execute:	0.001	0.001	0.000	0.001
Fetch:	0.000	0.000	0.000	0.000
Total:	0.020	0.020	0.020	0.000

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)	Time (secs)	Obj
1:	0	1	NESTED LOOPS	6	0.001	0
2:	1	1	TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS	3	0.001	75555
3:	2	1	. INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1	2	0.001	154020
4:	1	1	TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS	3	0.000	75431
5:	4	1	. INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1	2	0.000	150272

1421832602

Rank:32(0.0%) Self:0.019s Progeny:0.000s Invoker:70 Definer:70 Depth:0

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

[-]

select responsibility_name HdrResp
from fnd_responsibility_vl
where responsibility_name = :P_Resp_Name

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.010	0.010	0.010	0.000
Fetch:	0.008	0.008	0.010	-0.002
Total:	0.019	0.019	0.020	-0.001

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	1	0	0	1	0
Execute:	1	0	0	1	0
Fetch:	1	141	1	0	1
Total:	3	141	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.000012	0.000012
Total:		0.000	1

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	Time (secs)	Obj
1:	0	1	NESTED LOOPS	141	0.008	0
2:	1	1	TABLE ACCESS FULL FND_RESPONSIBILITY_TL	139	0.008	74969
3:	1	1	INDEX UNIQUE SCAN FND_RESPONSIBILITY_U1	2	0.000	150325

Explain Plan

ID	PID	Actual Rows²	Estim Card	Cost	Explain Plan Operation	Search Cols¹	Indexed Cols	Predicates
0:			1	42	SELECT STATEMENT
1:	0	1	1	42	NESTED LOOPS
2:	1	1	1	42	. TABLE ACCESS FULL FND_RESPONSIBILITY_TL			[+]
3:	1	1	1	0	. INDEX UNIQUE SCAN FND_RESPONSIBILITY_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¹	Chain Count¹	Blocks¹	Empty Blocks¹	Avg Space¹	Global Stats¹	Part	Temp
1:	APPLSYS.FND_RESPONSIBILITY	N	N	2379	2376	2376	15-OCT-08 01:46:15	85	0	40	0	0	YES	NO	N
2:	APPLSYS.FND_RESPONSIBILITY_TL	Y	Y	9694	9691	9691	15-OCT-08 01:46:16	90	0	145	0	0	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_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U1	Y	Y	NORMAL	UNIQUE	2	APPLICATION_ID RESPONSIBILITY_ID
2:	APPLSYS.FND_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U2	N	N	NORMAL	UNIQUE	2	RESPONSIBILITY_KEY APPLICATION_ID
3:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U1	N	N	NORMAL	UNIQUE	3	APPLICATION_ID RESPONSIBILITY_ID LANGUAGE
4:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U2	N	N	NORMAL	UNIQUE	3	APPLICATION_ID RESPONSIBILITY_NAME LANGUAGE

#	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_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U1	2376	2376	15-OCT-08 01:46:16	2376	1	7	1	1	786	YES	NO	N
2:	APPLSYS.FND_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U2	2376	2376	15-OCT-08 01:46:16	2376	1	12	1	1	1526	YES	NO	N
3:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U1	9691	9691	15-OCT-08 01:46:16	9691	1	31	1	1	4217	YES	NO	N
4:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U2	9691	9691	15-OCT-08 01:46:16	9691	1	58	1	1	4775	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 Distinct¹	Density¹	Num Buckets¹	Histogram¹
1:	APPLSYS.FND_RESPONSIBILITY_TL_U1	1	APPLICATION_ID	ASC	9691	9691	15-OCT-08 01:46:16	174	5.7471e-03	1	NONE
2:	APPLSYS.FND_RESPONSIBILITY_TL_U1	2	RESPONSIBILITY_ID	ASC	9691	9691	15-OCT-08 01:46:16	2372	4.2159e-04	1	NONE
3:	APPLSYS.FND_RESPONSIBILITY_TL_U1	3	LANGUAGE	ASC	9691	9691	15-OCT-08 01:46:16	6	1.6667e-01	1	NONE
4:	APPLSYS.FND_RESPONSIBILITY_TL_U2	1	APPLICATION_ID	ASC	9691	9691	15-OCT-08 01:46:16	174	5.7471e-03	1	NONE
5:	APPLSYS.FND_RESPONSIBILITY_TL_U2	2	RESPONSIBILITY_NAME	ASC	9691	9691	15-OCT-08 01:46:16	2365	4.2283e-04	1	NONE
6:	APPLSYS.FND_RESPONSIBILITY_TL_U2	3	LANGUAGE	ASC	9691	9691	15-OCT-08 01:46:16	6	1.6667e-01	1	NONE
7:	APPLSYS.FND_RESPONSIBILITY_U1	1	APPLICATION_ID	ASC	2376	2376	15-OCT-08 01:46:15	174	5.7471e-03	1	NONE
8:	APPLSYS.FND_RESPONSIBILITY_U1	2	RESPONSIBILITY_ID	ASC	2376	2376	15-OCT-08 01:46:15	2372	4.2159e-04	1	NONE
9:	APPLSYS.FND_RESPONSIBILITY_U2	1	RESPONSIBILITY_KEY	ASC	2376	2376	15-OCT-08 01:46:15	2370	4.2194e-04	1	NONE
10:	APPLSYS.FND_RESPONSIBILITY_U2	2	APPLICATION_ID	ASC	2376	2376	15-OCT-08 01:46:15	174	5.7471e-03	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:	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:	0	0	0
Execute:	3	2	1
Fetch:	0	0	0
Total:	3	2	1

3807717945

Rank:1(99.6%) Self:460.895s Progeny:0.003s Invoker:70 Definer:70 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 distinct
       substr(fl.meaning, 1, 11)                  Type,
       fs.user_request_set_name               Name,
       fr.responsibility_name                      RespName,
       fav.application_name                        ApplName
from   fnd_request_group_units                     ru,
       fnd_request_groups                          rg,
       fnd_responsibility_vl                       fr,
       fnd_request_sets_vl                         fs,
       fnd_application_vl                          fav,
       fnd_application                             fa,
       fnd_lookups                                 fl
WHERE  ru.application_id                =      rg.application_id
AND    ru.request_group_id              =      rg.request_group_id
AND    rg.application_id                =      fr.group_application_id
AND    rg.request_group_id              =      fr.request_group_id
AND    ru.unit_application_id           =      fs.application_id
AND    fa.application_id                =      fr.application_id
AND    fa.application_short_name       =      :P_Appl_Shortname
AND    fr.responsibility_Name         =      :P_Resp_Name
AND    fl.lookup_code                   =      'S'
AND    fl.lookup_type                   =      'SRS_REQUEST_UNIT_TYPES'
AND    (ru.request_unit_id            =      fs.request_set_id
AND     ru.request_unit_type        =      'S'
AND     fav.application_id             =       ru.unit_application_id
OR       ru.request_unit_type        =      'A'
AND     fav.application_id             =       fs.application_id)
UNION
select distinct
       substr(fl.meaning, 1, 11)                   Type,
       fc.user_concurrent_program_name             Name,
       fr.responsibility_name                      RespName,
       fav.application_name                        ApplName
from   fnd_request_group_units                     ru,
       fnd_request_groups                          rg,
       fnd_responsibility_vl                       fr,
       fnd_concurrent_programs_vl                  fc,
       fnd_application_vl                          fav,
       fnd_application                             fa,
       fnd_lookups                                 fl
WHERE  ru.application_id                =      rg.application_id
AND    ru.request_group_id              =      rg.request_group_id
AND    rg.application_id                =      fr.group_application_id
AND    rg.request_group_id              =      fr.request_group_id
AND    ru.unit_application_id           =      fc.application_id
AND    fa.application_id                =      fr.application_id
AND    fa.application_short_name     =      :P_Appl_ShortName
AND    fr.responsibility_name           =      :P_Resp_Name
AND    fl.lookup_code                   =      'P'
AND    fl.lookup_type                   =      'SRS_REQUEST_UNIT_TYPES'
AND    (ru.request_unit_type       = 'P'
AND     ru.request_unit_id            = fc.concurrent_program_id
AND     fav.application_id             = ru.unit_application_id
OR      ru.request_unit_type             =      'A'
AND    fav.application_id               =      fc.application_id
AND    fc.srs_flag                      in     ('Y', 'Q')
AND    fc.enabled_flag                  =      'Y')

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.035	0.035	0.030	0.000	0.005	0.000
Execute:	0.486	0.486	0.500	0.000	-0.014	0.000
Fetch:	460.373	460.367	467.090	0.417	-7.140	0.006
Total:	460.895	460.888	467.620	0.417	-7.148	0.006

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	0
Execute:	1	0	0	0	0	0	0
Fetch:	8	62	24968181	116	0	82	7
Total:	10	62	24968181	116	1	82	7

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.411	62			0.006637	0.038493	62	1
SQL*Net message from client:	Idle			0.006	7	0.000875	0.001679
latch free:	Other	0.004	3			0.001460	0.004087
latch: cache buffers chains:	Concurrency	0.000	8			0.000053	0.000178
SQL*Net more data to client:	Network	0.000	1			0.000240	0.000240
SQL*Net message to client:	Network	0.000	8			0.000005	0.000012
Total:		0.417	82	0.006	7

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	OS Buffer Gets (pr)	Time (secs)	Obj
1:	0	116	SORT UNIQUE	24968181	62	460.366	0
2:	1	116	UNION-ALL	24968181	62	17.274	0
3:	2	12	. NESTED LOOPS	458021	26	16.416	0
4:	3	12	.. NESTED LOOPS	457995	11	16.316	0
5:	4	30392	... NESTED LOOPS	397995	8	22.813	0
6:	5	262	.... NESTED LOOPS	397469	6	5.819	0
7:	6	262	....+ NESTED LOOPS	397205	4	5.793	0
8:	7	176588	....+. NESTED LOOPS	44027	2	1.614	0
9:	8	262	....+.. NESTED LOOPS	533	2	0.040	0
10:	9	262	....+... MERGE JOIN CARTESIAN	7	2	0.027	0
11:	10	1	....+.... NESTED LOOPS	6	2	0.024	0
12:	11	1	....+....+ TABLE ACCESS BY INDEX ROWID FND_APPLICATION	2	0	0.000	74718
13:	12	1	....+....+. INDEX UNIQUE SCAN FND_APPLICATION_U3	1	0	0.000	140559
14:	11	1	....+....+ TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES	4	2	0.024	74726
15:	14	1	....+....+. INDEX RANGE SCAN FND_LOOKUP_VALUES_U1	3	1	0.014	300106
16:	10	262	....+.... BUFFER SORT	1	0	0.002	0
17:	16	262	....+....+ INDEX FULL SCAN FND_APPLICATION_U1	1	0	0.000	140558
18:	9	262	....+... TABLE ACCESS BY INDEX ROWID FND_APPLICATION_TL	526	0	0.013	74722
19:	18	262	....+.... INDEX UNIQUE SCAN FND_APPLICATION_TL_U1	264	0	0.007	140563
20:	8	176588	....+.. TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY	43494	0	1.423	74953
21:	20	218508	....+... INDEX RANGE SCAN FND_RESPONSIBILITY_U1	788	0	0.444	150325
22:	7	262	....+. TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL	353178	2	4.064	74969
23:	22	176588	....+.. INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U2	176590	2	2.297	150425
24:	6	262	....+ INDEX UNIQUE SCAN FND_REQUEST_GROUPS_U1	264	2	0.025	150230
25:	5	30392	.... INDEX RANGE SCAN FND_REQUEST_GROUP_UNITS_U1	526	2	0.080	150244
26:	4	12	... INDEX RANGE SCAN FND_REQUEST_SETS_U1	60000	3	10.892	150259
27:	3	12	.. TABLE ACCESS BY INDEX ROWID FND_REQUEST_SETS_TL	26	15	0.121	74901
28:	27	12	... INDEX UNIQUE SCAN FND_REQUEST_SETS_TL_U1	14	6	0.035	150337
29:	2	104	. NESTED LOOPS	24510160	36	52.040	0
30:	29	104	.. NESTED LOOPS	24509950	25	50.683	0
31:	30	30392	... NESTED LOOPS	397999	0	24.164	0
32:	31	262	.... NESTED LOOPS	397469	0	6.194	0
33:	32	262	....+ NESTED LOOPS	397205	0	6.183	0
34:	33	176588	....+. NESTED LOOPS	44027	0	1.767	0
35:	34	262	....+.. NESTED LOOPS	533	0	0.025	0
36:	35	262	....+... MERGE JOIN CARTESIAN	7	0	0.006	0
37:	36	1	....+.... NESTED LOOPS	6	0	0.001	0
38:	37	1	....+....+ TABLE ACCESS BY INDEX ROWID FND_APPLICATION	2	0	0.000	74718
39:	38	1	....+....+. INDEX UNIQUE SCAN FND_APPLICATION_U3	1	0	0.000	140559
40:	37	1	....+....+ TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES	4	0	0.001	74726
41:	40	1	....+....+. INDEX RANGE SCAN FND_LOOKUP_VALUES_U1	3	0	0.001	300106
42:	36	262	....+.... BUFFER SORT	1	0	0.005	0
43:	42	262	....+....+ INDEX FULL SCAN FND_APPLICATION_U1	1	0	0.001	140558
44:	35	262	....+... TABLE ACCESS BY INDEX ROWID FND_APPLICATION_TL	526	0	0.017	74722
45:	44	262	....+.... INDEX UNIQUE SCAN FND_APPLICATION_TL_U1	264	0	0.010	140563
46:	34	176588	....+.. TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY	43494	0	1.426	74953
47:	46	218508	....+... INDEX RANGE SCAN FND_RESPONSIBILITY_U1	788	0	0.447	150325
48:	33	262	....+. TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL	353178	0	4.150	74969
49:	48	176588	....+.. INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U2	176590	0	2.337	150425
50:	32	262	....+ INDEX UNIQUE SCAN FND_REQUEST_GROUPS_U1	264	0	0.008	150230
51:	31	30392	.... INDEX RANGE SCAN FND_REQUEST_GROUP_UNITS_U1	530	0	0.162	150244
52:	30	104	... TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS	24111951	25	436.811	75431
53:	52	64635924	.... INDEX RANGE SCAN FND_CONCURRENT_PROGRAMS_U1	214931	0	65.701	150272
54:	29	104	.. TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL	210	11	0.167	75467
55:	54	104	... INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1	106	2	0.023	150553

Explain Plan

ID	PID	Actual Rows²	Estim Card	Cost	Explain Plan Operation	Search Cols¹	Indexed Cols	Predicates
0:			2	54	SELECT STATEMENT
1:	0	116	2	54	SORT UNIQUE
2:	1	116			. UNION-ALL
3:	2	12	1	16	.. NESTED LOOPS
4:	3	12	1	15	... NESTED LOOPS
5:	4	30392	1	14	.... NESTED LOOPS
6:	5	262	1	13	....+ NESTED LOOPS
7:	6	262	1	13	....+. NESTED LOOPS
8:	7	176588	1	12	....+.. NESTED LOOPS
9:	8	262	1	6	....+... NESTED LOOPS
10:	9	262	1	5	....+.... MERGE JOIN CARTESIAN
11:	10	1	1	4	....+....+ NESTED LOOPS
12:	11	1	1	1	....+....+. TABLE ACCESS BY INDEX ROWID FND_APPLICATION
13:	12	1	1	0	....+....+.. INDEX UNIQUE SCAN FND_APPLICATION_U3	1/1	[+]	[+]
14:	11	1	1	3	....+....+. TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES
15:	14	1	1	2	....+....+.. INDEX RANGE SCAN FND_LOOKUP_VALUES_U1	4/5	[+]	[+]
16:	10	262	262	2	....+....+ BUFFER SORT
17:	16	262	262	1	....+....+. INDEX FULL SCAN FND_APPLICATION_U1	0/1	[+]
18:	9	262	1	1	....+.... TABLE ACCESS BY INDEX ROWID FND_APPLICATION_TL
19:	18	262	1	0	....+....+ INDEX UNIQUE SCAN FND_APPLICATION_TL_U1	2/2	[+]	[+]
20:	8	176588	5	6	....+... TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY			[+]
21:	20	218508	14	1	....+.... INDEX RANGE SCAN FND_RESPONSIBILITY_U1	1/2	[+]	[+]
22:	7	262	1	1	....+.. TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL			[+]
23:	22	176588	1	0	....+... INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U2	3/3	[+]	[+]
24:	6	262	1	0	....+. INDEX UNIQUE SCAN FND_REQUEST_GROUPS_U1	2/2	[+]	[+]
25:	5	30392	31	1	....+ INDEX RANGE SCAN FND_REQUEST_GROUP_UNITS_U1	2/5	[+]	[+]
26:	4	12	1	1	.... INDEX RANGE SCAN FND_REQUEST_SETS_U1	1/2	[+]	[+]
27:	3	12	1	1	... TABLE ACCESS BY INDEX ROWID FND_REQUEST_SETS_TL
28:	27	12	1	0	.... INDEX UNIQUE SCAN FND_REQUEST_SETS_TL_U1	3/3	[+]	[+]
29:	2	104	1	36	.. NESTED LOOPS
30:	29	104	1	35	... NESTED LOOPS
31:	30	30392	1	14	.... NESTED LOOPS
32:	31	262	1	13	....+ NESTED LOOPS
33:	32	262	1	13	....+. NESTED LOOPS
34:	33	176588	1	12	....+.. NESTED LOOPS
35:	34	262	1	6	....+... NESTED LOOPS
36:	35	262	1	5	....+.... MERGE JOIN CARTESIAN
37:	36	1	1	4	....+....+ NESTED LOOPS
38:	37	1	1	1	....+....+. TABLE ACCESS BY INDEX ROWID FND_APPLICATION
39:	38	1	1	0	....+....+.. INDEX UNIQUE SCAN FND_APPLICATION_U3	1/1	[+]	[+]
40:	37	1	1	3	....+....+. TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES
41:	40	1	1	2	....+....+.. INDEX RANGE SCAN FND_LOOKUP_VALUES_U1	4/5	[+]	[+]
42:	36	262	262	2	....+....+ BUFFER SORT
43:	42	262	262	1	....+....+. INDEX FULL SCAN FND_APPLICATION_U1	0/1	[+]
44:	35	262	1	1	....+.... TABLE ACCESS BY INDEX ROWID FND_APPLICATION_TL
45:	44	262	1	0	....+....+ INDEX UNIQUE SCAN FND_APPLICATION_TL_U1	2/2	[+]	[+]
46:	34	176588	5	6	....+... TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY			[+]
47:	46	218508	14	1	....+.... INDEX RANGE SCAN FND_RESPONSIBILITY_U1	1/2	[+]	[+]
48:	33	262	1	1	....+.. TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL			[+]
49:	48	176588	1	0	....+... INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U2	3/3	[+]	[+]
50:	32	262	1	0	....+. INDEX UNIQUE SCAN FND_REQUEST_GROUPS_U1	2/2	[+]	[+]
51:	31	30392	31	1	....+ INDEX RANGE SCAN FND_REQUEST_GROUP_UNITS_U1	2/5	[+]	[+]
52:	30	104	1	21	.... TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS			[+]
53:	52	64635924	60	1	....+ INDEX RANGE SCAN FND_CONCURRENT_PROGRAMS_U1	1/2	[+]	[+]
54:	29	104	1	1	... TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL
55:	54	104	1	0	.... INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1	3/3	[+]	[+]

(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¹	Global Stats¹	Part	Temp
1:	APPLSYS.FND_APPLICATION	Y	Y	262	262	262	15-OCT-08 01:40:46	43	5	YES	NO	N
2:	APPLSYS.FND_APPLICATION_TL	Y	Y	1532	1532	1532	15-OCT-08 01:40:46	55	18	YES	NO	N
3:	APPLSYS.FND_CONCURRENT_PROGRAMS	Y	Y	10308	10306	10306	24-NOV-08 22:03:59	113	230	YES	NO	N
4:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	Y	Y	46503	46610	9322	15-OCT-08 01:41:32	109	785	YES	NO	N
5:	APPLSYS.FND_LOOKUP_VALUES	Y	Y	539279	539885	107977	15-OCT-08 01:45:31	122	8767	YES	NO	N
6:	APPLSYS.FND_REQUEST_GROUPS	N	N	749	749	749	15-OCT-08 01:46:12	96	14	YES	NO	N
7:	APPLSYS.FND_REQUEST_GROUP_UNITS	N	N	23432	23312	23312	15-OCT-08 01:46:13	44	170	YES	NO	N
8:	APPLSYS.FND_REQUEST_SETS	N	N	700	695	695	15-OCT-08 01:46:13	76	13	YES	NO	N
9:	APPLSYS.FND_REQUEST_SETS_TL	Y	Y	3115	3110	3110	15-OCT-08 01:46:13	116	68	YES	NO	N
10:	APPLSYS.FND_RESPONSIBILITY	Y	Y	2379	2376	2376	15-OCT-08 01:46:15	85	40	YES	NO	N
11:	APPLSYS.FND_RESPONSIBILITY_TL	Y	Y	9694	9691	9691	15-OCT-08 01:46:16	90	145	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	Y	Y	NORMAL	UNIQUE	1	APPLICATION_ID
2:	APPLSYS.FND_APPLICATION	APPLSYS.FND_APPLICATION_U3	Y	Y	NORMAL	UNIQUE	1	APPLICATION_SHORT_NAME
3:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U1	Y	Y	NORMAL	UNIQUE	2	APPLICATION_ID LANGUAGE
4:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U2	N	N	NORMAL	UNIQUE	2	APPLICATION_NAME LANGUAGE
5:	APPLSYS.FND_CONCURRENT_PROGRAMS	APPLSYS.FND_CONCURRENT_PROGRAMS_U1	Y	Y	NORMAL	UNIQUE	2	APPLICATION_ID CONCURRENT_PROGRAM_ID
6:	APPLSYS.FND_CONCURRENT_PROGRAMS	APPLSYS.FND_CONCURRENT_PROGRAMS_U2	N	N	NORMAL	UNIQUE	2	APPLICATION_ID CONCURRENT_PROGRAM_NAME
7:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_N1	N	N	NORMAL	NONUNIQUE	2	USER_CONCURRENT_PROGRAM_NAME LANGUAGE
8:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U1	Y	Y	NORMAL	UNIQUE	3	APPLICATION_ID CONCURRENT_PROGRAM_ID LANGUAGE
9:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U2	N	N	NORMAL	UNIQUE	3	APPLICATION_ID USER_CONCURRENT_PROGRAM_NAME LANGUAGE
10:	APPLSYS.FND_LOOKUP_VALUES	APPLSYS.FND_LOOKUP_VALUES_U2	N	N	NORMAL	UNIQUE	5	LOOKUP_TYPE VIEW_APPLICATION_ID MEANING SECURITY_GROUP_ID LANGUAGE
11:	APPLSYS.FND_LOOKUP_VALUES	APPLSYS.TE_FND_LOOKUP_VALUES_N1	N	N	NORMAL	NONUNIQUE	2	LOOKUP_TYPE ENABLED_FLAG
12:	APPLSYS.FND_LOOKUP_VALUES	APPS.FND_LOOKUP_VALUES_U1	Y	Y	NORMAL	UNIQUE	5	LOOKUP_TYPE VIEW_APPLICATION_ID LOOKUP_CODE SECURITY_GROUP_ID LANGUAGE
13:	APPLSYS.FND_REQUEST_GROUPS	APPLSYS.FND_REQUEST_GROUPS_U1	Y	Y	NORMAL	UNIQUE	2	APPLICATION_ID REQUEST_GROUP_ID
14:	APPLSYS.FND_REQUEST_GROUPS	APPLSYS.FND_REQUEST_GROUPS_U2	N	N	NORMAL	UNIQUE	2	APPLICATION_ID REQUEST_GROUP_NAME
15:	APPLSYS.FND_REQUEST_GROUP_UNITS	APPLSYS.FND_REQUEST_GROUP_UNITS_U1	Y	Y	NORMAL	UNIQUE	5	APPLICATION_ID REQUEST_GROUP_ID REQUEST_UNIT_TYPE UNIT_APPLICATION_ID REQUEST_UNIT_ID
16:	APPLSYS.FND_REQUEST_SETS	APPLSYS.FND_REQUEST_SETS_U1	Y	Y	NORMAL	UNIQUE	2	APPLICATION_ID REQUEST_SET_ID
17:	APPLSYS.FND_REQUEST_SETS	APPLSYS.FND_REQUEST_SETS_U2	N	N	NORMAL	UNIQUE	2	APPLICATION_ID REQUEST_SET_NAME
18:	APPLSYS.FND_REQUEST_SETS_TL	APPLSYS.FND_REQUEST_SETS_TL_N1	N	N	NORMAL	NONUNIQUE	1	LANGUAGE
19:	APPLSYS.FND_REQUEST_SETS_TL	APPLSYS.FND_REQUEST_SETS_TL_U1	Y	Y	NORMAL	UNIQUE	3	APPLICATION_ID REQUEST_SET_ID LANGUAGE
20:	APPLSYS.FND_REQUEST_SETS_TL	APPLSYS.FND_REQUEST_SETS_TL_U2	N	N	NORMAL	UNIQUE	3	USER_REQUEST_SET_NAME APPLICATION_ID LANGUAGE
21:	APPLSYS.FND_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U1	Y	Y	NORMAL	UNIQUE	2	APPLICATION_ID RESPONSIBILITY_ID
22:	APPLSYS.FND_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U2	N	N	NORMAL	UNIQUE	2	RESPONSIBILITY_KEY APPLICATION_ID
23:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U1	N	N	NORMAL	UNIQUE	3	APPLICATION_ID RESPONSIBILITY_ID LANGUAGE
24:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U2	Y	Y	NORMAL	UNIQUE	3	APPLICATION_ID RESPONSIBILITY_NAME LANGUAGE

#	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	262	262	15-OCT-08 01:40:46	262	0	1	1	1	62	YES	NO	N
2:	APPLSYS.FND_APPLICATION	APPLSYS.FND_APPLICATION_U3	262	262	15-OCT-08 01:40:46	262	0	1	1	1	120	YES	NO	N
3:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U1	1532	1532	15-OCT-08 01:40:46	1532	1	4	1	1	1161	YES	NO	N
4:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U2	1532	1532	15-OCT-08 01:40:46	1532	1	8	1	1	1176	YES	NO	N
5:	APPLSYS.FND_CONCURRENT_PROGRAMS	APPLSYS.FND_CONCURRENT_PROGRAMS_U1	10306	10306	24-NOV-08 22:04:02	10306	1	28	1	1	3308	YES	NO	N
6:	APPLSYS.FND_CONCURRENT_PROGRAMS	APPLSYS.FND_CONCURRENT_PROGRAMS_U2	10306	10306	24-NOV-08 22:04:02	10306	1	42	1	1	5150	YES	NO	N
7:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_N1	46470	46470	15-OCT-08 01:41:33	45952	2	323	1	1	29738	YES	NO	N
8:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U1	46470	46470	15-OCT-08 01:41:33	46470	1	144	1	1	27201	YES	NO	N
9:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U2	46470	46470	15-OCT-08 01:41:32	46470	2	343	1	1	29163	YES	NO	N
10:	APPLSYS.FND_LOOKUP_VALUES	APPLSYS.FND_LOOKUP_VALUES_U2	530367	135965	15-OCT-08 01:45:33	530367	2	4275	1	1	357559	YES	NO	N
11:	APPLSYS.FND_LOOKUP_VALUES	APPLSYS.TE_FND_LOOKUP_VALUES_N1	530056	246519	15-OCT-08 01:45:34	12858	2	2299	1	4	52438	YES	NO	N
12:	APPLSYS.FND_LOOKUP_VALUES	APPS.FND_LOOKUP_VALUES_U1	539279	539279	21-NOV-08 13:31:21	539279	2	3252	1	1	350407	NO	NO	N
13:	APPLSYS.FND_REQUEST_GROUPS	APPLSYS.FND_REQUEST_GROUPS_U1	749	749	15-OCT-08 01:46:12	749	1	2	1	1	258	YES	NO	N
14:	APPLSYS.FND_REQUEST_GROUPS	APPLSYS.FND_REQUEST_GROUPS_U2	749	749	15-OCT-08 01:46:12	749	1	4	1	1	327	YES	NO	N
15:	APPLSYS.FND_REQUEST_GROUP_UNITS	APPLSYS.FND_REQUEST_GROUP_UNITS_U1	23312	23312	15-OCT-08 01:46:13	23312	1	90	1	1	4835	YES	NO	N
16:	APPLSYS.FND_REQUEST_SETS	APPLSYS.FND_REQUEST_SETS_U1	695	695	15-OCT-08 01:46:13	695	1	2	1	1	305	YES	NO	N
17:	APPLSYS.FND_REQUEST_SETS	APPLSYS.FND_REQUEST_SETS_U2	695	695	15-OCT-08 01:46:13	695	1	3	1	1	406	YES	NO	N
18:	APPLSYS.FND_REQUEST_SETS_TL	APPLSYS.FND_REQUEST_SETS_TL_N1	3110	3110	15-OCT-08 01:46:13	6	1	6	1	51	310	YES	NO	N
19:	APPLSYS.FND_REQUEST_SETS_TL	APPLSYS.FND_REQUEST_SETS_TL_U1	3110	3110	15-OCT-08 01:46:13	3110	1	9	1	1	1112	YES	NO	N
20:	APPLSYS.FND_REQUEST_SETS_TL	APPLSYS.FND_REQUEST_SETS_TL_U2	3110	3110	15-OCT-08 01:46:13	3110	1	22	1	1	1260	YES	NO	N
21:	APPLSYS.FND_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U1	2376	2376	15-OCT-08 01:46:16	2376	1	7	1	1	786	YES	NO	N
22:	APPLSYS.FND_RESPONSIBILITY	APPLSYS.FND_RESPONSIBILITY_U2	2376	2376	15-OCT-08 01:46:16	2376	1	12	1	1	1526	YES	NO	N
23:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U1	9691	9691	15-OCT-08 01:46:16	9691	1	31	1	1	4217	YES	NO	N
24:	APPLSYS.FND_RESPONSIBILITY_TL	APPLSYS.FND_RESPONSIBILITY_TL_U2	9691	9691	15-OCT-08 01:46:16	9691	1	58	1	1	4775	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 Distinct¹	Density¹	Num Buckets¹	Histogram¹
1:	APPLSYS.FND_APPLICATION_TL_U1	1	APPLICATION_ID	ASC	1532	1532	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
2:	APPLSYS.FND_APPLICATION_TL_U1	2	LANGUAGE	ASC	1532	1532	15-OCT-08 01:40:46	6	1.6667e-01	1	NONE
3:	APPLSYS.FND_APPLICATION_TL_U2	1	APPLICATION_NAME	ASC	1532	1532	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
4:	APPLSYS.FND_APPLICATION_TL_U2	2	LANGUAGE	ASC	1532	1532	15-OCT-08 01:40:46	6	1.6667e-01	1	NONE
5:	APPLSYS.FND_APPLICATION_U1	1	APPLICATION_ID	ASC	262	262	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
6:	APPLSYS.FND_APPLICATION_U3	1	APPLICATION_SHORT_NAME	ASC	262	262	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
7:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_N1	1	USER_CONCURRENT_PROGRAM_NAME	ASC	46610	9322	15-OCT-08 01:41:32	8213	1.2176e-04	1	NONE
8:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_N1	2	LANGUAGE	ASC	46610	9322	15-OCT-08 01:41:32	6	1.6667e-01	1	NONE
9:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U1	1	APPLICATION_ID	ASC	46610	9322	15-OCT-08 01:41:32	158	6.3291e-03	1	NONE
10:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U1	2	CONCURRENT_PROGRAM_ID	ASC	46610	9322	15-OCT-08 01:41:32	8279	1.2079e-04	1	NONE
11:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U1	3	LANGUAGE	ASC	46610	9322	15-OCT-08 01:41:32	6	1.6667e-01	1	NONE
12:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U2	1	APPLICATION_ID	ASC	46610	9322	15-OCT-08 01:41:32	158	6.3291e-03	1	NONE
13:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U2	2	USER_CONCURRENT_PROGRAM_NAME	ASC	46610	9322	15-OCT-08 01:41:32	8213	1.2176e-04	1	NONE
14:	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U2	3	LANGUAGE	ASC	46610	9322	15-OCT-08 01:41:32	6	1.6667e-01	1	NONE
15:	APPLSYS.FND_CONCURRENT_PROGRAMS_U1	1	APPLICATION_ID	ASC	10306	10306	24-NOV-08 22:03:59	171	4.8515e-05	171	FREQUENCY
16:	APPLSYS.FND_CONCURRENT_PROGRAMS_U1	2	CONCURRENT_PROGRAM_ID	ASC	10306	10306	24-NOV-08 22:03:59	10262	9.7859e-05	254	HEIGHT BALANCED
17:	APPLSYS.FND_CONCURRENT_PROGRAMS_U2	1	APPLICATION_ID	ASC	10306	10306	24-NOV-08 22:03:59	171	4.8515e-05	171	FREQUENCY
18:	APPLSYS.FND_CONCURRENT_PROGRAMS_U2	2	CONCURRENT_PROGRAM_NAME	ASC	10306	10306	24-NOV-08 22:03:59	10223	9.8744e-05	254	HEIGHT BALANCED
19:	APPLSYS.FND_LOOKUP_VALUES_U2	1	LOOKUP_TYPE	ASC	539885	107977	15-OCT-08 01:45:31	10830	9.2336e-05	1	NONE
20:	APPLSYS.FND_LOOKUP_VALUES_U2	2	VIEW_APPLICATION_ID	ASC	539885	107977	15-OCT-08 01:45:31	74	9.2612e-07	74	FREQUENCY
21:	APPLSYS.FND_LOOKUP_VALUES_U2	3	MEANING	ASC	539885	107977	15-OCT-08 01:45:31	59881	1.6700e-05	1	NONE
22:	APPLSYS.FND_LOOKUP_VALUES_U2	4	SECURITY_GROUP_ID	ASC	539885	107977	15-OCT-08 01:45:31	1	1.0000e+00	1	NONE
23:	APPLSYS.FND_LOOKUP_VALUES_U2	5	LANGUAGE	ASC	539885	107977	15-OCT-08 01:45:31	6	9.2612e-07	6	FREQUENCY
24:	APPLSYS.FND_REQUEST_GROUPS_U1	1	APPLICATION_ID	ASC	749	749	15-OCT-08 01:46:12	153	6.5359e-03	1	NONE
25:	APPLSYS.FND_REQUEST_GROUPS_U1	2	REQUEST_GROUP_ID	ASC	749	749	15-OCT-08 01:46:12	748	1.3369e-03	1	NONE
26:	APPLSYS.FND_REQUEST_GROUPS_U2	1	APPLICATION_ID	ASC	749	749	15-OCT-08 01:46:12	153	6.5359e-03	1	NONE
27:	APPLSYS.FND_REQUEST_GROUPS_U2	2	REQUEST_GROUP_NAME	ASC	749	749	15-OCT-08 01:46:12	722	1.3850e-03	1	NONE
28:	APPLSYS.FND_REQUEST_GROUP_UNITS_U1	1	APPLICATION_ID	ASC	23312	23312	15-OCT-08 01:46:13	150	6.6667e-03	1	NONE
29:	APPLSYS.FND_REQUEST_GROUP_UNITS_U1	2	REQUEST_GROUP_ID	ASC	23312	23312	15-OCT-08 01:46:13	719	1.3908e-03	1	NONE
30:	APPLSYS.FND_REQUEST_GROUP_UNITS_U1	3	REQUEST_UNIT_TYPE	ASC	23312	23312	15-OCT-08 01:46:13	3	3.3333e-01	1	NONE
31:	APPLSYS.FND_REQUEST_GROUP_UNITS_U1	4	UNIT_APPLICATION_ID	ASC	23312	23312	15-OCT-08 01:46:13	165	6.0606e-03	1	NONE
32:	APPLSYS.FND_REQUEST_GROUP_UNITS_U1	5	REQUEST_UNIT_ID	ASC	23312	23312	15-OCT-08 01:46:13	7713	1.2965e-04	1	NONE
33:	APPLSYS.FND_REQUEST_SETS_TL_N1	1	LANGUAGE	ASC	3110	3110	15-OCT-08 01:46:13	6	1.6667e-01	1	NONE
34:	APPLSYS.FND_REQUEST_SETS_TL_U1	1	APPLICATION_ID	ASC	3110	3110	15-OCT-08 01:46:13	64	1.5625e-02	1	NONE
35:	APPLSYS.FND_REQUEST_SETS_TL_U1	2	REQUEST_SET_ID	ASC	3110	3110	15-OCT-08 01:46:13	695	1.4388e-03	1	NONE
36:	APPLSYS.FND_REQUEST_SETS_TL_U1	3	LANGUAGE	ASC	3110	3110	15-OCT-08 01:46:13	6	1.6667e-01	1	NONE
37:	APPLSYS.FND_REQUEST_SETS_TL_U2	1	USER_REQUEST_SET_NAME	ASC	3110	3110	15-OCT-08 01:46:13	700	1.4286e-03	1	NONE
38:	APPLSYS.FND_REQUEST_SETS_TL_U2	2	APPLICATION_ID	ASC	3110	3110	15-OCT-08 01:46:13	64	1.5625e-02	1	NONE
39:	APPLSYS.FND_REQUEST_SETS_TL_U2	3	LANGUAGE	ASC	3110	3110	15-OCT-08 01:46:13	6	1.6667e-01	1	NONE
40:	APPLSYS.FND_REQUEST_SETS_U1	1	APPLICATION_ID	ASC	695	695	15-OCT-08 01:46:13	64	1.5625e-02	1	NONE
41:	APPLSYS.FND_REQUEST_SETS_U1	2	REQUEST_SET_ID	ASC	695	695	15-OCT-08 01:46:13	695	1.4388e-03	1	NONE
42:	APPLSYS.FND_REQUEST_SETS_U2	1	APPLICATION_ID	ASC	695	695	15-OCT-08 01:46:13	64	1.5625e-02	1	NONE
43:	APPLSYS.FND_REQUEST_SETS_U2	2	REQUEST_SET_NAME	ASC	695	695	15-OCT-08 01:46:13	688	1.4535e-03	1	NONE
44:	APPLSYS.FND_RESPONSIBILITY_TL_U1	1	APPLICATION_ID	ASC	9691	9691	15-OCT-08 01:46:16	174	5.7471e-03	1	NONE
45:	APPLSYS.FND_RESPONSIBILITY_TL_U1	2	RESPONSIBILITY_ID	ASC	9691	9691	15-OCT-08 01:46:16	2372	4.2159e-04	1	NONE
46:	APPLSYS.FND_RESPONSIBILITY_TL_U1	3	LANGUAGE	ASC	9691	9691	15-OCT-08 01:46:16	6	1.6667e-01	1	NONE
47:	APPLSYS.FND_RESPONSIBILITY_TL_U2	1	APPLICATION_ID	ASC	9691	9691	15-OCT-08 01:46:16	174	5.7471e-03	1	NONE
48:	APPLSYS.FND_RESPONSIBILITY_TL_U2	2	RESPONSIBILITY_NAME	ASC	9691	9691	15-OCT-08 01:46:16	2365	4.2283e-04	1	NONE
49:	APPLSYS.FND_RESPONSIBILITY_TL_U2	3	LANGUAGE	ASC	9691	9691	15-OCT-08 01:46:16	6	1.6667e-01	1	NONE
50:	APPLSYS.FND_RESPONSIBILITY_U1	1	APPLICATION_ID	ASC	2376	2376	15-OCT-08 01:46:15	174	5.7471e-03	1	NONE
51:	APPLSYS.FND_RESPONSIBILITY_U1	2	RESPONSIBILITY_ID	ASC	2376	2376	15-OCT-08 01:46:15	2372	4.2159e-04	1	NONE
52:	APPLSYS.FND_RESPONSIBILITY_U2	1	RESPONSIBILITY_KEY	ASC	2376	2376	15-OCT-08 01:46:15	2370	4.2194e-04	1	NONE
53:	APPLSYS.FND_RESPONSIBILITY_U2	2	APPLICATION_ID	ASC	2376	2376	15-OCT-08 01:46:15	174	5.7471e-03	1	NONE
54:	APPLSYS.TE_FND_LOOKUP_VALUES_N1	1	LOOKUP_TYPE	ASC	539885	107977	15-OCT-08 01:45:31	10830	9.2336e-05	1	NONE
55:	APPLSYS.TE_FND_LOOKUP_VALUES_N1	2	ENABLED_FLAG	ASC	539885	107977	15-OCT-08 01:45:31	3	3.3333e-01	1	NONE
56:	APPS.FND_LOOKUP_VALUES_U1	1	LOOKUP_TYPE	ASC	539885	107977	15-OCT-08 01:45:31	10830	9.2336e-05	1	NONE
57:	APPS.FND_LOOKUP_VALUES_U1	2	VIEW_APPLICATION_ID	ASC	539885	107977	15-OCT-08 01:45:31	74	9.2612e-07	74	FREQUENCY
58:	APPS.FND_LOOKUP_VALUES_U1	3	LOOKUP_CODE	ASC	539885	107977	15-OCT-08 01:45:31	38493	2.5979e-05	1	NONE
59:	APPS.FND_LOOKUP_VALUES_U1	4	SECURITY_GROUP_ID	ASC	539885	107977	15-OCT-08 01:45:31	1	1.0000e+00	1	NONE
60:	APPS.FND_LOOKUP_VALUES_U1	5	LANGUAGE	ASC	539885	107977	15-OCT-08 01:45:31	6	9.2612e-07	6	FREQUENCY

(1) CBO statistics.
Back to Top

SQL Progeny - Time and Totals

[-]

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

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned
Parse:	24	16	8
Execute:	12	12	0
Fetch:	0	0	0
Total:	36	28	8

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	75467	TABLE	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	db file sequential read	0.138	9	0.015289	0.038493	9	1
2	74901	TABLE	APPLSYS.FND_REQUEST_SETS_TL	db file sequential read	0.083	9	0.009233	0.016030	9	1
3	75431	TABLE	APPLSYS.FND_CONCURRENT_PROGRAMS	db file sequential read	0.039	25	0.001544	0.013325	25	1
4	150337	INDEX	APPLSYS.FND_REQUEST_SETS_TL_U1	db file sequential read	0.033	6	0.005509	0.015237	6	1
5	150259	INDEX	APPLSYS.FND_REQUEST_SETS_U1	db file sequential read	0.026	3	0.008777	0.017600	3	1
6	150425	INDEX	APPLSYS.FND_RESPONSIBILITY_TL_U2	db file sequential read	0.022	2	0.010923	0.011161	2	1
7	150230	INDEX	APPLSYS.FND_REQUEST_GROUPS_U1	db file sequential read	0.019	2	0.009576	0.012289	2	1
8	150553	INDEX	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U1	db file sequential read	0.018	2	0.009137	0.012719	2	1
9	300106	INDEX	APPS.FND_LOOKUP_VALUES_U1	db file sequential read	0.012	1	0.012281	0.012281	1	1
10	150244	INDEX	APPLSYS.FND_REQUEST_GROUP_UNITS_U1	db file sequential read	0.011	2	0.005677	0.011178	2	1
11	74726	TABLE	APPLSYS.FND_LOOKUP_VALUES	db file sequential read	0.010	1	0.009918	0.009918	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
1	300106	INDEX	APPS.FND_LOOKUP_VALUES_U1	NOV-24 15:24:19.877	NOV-24 15:24:19.890	0.012	0.012	1
2	74726	TABLE	APPLSYS.FND_LOOKUP_VALUES	NOV-24 15:24:19.891	NOV-24 15:24:19.901	0.010	0.010	1
3	150425	INDEX	APPLSYS.FND_RESPONSIBILITY_TL_U2	NOV-24 15:24:19.902	NOV-24 15:24:19.924	0.022	0.022	2
4	150230	INDEX	APPLSYS.FND_REQUEST_GROUPS_U1	NOV-24 15:24:19.926	NOV-24 15:24:19.946	0.020	0.019	2
5	150244	INDEX	APPLSYS.FND_REQUEST_GROUP_UNITS_U1	NOV-24 15:24:19.946	NOV-24 15:24:20.008	0.062	0.011	2
6	150259	INDEX	APPLSYS.FND_REQUEST_SETS_U1	NOV-24 15:24:19.958	NOV-24 15:24:19.984	0.027	0.026	3
7	150337	INDEX	APPLSYS.FND_REQUEST_SETS_TL_U1	NOV-24 15:24:36.187	NOV-24 15:24:36.296	0.110	0.033	6
8	74901	TABLE	APPLSYS.FND_REQUEST_SETS_TL	NOV-24 15:24:36.194	NOV-24 15:24:36.313	0.119	0.083	9
9	75431	TABLE	APPLSYS.FND_CONCURRENT_PROGRAMS	NOV-24 15:24:36.915	NOV-24 15:24:36.981	0.066	0.039	25
10	150553	INDEX	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U1	NOV-24 15:25:27.022	NOV-24 15:25:27.058	0.036	0.018	2
11	75467	TABLE	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	NOV-24 15:25:27.028	NOV-24 15:31:44.134	377.105	0.138	9

(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

2508053271

Rank:45(0.0%) Self:0.012s Progeny:0.000s Invoker:70 Definer:70 Depth:0

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

[-]

select application_name
from fnd_application_vl
where application_short_name = :P_Appl_Shortname

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.002	0.002	0.000	0.002
Execute:	0.010	0.010	0.010	0.000
Fetch:	0.000	0.000	0.000	0.000
Total:	0.012	0.012	0.010	0.002

Call	Call Count	BG Consistent Read Mode (query)	Rows Processed or Returned	Library Cache Misses	Times Waited Non-Idle
Parse:	1	0	0	1	0
Execute:	1	0	0	1	0
Fetch:	1	5	1	0	1
Total:	3	5	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.000009	0.000009
Total:		0.000	1

ID	PID	Actual Rows	Row Source Operation	BG Consistent Read Mode (cr)	Obj
1:	0	1	NESTED LOOPS	5	0
2:	1	1	TABLE ACCESS BY INDEX ROWID FND_APPLICATION	2	74718
3:	2	1	. INDEX UNIQUE SCAN FND_APPLICATION_U3	1	140559
4:	1	1	TABLE ACCESS BY INDEX ROWID FND_APPLICATION_TL	3	74722
5:	4	1	. INDEX UNIQUE SCAN FND_APPLICATION_TL_U1	2	140563

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	NESTED LOOPS
2:	1	1	1	1	. TABLE ACCESS BY INDEX ROWID FND_APPLICATION
3:	2	1	1	0	.. INDEX UNIQUE SCAN FND_APPLICATION_U3	1/1	[+]	[+]
4:	1	1	255	1	. TABLE ACCESS BY INDEX ROWID FND_APPLICATION_TL
5:	4	1	1	0	.. INDEX UNIQUE SCAN FND_APPLICATION_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¹	Chain Count¹	Blocks¹	Empty Blocks¹	Avg Space¹	Global Stats¹	Part	Temp
1:	APPLSYS.FND_APPLICATION	Y	Y	262	262	262	15-OCT-08 01:40:46	43	0	5	0	0	YES	NO	N
2:	APPLSYS.FND_APPLICATION_TL	Y	Y	1532	1532	1532	15-OCT-08 01:40:46	55	0	18	0	0	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	Y	NORMAL	UNIQUE	1	APPLICATION_SHORT_NAME
3:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U1	Y	Y	NORMAL	UNIQUE	2	APPLICATION_ID LANGUAGE
4:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U2	N	N	NORMAL	UNIQUE	2	APPLICATION_NAME LANGUAGE

#	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	262	262	15-OCT-08 01:40:46	262	0	1	1	1	62	YES	NO	N
2:	APPLSYS.FND_APPLICATION	APPLSYS.FND_APPLICATION_U3	262	262	15-OCT-08 01:40:46	262	0	1	1	1	120	YES	NO	N
3:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U1	1532	1532	15-OCT-08 01:40:46	1532	1	4	1	1	1161	YES	NO	N
4:	APPLSYS.FND_APPLICATION_TL	APPLSYS.FND_APPLICATION_TL_U2	1532	1532	15-OCT-08 01:40:46	1532	1	8	1	1	1176	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 Distinct¹	Density¹	Num Buckets¹	Histogram¹
1:	APPLSYS.FND_APPLICATION_TL_U1	1	APPLICATION_ID	ASC	1532	1532	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
2:	APPLSYS.FND_APPLICATION_TL_U1	2	LANGUAGE	ASC	1532	1532	15-OCT-08 01:40:46	6	1.6667e-01	1	NONE
3:	APPLSYS.FND_APPLICATION_TL_U2	1	APPLICATION_NAME	ASC	1532	1532	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
4:	APPLSYS.FND_APPLICATION_TL_U2	2	LANGUAGE	ASC	1532	1532	15-OCT-08 01:40:46	6	1.6667e-01	1	NONE
5:	APPLSYS.FND_APPLICATION_U1	1	APPLICATION_ID	ASC	262	262	15-OCT-08 01:40:46	262	3.8168e-03	1	NONE
6:	APPLSYS.FND_APPLICATION_U3	1	APPLICATION_SHORT_NAME	ASC	262	262	15-OCT-08 01:40:46	262	3.8168e-03	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:	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:	0	0	0
Execute:	3	2	1
Fetch:	0	0	0
Total:	3	2	1

1884498448

Rank:39(0.0%) Self:0.015s Progeny:0.077s Invoker:70 Definer:70 Depth:0

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

[-]

begin fnd_conc_stat.collect; 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.007	0.000	0.000	0.000	0.007
Execute:	0.008	0.008	0.010	-0.002	0.000
Fetch:	0.000	0.000	0.000	0.000	0.000
Total:	0.015	0.008	0.010	-0.002	0.007

Call	Call Count	Rows Processed or Returned	Times Waited Non-Idle	Times Waited Idle
Parse:	1	0	1	1
Execute:	1	1	0	0
Fetch:	0	0	0	0
Total:	2	1	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.007	1	0.006800	0.006800
SQL*Net message to client:	Network	0.000	1			0.000012	0.000012
Total:		0.000	1	0.007	1

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:	0.077	0.032	0.030	0.045	-0.042	0.045
Fetch:	0.000	0.000	0.000	0.000	0.000	0.000
Total:	0.077	0.032	0.030	0.045	-0.042	0.045

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:	38	1	42	5	1	2	3
Fetch:	0	0	0	0	0	0	0
Total:	38	1	42	5	1	2	3

255214545

Rank:23(0.0%) Self:0.027s Progeny:0.047s Invoker:70 Definer:70 Depth:1

[-]

SELECT STAT_COLLECT FROM FND_CONCURRENT_PROGRAMS WHERE CONCURRENT_PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID AND APPLICATION_ID =
FND_GLOBAL.PROG_APPL_ID

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.026	0.026	0.020	0.006
Execute:	0.001	0.001	0.000	0.001
Fetch:	0.000	0.000	0.000	0.000
Total:	0.027	0.027	0.020	0.007

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	3	1	0
Total:	3	3	1	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 FND_CONCURRENT_PROGRAMS	3	0	0	0.001	75431
2:	1	1	INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1	2	0	0	0.001	150272

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:	75467	TABLE	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	db file sequential read	0.138	9	0.015289	0.038493	9	1
2:		CLUSTER	SYS.C_OBJ#_INTCOL#	db file sequential read	0.127	29	0.004384	0.013529	29	1
3:	74901	TABLE	APPLSYS.FND_REQUEST_SETS_TL	db file sequential read	0.083	9	0.009233	0.016030	9	1
4:	75431	TABLE	APPLSYS.FND_CONCURRENT_PROGRAMS	db file sequential read	0.039	25	0.001544	0.013325	25	1
5:	150337	INDEX	APPLSYS.FND_REQUEST_SETS_TL_U1	db file sequential read	0.033	6	0.005509	0.015237	6	1
6:	150259	INDEX	APPLSYS.FND_REQUEST_SETS_U1	db file sequential read	0.026	3	0.008777	0.017600	3	1
7:		CLUSTER	SYS.C_OBJ#	db file sequential read	0.023	8	0.002851	0.012389	8	1
8:	150425	INDEX	APPLSYS.FND_RESPONSIBILITY_TL_U2	db file sequential read	0.022	2	0.010923	0.011161	2	1
9:	150230	INDEX	APPLSYS.FND_REQUEST_GROUPS_U1	db file sequential read	0.019	2	0.009576	0.012289	2	1
10:	150553	INDEX	APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U1	db file sequential read	0.018	2	0.009137	0.012719	2	1
11:		TABLE	SYS.HIST_HEAD$	db file sequential read	0.013	7	0.001846	0.012057	7	1
12:	300106	INDEX	APPS.FND_LOOKUP_VALUES_U1	db file sequential read	0.012	1	0.012281	0.012281	1	1
13:	150244	INDEX	APPLSYS.FND_REQUEST_GROUP_UNITS_U1	db file sequential read	0.011	2	0.005677	0.011178	2	1
14:	74726	TABLE	APPLSYS.FND_LOOKUP_VALUES	db file sequential read	0.010	1	0.009918	0.009918	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:	26	486595	75467	TABLE	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	0.038	1	0.038493
2:	32	486638	75467	TABLE	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	0.026	1	0.025930
3:	37	2600	150259	INDEX	APPLSYS.FND_REQUEST_SETS_U1	0.018	1	0.017600
4:	32	489822	74901	TABLE	APPLSYS.FND_REQUEST_SETS_TL	0.016	1	0.016030
5:	29	486842	75467	TABLE	APPLSYS.FND_CONCURRENT_PROGRAMS_TL	0.016	1	0.015902
6:	2	14780		INDEX	SYS.I_HH_OBJ#_INTCOL#	0.000	2	0.000170

(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 gaps found in trace(s) with corresponding approximate duration in seconds.

#	Gap Timestamp	Gap Time¹
1:	NOV-24 15:24:36.448	16.178
2:	NOV-24 15:25:07.661	29.693
3:	NOV-24 15:25:28.503	20.348
4:	NOV-24 15:26:20.676	50.916
5:	NOV-24 15:26:53.783	32.331
6:	NOV-24 15:27:08.343	14.219
7:	NOV-24 15:29:23.585	122.788
8:	NOV-24 15:30:11.889	47.172
9:	NOV-24 15:30:40.640	28.077
10:	NOV-24 15:31:24.771	43.097
11:	NOV-24 15:31:53.953	28.472
12:	NOV-24 15:32:04.586	5.812

(1) Blank if duration cannot be computed.

List of recursive calls related to gaps found in trace.

#	Gap Timestamp	Call Type	CPU	Elapsed	Call Timestamp	SQL Text	Hash Value
1:	NOV-24 15:24:36.448	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
2:	NOV-24 15:25:07.661	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
3:	NOV-24 15:25:28.503	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
4:	NOV-24 15:26:20.676	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
5:	NOV-24 15:26:53.783	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
6:	NOV-24 15:27:08.343	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
7:	NOV-24 15:29:23.585	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
8:	NOV-24 15:30:11.889	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
9:	NOV-24 15:30:40.640	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
10:	NOV-24 15:31:24.771	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
11:	NOV-24 15:31:53.953	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945
12:	NOV-24 15:32:04.586	Fetch	467.080	460.366	NOV-24 15:32:00.242	select distinct substr(fl.meaning, 1, 11) Type, fs.user_requ	3807717945

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:	2195	228	NOV-24 15:24:17.378	4	0	1	0

Non-default Initialization Params

[-]
List of non-default parameters in NE-OCADEV-1.

#	Parameter	Value¹
1:	O7_DICTIONARY_ACCESSIBILITY	TRUE
2:	_b_tree_bitmap_plans	FALSE
3:	_fast_full_scan_enabled	FALSE
4:	_index_join_enabled	FALSE
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	/DB/DIS/DDDEV/oracle/db/10.2.0/admin/DDEV_ne-ocadev-1/bdump
12:	compatible	10.2.0.3.0
13:	control_files	/DB/DIS/DDDEV/oracle/data/cntrl01.dbf
14:	control_files	/DB/DIS/DDDEV/oracle/data/cntrl02.dbf
15:	control_files	/DB/DIS/DDDEV/oracle/data/cntrl03.dbf
16:	core_dump_dest	/DB/DIS/DDDEV/oracle/db/10.2.0/admin/DDEV_ne-ocadev-1/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	1500
23:	db_name	DDEV
24:	dml_locks	10000
25:	ifile	/DB/DIS/DDDEV/oracle/db/10.2.0/dbs/DDEV_ne-ocadev-1_ifile.ora
26:	job_queue_processes	2
27:	log_buffer	10485760
28:	log_checkpoint_interval	100000
29:	log_checkpoint_timeout	1200
30:	log_checkpoints_to_alert	TRUE
31:	max_dump_file_size	20480
32:	nls_comp	binary
33:	nls_date_format	DD-MON-RR
34:	nls_language	american
35:	nls_length_semantics	CHAR
36:	nls_numeric_characters	.,
37:	nls_sort	binary
38:	nls_territory	america
39:	olap_page_pool_size	4194304
40:	open_cursors	600
41:	optimizer_mode	CHOOSE
42:	optimizer_secure_view_merging	FALSE
43:	parallel_max_servers	8
44:	parallel_min_servers	0
45:	pga_aggregate_target	1073741824
46:	plsql_code_type	INTERPRETED
47:	plsql_native_library_dir	/DB/DIS/DDDEV/oracle/db/10.2.0/plsql/nativelib
48:	plsql_native_library_subdir_count	149
49:	plsql_optimize_level	2
50:	processes	2100
51:	query_rewrite_enabled	true
52:	session_cached_cursors	500
53:	sessions	2315
54:	sga_target	1073741824
55:	shared_pool_reserved_size	41943040
56:	shared_pool_size	419430400
57:	timed_statistics	TRUE
58:	undo_management	AUTO
59:	undo_tablespace	APPS_UNDOTS1
60:	user_dump_dest	/DB/DIS/DDDEV/oracle/db/10.2.0/admin/DDEV_ne-ocadev-1/udump
61:	utl_file_dir	/AP/DIS/ADDEV/oracle/appl/te/11.5.0/bankardata
62:	utl_file_dir	/AP/DIS/ADDEV/oracle/appl/te/11.5.0/bankardata/archive
63:	utl_file_dir	/AP/DIS/ADDEV/oracle/appl/te/11.5.0/bankardata/error
64:	utl_file_dir	/AP/DIS/ADDEV/oracle/appl/te/11.5.0/bankardata/log
65:	utl_file_dir	/AP/DIS/ADDEV/oracle/appl/te/11.5.0/bankardata/new
66:	utl_file_dir	/AP/DIS/ADDEV/oracle/appl/te/11.5.0/ediin
67:	utl_file_dir	/AP/DIS/ADDEV/oracle/appl/te/11.5.0/sdd/gics
68:	utl_file_dir	/AP/DIS/ADDEV/oracle/appl/te/11.5.0/tiugl
69:	utl_file_dir	/AP/DIS/ADDEV/oracle/appl/te/11.5.0/webplan
70:	utl_file_dir	/AP/DIS/ADDEV/oracle/comn/temp
71:	utl_file_dir	/DB/DIS/DDDEV/db/tmp
72:	utl_file_dir	/DB/DIS/DDDEV/oracle/db/9.2.0/appsutil/outbound/DDEV_ne-ocadev-1
73:	utl_file_dir	/tmp
74:	utl_file_dir	/usr/tmp
75:	workarea_size_policy	AUTO

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

Trace Header

[-]

ddev_ora_15806_APPS.trc (442581 bytes)

/DB/DIS/DDDEV/oracle/db/10.2.0/admin/DDEV_ne-ocadev-1/udump/ddev_ora_15806_APPS.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /DB/DIS/DDDEV/oracle/db/10.2.0
System name: SunOS
Node name: ne-ocadev-1
Release: 5.9
Version: Generic_122300-26
Machine: sun4u
Instance name: DDEV
Redo thread mounted by this instance: 1
Oracle process number: 349
Unix process pid: 15806, image: oracleDDEV@ne-ocadev-1

*** SERVICE NAME:(SYS$USERS) 2008-11-24 15:24:17.378

Back to Top

Tool Execution Environment

[-]

Execution ID:	72850
Host Name:	ne-ocadev-1
Platform:	Solaris
Product Version:	Oracle Database 10g Enterprise Edition (64bi)
RDBMS Version:	10.2.0.3.0(10.2.X)
RDBMS Release:	10.2
User:	APPS(70)
Input Directory:	/DB/DIS/DDDEV/oracle/db/10.2.0/admin/DDEV_ne-ocadev-1/udump
Output Directory:	/DB/DIS/DDDEV/oracle/db/10.2.0/admin/DDEV_ne-ocadev-1/udump

Tool Configuration Parameters

[+]