[Home] [Help]
PACKAGE: APPS.FND_TRACE
Source
1 package FND_TRACE as
2 /* $Header: AFPMTRCS.pls 120.1 2005/07/02 03:06:11 appldev noship $ */
3
4 /* Trace Type Constant Definitions */
5
6 SQL_REGULAR NUMBER := 1 ;
7 SQL_BINDS NUMBER := 4 ;
8 SQL_WAITS NUMBER := 8 ;
9 SQL_BINDS_WAITS NUMBER := 12 ;
10 PLSQL_INSTR NUMBER := 10928 ;
11 PLSQL_PROF NUMBER := 10941 ;
12 CBO NUMBER := 10053 ;
13
14 -- Exposing related_runid, spid and prof_runid can be obtained
15 -- using the get_trace_id function.
16
17 RELATED_RUNID NUMBER;
18
19
20 procedure START_TRACE(TRACE_TYPE in NUMBER default SQL_WAITS );
21
22 procedure START_TRACE(TRACE_TYPE in NUMBER,
23 SESSION_ID in NUMBER,
24 SERIAL# in NUMBER);
25
26
27 procedure STOP_TRACE(TRACE_TYPE in NUMBER default SQL_BINDS_WAITS);
28
29 procedure STOP_TRACE(TRACE_TYPE in NUMBER,
30 SESSION_ID in NUMBER,
31 SERIAL# in NUMBER);
32
33
34 procedure SET_TRACE_IDENTIFIER(IDENTIFIER_STRING in VARCHAR2);
35
36 procedure SET_MAX_DUMP_FILE_SIZE(TRACEFILE_SIZE in NUMBER);
37
38
39 function GET_TRACE_IDENTIFIER RETURN VARCHAR2;
40
41 function GET_TRACE_FILENAME RETURN VARCHAR2;
42
43 function GET_TRACE_LEVEL(TRACE_TYPE in NUMBER) RETURN NUMBER;
44
45 function GET_TRACE_ID(TRACE_TYPE in NUMBER) RETURN NUMBER;
46
47 function IS_TRACE_ENABLED(TRACE_TYPE in NUMBER) RETURN BOOLEAN;
48
49 function SUBMIT_PROFILER_REPORT(PROF_RUNID in NUMBER
50 ,RELATED_RUNID IN NUMBER
51 ,PURGE_DATA IN VARCHAR2 DEFAULT 'Y'
52 )
53 RETURN NUMBER;
54
55
56
57 function SUBMIT_PROFILER_REPORT RETURN NUMBER;
58
59 end FND_TRACE;