ࡱ> 5@ <bjbj22$XX$4tttttttddd88tnߘ_l#%%%%%%$RdIt@ߘItt^tt##ɷ:,tt P1Oȳ=dk t0R C  Ltttt ~ t˜> ,5$YR˜˜˜IIDI QDB Q DBMS_SYSTEM A definitive guide Garry Robinson December 2001 first version for Oracle 7.3 Jens-Uwe Petersen March 2003 revised for Oracle 8.0 - 9.2 Jens-Uwe Petersen May 2004 revised for Oracle 10.1 ABSTRACT Presenting the missing section from the PL/SQL supplied packages manual. This is not an official Oracle document. I formatted it to look the same as the Oracle online documentation just for fun. Oracle Documentation PL/SQL Packages and Types Reference 10g Release 1 (10.1) Part Number B10802-01 DBMS_SYSTEM This package enables you to gather information about events set in the current session and manipulate others users sessions to set events and change the values of certain init.ora parameters. It provides some of the capability of DBMS_SESSION but with the ability to affect any session. Oracle version 8.0 introduced a procedure to reset the IO counters in dynamic performance views (KCFRMS) and a suite of procedures that allow privileged users to write messages to the session trace file and instance alert log. For Oracle version 10.1 a procedure to read in environment variables (GET_ENV) has been added. PRIVATE Note: I should add that this package has been left undocumented for good reason and since Oracle8, it has been wrapped and moved into prvtutil.plb for obscurity.  Requirements This package is owned by SYS and is not generally available. I recommend that you only use this when logged on as SYS or connected as SYSDBA. Summary of Subprograms Table DBMS_SYSTEM Subprograms PRIVATESubprogram Description  HYPERLINK \l "DIST_TXN_SYNC" DIST_TXN_SYNC Distributed transaction synchronisationHYPERLINK \l "GET_ENV"GET_ENV Get the value of environment variables HYPERLINK \l "KCFRMS" KCFRMS Reset counters in v$session_event and v$filestat HYPERLINK \l "KSDDDT" KSDDDT Prints the date stamp to the target file (alert log and/or trace file).  HYPERLINK \l "KSDFLS" KSDFLS Flushes any pending output to the target file.  HYPERLINK \l "KSDIND" KSDINDDoes an 'indent' before the next write (ksdwrt) by printing that many colons (:) before the next write.  HYPERLINK \l "KSDWRT" KSDWRT Prints the message to the target file (alert log and/or trace file). HYPERLINK \l "READ_EV" READ_EV Get the level for events set in the current session. HYPERLINK \l "SET_BOOL_PARAM_IN_SESSION"SET_BOOL_PARAM_IN_SESSION Sets boolean-type init.ora parameters in any session  HYPERLINK \l "SET_EV" SET_EV Set an event in any session HYPERLINK \l "SET_INT_PARAM_IN_SESSION"SET_INT_PARAM_IN_SESSION Sets integer-type init.ora parameters in any session HYPERLINK \l "SET_SQL_TRACE_IN_SESSION"SET_SQL_TRACE_IN_SESSION Turns tracing on or off in any session HYPERLINK \l "WAIT_FOR_EVENT"WAIT_FOR_EVENT Puts the current session into a wait state for any named wait event Privileges Before using this package, you must run the DBMSUTIL.SQL and PRVTUTIL.PLB scripts to create the DBMS_SYSTEM package. DIST_TXN_SYNC Procedure There is no public information available for this procedure, but it somehow sounds like distributed transaction synchronisation. According to Tom Kyte it is used in XA interfaces and is nothing you would ever need to call directly. Syntax DBMS_SYSTEM.DIST_TXN_SYNC (inst_num IN NUMBER); Parameters Table DIST_TXN_SYNC Procedure Parameters PRIVATEParameter Description Inst_num Database instance number  GET_ENV Procedure This procedure has been introduced with 10g. It returns the value of environment variables. The behaviour is different for Windows and Unix. In Unix every environment variable set in the current Oracle process can be retrieved. These environment variables are inherited from the listener if connected through SQL*Net or from the current shell if connected locally. In Windows only registry values under the current Oracle home (per default HKLM\SOFTWARE\ORACLE\ KEY_OraDb10g_home1) can be retrieved. No system or user variables can be read, and the use of the ENVS parameter in the listener.ora is not supported on Windows. Syntax DBMS_SYSTEM.GET_ENV ( var IN VARCHAR2, val OUT VARCHAR2); Parameters Table GET_ENV Procedure Parameters PRIVATEParameter Description VarName of the environment variable / registry key.ValValue of the environment variable. NULL if variable is not defined.Example Retrieve environment variable from Unix: SQL> var v_value char(70); SQL> exec dbms_system.get_env('ORACLE_SID', :v_value); SQL> print v_value; V_VALUE -------- db10 Retrieve value from Windows registry: SQL> exec dbms_system.get_env(' OLEDB\TraceFileName', :v_value); SQL> print v_value; V_VALUE ---------------- c:\OraOLEDB.trc KCFRMS Procedure This procedure resets the timers displayed by MAX_WAIT in V$SESSION_EVENT and MAXIORTM, MAXIOWTM in V$FILESTAT (X$KCFIO) views. Table Reseted Columns in V$SESSION_EVENT PRIVATEParameter Description MAX_WAIT The maximum time (in hundredths of a second) waited for this event by this session Table Reseted Columns in V$FILESTAT PRIVATEParameter Description MAXIOWTMThe maximum time (in milliseconds) spent doing a single write, if the TIMED_STATISTICS parameter is TRUE; 0 if FALSEMAXIORTMThe maximum time (in milliseconds) spent doing a single read, if the TIMED_STATISTICS parameter is TRUE; 0 if FALSE Syntax DBMS_SYSTEM.KCFRMS ; Example To check for the current timer values: SQL> select MAX_WAIT from V$SESSION_EVENT; SQL> select MAXIORTM, MAXIOWTM from V$FILESTAT; KSDDDT Procedure This procedure prints the timestamp to the trace file. It cant be used for the alert log. Syntax DBMS_SYSTEM.KSDDDT ; Example SQL> exec dbms_system.ksdddt ; Output in tracefile looks like: *** 2003-03-10 21:23:17.000 KSDFLS Procedure This procedure flushes any pending output to the target file (alert log and/or trace file). Syntax DBMS_SYSTEM.KSDFLS ; KSDIND Procedure This procedure does an 'indent' before the next write (ksdwrt) by printing that many colons (:) before the next write. Syntax DBMS_SYSTEM.KSDIND (lvl IN BINARY_INTEGER); Parameters Table KSDIND Procedure Parameters PRIVATEParameter Description Lvl The indend level from 0 to 30  Example Write in the same line 5 : and the text Test Alert Msg to the tracefile and the alertlog: SQL> exec dbms_system.ksdind (5); SQL> exec dbms_system.ksdwrt (3, Test Alert Msg); Output in tracefile/alertlog looks like: :::::Test Alert Msg KSDWRT Procedure This procedure prints the message to the target file (alert log and/or trace file). Syntax DBMS_SYSTEM.KSDWRT ( dest IN BINARY_INTEGER, tst IN VARCHAR2); Parameters Table KSDWRT Procedure Parameters PRIVATEParameter Description destDestination is indicated by the following values: 1 - Write to trace file. 2 - Write to alertlog. 3 - Write to both. tst Message (not tested for max length, but output with 2000 chars was successful) Example Write the text Test Alert Msg to the tracefile and the alertlog: SQL> exec dbms_system.ksdwrt (3, ); SQL> exec dbms_system.ksdwrt (3, --- Start ---); SQL> exec dbms_system.ksdddt; SQL> exec dbms_system.ksdwrt (3, Test Alert Msg); SQL> exec dbms_system.ksdwrt (3, --- End ---); SQL> exec dbms_system.ksdwrt (3, ); Output in tracefile looks like: *** 2003-03-10 21:23:17.000 --- Start --- *** 2003-03-10 21:23:17.000 Test Alert Msg --- Ende --- Output in alertlog looks like: Mon Mar 10 21:23:17 2003 --- Start --- Test Alert Msg --- Ende --- Note the following: Oracle automatically prints a timestamp before the very first output of a ksd-function in a session. The date format differs between the alertlog and the tracefile. READ_EV Procedure This procedure returns the level for any event set in the session. Error codes 10000 to 10999 are reserved for debug event codes that are not really errors. See file $ORACLE_HOME/rdbms/mesg/oraus.msg for details of events and possible level settings. Syntax DBMS_SYSTEM.READ_EV ( iev IN BINARY_INTEGER, oev OUT BINARY_INTEGER); Parameters Table READ_EV Procedure Parameters PRIVATEParameter Description iev The event number 10000 to 10999 oev Event level. Level will be 0 if the event is not set. Example To check whether the session is in SQL_TRACE mode: SQL> ALTER SYSTEM SET SQL_TRACE=TRUE; (implicitly sets event 10046 at level 1) SQL> exec dbms_system.read_ev(10046,:lev); SQL> print lev LEV ---------- 1 SET_EV Procedure This procedure allows you to set an event in any session for debugging purposes. Common events to enable debugging are: 10032 sorts 10033 large sorts 10046 sql_trace / SQL statements (at level 1, equivalent to SQL_TRACE=TRUE) 10053 cost-based optimizer tracing 10104 hash join debugging Syntax DBMS_SYSTEM.SET_EV ( si IN BINARY_INTEGER, se IN BINARY_INTEGER, ev IN BINARY_INTEGER, le IN BINARY_INTEGER, nm IN BINARY_INTEGER); Parameters Table SET_EV Procedure Parameters PRIVATEParameter Description si Session identifierse Session serial numberev The event number 10000 to 10999 le The level to set. See file $ORACLE_HOME/rdbms/mesg/oraus.msg for details of events and possible level settings.nm Name, usually just set it to a NULL string  Example Set event 10046 (SQL_TRACE) at level 12 to collect information about all wait events and bind variables. The trace information will get written to user_dump_dest. SQL> exec dbms_system.set_ev(8, 1158, 10046, 12, ); SET_SQL_TRACE_IN_SESSION Procedure This procedure is similar to DBMS_SESSION.SET_SQL_TRACE which turns tracing on or off. It is equivalent to the following SQL statement except that it can be used to set SQL_TRACE in another session: ALTER SESSION SET SQL_TRACE ... Behind the scenes, it actually just calls DBMS_SYSTEM.SET_EV to set event 10046 at level 1. Syntax DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION ( sid IN NUMBER, serial# IN NUMBER, sql_trace IN BOOLEAN); Parameters Table SET_SQL_TRACE_IN_SESSION Procedure Parameters PRIVATEParameter Description sid Session identifierserial# Session serial numbersql_trace TRUE turns tracing on, FALSE turns tracing off.  Example Turn SQL tracing on in session 448. The trace information will get written to user_dump_dest. SQL> exec dbms_system.set_sql_trace_in_session(448,2288,TRUE); Turn SQL tracing off in session 448 SQL> exec dbms_system.set_sql_trace_in_session(448,2288,FALSE); SET_INT_PARAM_IN_SESSION Procedure This procedure allows you to change init.ora parameters in the context of another users session. It is equivalent to the following SQL statement: ALTER SESSION SET parameter_name = value; Syntax DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION ( sid IN NUMBER, serial# IN NUMBER, parnam IN VARCHAR2, intval IN BINARY_INTEGER); Parameters Table SET_INT_PARAM_IN_SESSION Procedure Parameters PRIVATEParameter Description sid Session identifierserial# Session serial numberparnam Parameter nameintval New value Example SQL> exec dbms_system.SET_INT_PARAM_IN_SESSION (16, 161, 'sort_area_size', 1048576); SET_BOOL_PARAM_IN_SESSION Procedure Similar to SET_INT_PARAM_IN_SESSION, this procedure allows you to change init.ora parameters in the context of another users session. It is equivalent to the following SQL statement: ALTER SESSION SET parameter_name = value; Syntax DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION ( sid IN NUMBER, serial# IN NUMBER, parnam IN VARCHAR2, bval IN BOOLEAN); Parameters Table SET_BOOL_PARAM_IN_SESSION Procedure Parameters PRIVATEParameter Description sid Session identifierserial# Session serial numberparnam Parameter namebval New value Example SQL> exec dbms_system.SET_BOOL_PARAM_IN_SESSION(16, 161, 'sql_trace', TRUE); WAIT_FOR_EVENT Procedure This procedure causes the current session to go into a wait for the event specified. The event must be a recognised wait event from V$EVENT_NAME. The session will wait for the timeout period specified and populate the P1 column in V$SESSION_WAIT with the value of EXTENDED_ID . I cant think of any useful purpose for this procedure other than possibly training or as a substitute for DBMS_LOCK.SLEEP. Syntax DBMS_SYSTEM.WAIT_FOR_EVENT ( event IN VARCHAR2, extended_id IN BINARY_INTEGER, timeout IN BINARY_INTEGER); Parameters Table WAIT_FOR_EVENT Procedure Parameters PRIVATEParameter Description event Wait event name. extended_id P1 value. This value will be placed in the P1 column of V$SESSION_WAIT timeout Time to wait in seconds Example Wait for debugger command event for 10 seconds: SQL> exec dbms_system.wait_for_event('debugger command',55,10); Check V$SESSION_WAIT from another session: SQL> select sid, event, p1, seconds_in_wait, state 2 from v$session_wait 3 where sid=8; SECONDS IN SID EVENT P1 WAIT STATE ----- -------------------- ---------- ---------- -------- 8 debugger command 55 3 WAITING  HYPERLINK "http://www.oracleadvice.com"   Garry Robinson Jens-Uwe Petersen December 2001 OracleAdvice Ltd. May 2004 Trivadis GmbH   4BCR_nop |q^%hh0JB* OJQJ^Jph3h#J5OJQJhh#J5CJOJQJ h#JCJhjohjoh#J56hjohA5hjoh5hh\j56CJh\j56CJ h\j5CJ hjohjoh56CJh k56CJ h5CJ h#J5CJ h#J5h#JOJQJhh#J!     01234o$v:$v:$v:$v:$v:$v:$v:$v:$v:$v:$v:$v:$v:$v:$v:$v:$v:$Y$&$v:$v:$v:$v:$   }]@@gd k$a$  ~= z9!v%$<<op $v:$$$v:$v:$v:$v:$v:$v:$v:$v:$$v:$v:$v:$If  ~= z9!v% @@gd1L }@@gd,   }]@@gd\j ]gd k  " .  C N ` 0 1 4 H T ] ` v õsgXgLgLgXBjh#JUhdJB*mH phsH h kh\jB*mH phsH h\jB*mH phsH hF B*mH phsH h kh kB*mH phsH h kB*mH phsH h k h kh#Jh#JB* OJQJphh#JhB* OJQJ^Jph3h#JB* OJQJph%h0J6B* OJQJ]^Jph3h0JB* OJQJ^Jph3hH5B* OJQJph ! " / N 1 C D E R t$v:$Y$v:$v:$v:@v:@v:$v:$$v:$v:$1kd$$If@@a$If$dd[$\$a$gd k,kd$$If$$a A B E Q  !",.9<=\]^klmnӻӻӱ圗|smie^i hH$hH$hQ)h[u h[u0JhgJeh[u0Jjh1MvU hgJe0JjhgJe0JU h#J5h#J0JOJQJjZh#JUh#J0JOJQJh#JB* OJQJphh kh#JOJQJh#Jjh#JUmHnHujh#JUjAh#JU h#J$ .;<mn$v:$v:v: 1v:v: $Ifgd[u  v%$Ifgd[uJkd\$$If-0f$f&$4 -a- $$Ifa$t 1v:v:StF 1  v%$Ifgd[uJkdL$$If-0f$f&$4 -a- $Ifgd>@  v%$Ifgd>@JkdZ$$If-0f$f&$4 -a-789:RSTZ[\Կ~sjh1MvUjh1MvU hgJeh[u hgJehgJehgJeh[u h[u0JhgJeh[u0Jjh1MvU hgJe0JjhgJe0JU hgJeh>@h\jh>@ h>@0J h>@0Jjh U h 0Jjh>@0JU)89\]v:v:t 1v:v:St 1v:Jkd,$$If-0f$f&$4 -a-  v%$Ifgd[uJkd<$$If-0f$f&$4 -a- $Ifgd[u v:t 1v:St 1v:v:Jkd $$If-0f$f&$4 -a-  v%$Ifgd[uJkd$$If-0f$f&$4 -a- $Ifgd[ug PQz{|:׸ۈ׸wj h#JU h[u0Jjo h[uUjh[u0JUh#J h#J0Jj} h#JU h#J0Jjh#J0JUj h1MvU hgJe0Jhnth[u h[u0JhgJeh[u0JjhgJe0JUjh1MvU*OPt 1v:v:YtL 1Cv: $Ifgd[u  v%$Ifgd[uJkd $$If-0f$f&$4 -a-$If  v%$IfJkd $$If-0f$f&$4 -a-Vv:t 1v:v:PtC 1  v%$Ifgd[uJkd $$If-0f$f&$4 -a-$If  v%$IfJkd $$If-0f$f&$4 -a- $Ifgd[u:;<TUV,-.tuNR]cʿйʵʪйʵʵʵʵ}yuquyj hH$hH$h1hahH$hH$B* OJQJphh#JOJQJh h#JCJh#JB* CJOJQJphh,jh#JUh#J h#J0Jjh#JU h#J0Jjh#J0JUh[u h[u0J h[u0Jjh[u0JUju h[uU)VW./v:v:t 1v:v:P 1v:Jkd$$If-0f$f&$4 -a-$If  v%$IfJkd$$If-0f$f&$4 -a- $Ifgd[u /stu45v:t$v:$$ d$v:$v:$$v:$v:$v:$z$1$v: v%gdH$gdH$gd1gdH$gdH$  ~= z9!v%gd,Jkd$$If-0f$f&$4 -a-$If5?@ijkrst}!",->ASTU689:@APRSѷhy} h|rRh|rRh|rRhb hah>@hHhth>@h>@B* OJQJph hH$5hH$0JOJQJjhH$U hH$jhH$UhH$0JOJQJhH$B* OJQJphha hahahH$/5@j$$v:9v:19v:9v: $Ifgd)  v%$Ifgd)JkdG$$If-0$$4 -a- $$Ifa$gd)gdH$gdH$#TU569:AWnt$v:$v:$$v:$v:$v:$v:$v:$v:$v:$v:$$1$1$1$v: v%gd>@gd>@gd>@gd>@gdH$Jkd$$If-0$$4 -a- $$v:9v:19v:Gu:Ekdt$$If-0$4 -a- $Ifgd>@  v%$Ifgd>@Ekd$$If-0$4 -a- $$Ifa$gd>@gd>@gd>@ ,FIUW^_c,/4NĿĿ軷軷諷upu h mhhy}h mOJQJh mOJQJhy}hy}OJQJh|rROJQJhHOJQJh|rRhvBhHB* OJQJphhHhb h>@5h>@0JOJQJjIh>@U h>@jh>@Uh>@h>@0JOJQJhy}0JOJQJ+VW_19v:u:$$v:$v:$1$1$1$1$1$1x$1  ~= z9!v%gd mgd mgd mgdy}gdHgdHEkd$$If-0$4 -a- $Ifgd>@  v%$Ifgd>@ ./pABl$1$v:$v:$v:$1$1$1$1$1$1$v:$$v:$v:$v:$v:9v: $$Ifa$gdAgdAgdH$gdH$gd>@gd mgd mgdH  ~= z9!v%gd mNOfp{  8ABklmtuvķ{pfafaZ h;whA hA5hA0JOJQJjvhAU hAjhAUhAhA0JOJQJh)Z hZhH$hH$hH$B* OJQJphhHhvBh>@OJQJ^JhvBhvBOJQJ^J hvBh h mhh mOJQJhy}h mOJQJhvBhvBOJQJ hvBhvB#19v:9v:StN$v:I$v:gdAgdAJkd$$If-0$$4 -a- $IfgdA  v%$IfgdAJkd $$If-0$$4 -a-&(36?b14:QXY*CMOUlst} h>bhhnth49h,hVB* OJQJphheRhH$h hH$hhH$OJQJhhH$hH$B* OJQJphhAmH sH h;whAmH sH  hA5hA0JOJQJj"hAU hAjhAUhA1(56?~9v:19v:9v:Gt1JkdM$$If-0$$4 -a- $IfgdA  v%$IfgdAJkd$$If-0$$4 -a- $$Ifa$gdA234;PQY9v:9v:t$v:$$1$v:$$v:$v:$1$1}gd,  ~= z9!v%gdH$gdH$ v%gdH$gdH$gdAJkd$$If-0$$4 -a- $IfgdA NOVkltCDK`a$$v:$v:$v:$$1$v:$$1$$v:$v:$1$v:$v:$v:$$v:$v:$v:$$1$v:gdZ  ~= z9!v%gd>b v%gdH$gdH$gd49gdH$gdH$ADJ`brt   " , - 4 6 9 O P Q X Y Z c e p s t | ϿϿϻϷϷϭϏupuplϻh hH$5hH$0JOJQJjOhH$U hH$jhH$UhH$0JOJQJhWf0JOJQJh>b0JOJQJhWfhnth49hH$B* OJQJphhH$ h>bhH$h>bhntmHsHh>bOJQJhh>bh>bCJaJh hH$h)abst! " - P e r s w $v:$$v:$v:$v:$$1$v:$$v:9v:z1  v%$Ifgd)Jkd$$If-0$$4 -a- $$Ifa$gd)gdH$ v%gdH$gdH$gdntgdH$gdH$w x !!#!W!X!!!!9v:9v:t$v:$$v:$v:$1$1$1x$v:s$1sgdZ  ~= z9!v%gd>bgdH$  ~= z9!v%gdZgdH$gdH$Jkdz$$If-0$$4 -a- $Ifgd) !!W!X!k!t!!!!!!!!!"""Q"["\"c"e"h"~""""""úֺ{vk{jhH$U hH$jhH$UhH$0JOJQJhWf0JOJQJh>b0JOJQJhWfh)h, hZhZhh>bOJQJh hH$h hZhhH$OJQJhhZOJQJhhOJQJhhH$B* OJQJphhH$hnth>b(!!!!!""8"P"Q"\""""""$$v:$v:$v:$$1$1$1$v:$$v:9v:1  v%$Ifgd)Ekd $$If-0$4 -a- $$Ifa$gd)gdH$ v%gdH$gdH$gdH$gdH$"""""""""## #!#%#-#:#[#m#n#s#v#}#~########$ $ $$$$6$9$Y$Z$]$a$$$$$$$$$鿻食飚h MB* OJQJph h Mh hhh MhhH$B* OJQJphh1Lh&h)hnthnthH$mH sH hnthntmH sH h)mH sH hntmH sH hH$h)Z hH$5hH$0JOJQJ1""# #$#%#t#u#v#9v:9v:19v:9v:TtO$v:gdH$Ekd!$$If-0$4 -a-  v%$Ifgd)Ekd&!$$If-0$4 -a- $Ifgdnt $Ifgd)v#~####$;$s$$$$$$$ % %%5%H%U%V%X%w%$$v:$v:$1$1$1$1$1$1$v:$v:$v:$v:$1$v:$1$1$1$1$1$1$v:gd Mgd Mgd,  ~= z9!v%gd M  ~= z9!v%gdgdH$gdgdH$$$$$ % % % %%%%5%9%I%K%Q%S%U%V%W%X%w%x%%%%%%%%%%%%%%%U&V&~&&ԶqhW2}hVOJQJmH sH hW2}OJQJmH sH hW2}hW2}OJQJmH sH hW2}hW2}OJQJhW2}mH sH h MmH sH h Mh MmH sH h Mh MB* OJQJphh M h Mh Mh MB* OJQJphh MOJQJhh MhW2}B* OJQJph(w%x%%%%%%%%%%?&&&&''''''''(+(8($1$1$1$1$1$1$1$1$1$v:$v:$$v:$v:$v:$$1$1$1$v:$$v:9v: $$Ifa$ v% & FgdW2}gdW2}gd M&&&'''''''''((((( ()(+(6(9(:(a(b(((((((+),))))))********+++++Ĺɯᝐ h'h' h#J6hV h#Jhh#JOJQJh#JOJQJhh)Z h#J5h#J0JOJQJj("h#JU h#Jjh#JUh#J0JOJQJh'h#Jh#JB* OJQJphhW2}h,OJQJmH sH 28(9(=(>(`(a(e(f((19v:9v:ct19v:9v:EkdS$$$If-0$4 -a-$If  v%$IfEkd#$$If-0$4 -a-((((((+),)W)f)g)r)}))))))*t$v:$$v:$v:$ d$v:$1$1$1$1$1$1$v:$$v:$v:  ~= z9!v%Ekd$$$If-0$4 -a-*"*4********+,+G+c+d+o++++$v:$v:$v:$v:$v:$v:$$1$1$1$1$1$1$v:$$v:9v: $$Ifa$ v%^+3+6+7+N+Q+R+d+n+o++++++++++++++++,,,,,,,,S-c-d----//C/G/\/`/u/y//////////ѷ̌j*h#JU h#J0Jh#JOJQJ h#J6hAh)Z h#J5h#J0JOJQJjU%h#JU h#Jjh#JUh#J0JOJQJh#JB* OJQJphh' h'h'h#J7+++++++++19v:9v:ct19v:9v:Ekd'$$If-0$4 -a-$If  v%$IfEkd&$$If-0$4 -a-++++,,,,,t19v:9v:ct19v:9v:Ekd($$If-0$4 -a-$If  v%$IfEkd($$If-0$4 -a-,,,,,,,,c-d--`19v:9v:cta$v:_$a$v:a$1a$1Ekd)$$If-0$4 -a-$If  v%$IfEkd)$$If-0$4 -a- -----....///6/O/h///////$v:$$v:$v:$v:$1$v:$v:$v:$$1$1$1$1$v:$$v:v: $$Ifa$ v%//////00+0/0B0G0^0e00001,1k1p11:2H2S2Y22222222222203132393:3;3D3F3Q3T3U3m3n333333333 4#4F4鲭ʚhT vOJQJj[-h#JU h#Jjh#JUh#J0JOJQJh'h#JOJQJ h#J6h#JB* OJQJph h#J0Jh#Jh)Z h#J5h#J0JOJQJ55566'6(6,6-6@6$v:$$v:v:+1v:v:$If  v%$IfEkd2$$If-0$ 4 -a- $$Ifa$ @6A6I6J6`6a6h6i6x6t+1v:v:ct+1v:v:Ekd3$$If-0$ 4 -a-$If  v%$IfEkd3$$If-0$ 4 -a-x6y6~666666666t+1v:v:cta$v:_$Z$1a$v:a$v:gdT vEkd4$$If-0$ 4 -a-$If  v%$IfEkd4$$If-0$ 4 -a- 666688888888!9"9-9X9m9z9{9$$v:$v:$v:$v:$v:$$1$1$1$1$v:$$v:v:Ekd6$$If-0$w4 -a- $$Ifa$ v%{9999999999991v:v:t1v:v:v:c`1v:Ekd7$$If-0$w4 -a-Ekd47$$If-0$w4 -a-$If  v%$If 9 ::::I:J:::::::;;G;x;;;v:t$v:$$v:$v:$1$v:$v:$v:$v:$1$1$1$1$1$1$1  ~= z9!v%Ekd68$$If-0$w4 -a-$If9::J:::;G;;"<$<%<N<O<P<Q<R<T<U<V<W<<<<<ʵԣԜ}yh_ h|rRCJh|rR h|rRCJj=hg}h|rR6CJU h|rR6CJ"jb9hh|rRB*CJUph(j8hh|rRB*CJUphh|rRB*CJphjh|rRB*CJUph h#Jhh#JOJQJh#JB* OJQJphh#J;"<#<$<V<W<y<<<<<$1$v:$v:$i$^$v: r $+$dN]+gd1L r $&dPgdg}  ~= z9!v% ":p1L. A!"#$%?$$If!vh5$#v$:V 5$4D~@Q t  @E$$If!vh5@#v@:V ,5@4D$->ٳ @     $$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-}DyK DIST_TXN_SYNC$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-qDyK GET_ENV$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-oDyK KCFRMS$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-oDyK KSDDDT$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-oDyK KSDFLS$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-oDyK KSDIND$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-oDyK KSDWRT$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-qDyK READ_EV$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-DyK SET_BOOL_PARAM_IN_SESSION$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-oDyK SET_EV$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-DyK SET_INT_PARAM_IN_SESSION$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-DyK SET_SQL_TRACE_IN_SESSION$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-DyK WAIT_FOR_EVENT$$If-!vh5f5&#vf#v&:V -$,5f5&/ 44 -a-DV$-|! !!$$If-!vh55#v#v:V -$,55/ 44 -a-$$If-!vh55#v#v:V -$,55/ 44 -a-DV$-|! !!$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-DV$-|! !!$$If-!vh55#v#v:V -$,55/ 44 -a-$$If-!vh55#v#v:V -$,55/ 44 -a-DV$-|! !!$$If-!vh55#v#v:V -$,55/ 44 -a-$$If-!vh55#v#v:V -$,55/ 44 -a-$$If-!vh55#v#v:V -$,55/ 44 -a-DV$-|! !!$$If-!vh55#v#v:V -$,55/ 44 -a-$$If-!vh55#v#v:V -$,55/ 44 -a-DV$-|! !!$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-DV$-|! !!$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-DV$-|! !!$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-$$If-!vh55#v#v:V -,55/ 44 -a-RD$-?g  u $$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-RD$-?g  u $$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-RD$-?g  u $$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-$$If-!vh55 #v#v :V -,55 / 44 -a-DV$-|! !!$$If-!vh55w#v#vw:V -,55w/ 44 -a-$$If-!vh55w#v#vw:V -,55w/ 44 -a-$$If-!vh55w#v#vw:V -,55w/ 44 -a-$$If-!vh55w#v#vw:V -,55w/ 44 -a-DyK yK :http://www.oracleadvice.com/QDdP  C ,Asmalllogob#ozU19n#ozU1PNG  IHDR^喙KPLTEfffff?????fffOOOOO333ff33,#tRNSf)bKGDHgIFg>U cmPPJCmp0712HsIDAT8O͖ X*ǟ:KMꞞYr0A3D_/;:&MnWUy/QaQlKg|ќ ozswξ*|ƻr]<+aǀqg3 ='㇃JaF78![1GIENDB`Dd d  C 2Atrivadislogo"`b:gZ 肑+s}=ngZ 肑+s}PNG  IHDR#π=0PLTEQORSSrqr,-tt[Y[ibKGDH cmPPJCmp0712OmcIDATHǵkG@VqqDXⴁSRث"jsɊvc[WiBE.\8E$ Qs9-|p:9 }׌2Ԅv5=SoyEΡH~N8W.t~jNGz]v"!ſ5 ?+8E:;T5;@ǫ<"/" P ʡ1y>}}^DG7QOȠg] kyI.?Gf^EQO \ qu^jwROv#Ux Ho9J \oPj䈧A_n46UrH$MTpY=з|Aяbb_HyMԹ~AoUyQ;td+_YPpn(|۬$ .mF4娞uvM|L4|֛)D|"b1z/1\_gUOj *_퍀U舜A0rMrۘZ* p\~㚼 <:fb7J((#ښS$vN5~N5OՇ1ݍ I)MXw$ѳk'/ hELn~ؚѫc7Rɩs쒤о_^mh-fY0}bl$492$Fqֲ^"PAd9W>`f2l'~NqW{# ƕo>sI8BZlc Ѷ<*_ؖT#uDO|)*W עн߀L#}JC> &*'b2"3!A OيsKtYXѵ1q6gCC0SCqV{LSArUIc׀n%[(ڐc6 v| z]8/z9N[nO55I/;;|ōZqLEw{Qi^ZpzE۸oOeƻIENDB`<@< Standard_HmH sH tH D@D berschrift 1$@&CJ0aJ0P@P berschrift 2$@&56CJ\]aJB@B berschrift 3$@&6]\@\ berschrift 4$$$d@&a$CJ OJQJ^JaJ JA@J Absatz-Standardschriftart\i@\ Normale Tabelle :V 44 la 0k@0 Keine Liste DOD H1$dd@&5CJ0KH$\aJ0h@O@ H3$dd@&5CJ\aJh0O0 CODECJOJQJaJ@O@ H2$dd@&5CJ$\aJ$h8O8 H5$dd@& 5\h6X@A6 Hervorhebung6]0U@Q0 Hyperlink>*B*jObj Preformatted( # ~= z9!v%OJQJ^Jh&W@q& Fett5\@O@ H4$dd@&5CJ\aJh:@: Kopfzeile  9r 8 @8 Fuzeile  9r BV@B BesuchterHyperlink>*B* e@ aHTML Vorformatiert7 2( Px 4 #\'*.25@9OJQJ^JmH sH >O> W2}bpdd[$\$CJaJmH sH 4 !"&!"&!"&!"&!"&!"&!"&!"&! "&! "&! "&! "& W!%o)",.4)    01234op !"/N1CDER.;<mn89\]  O P   V W . / s t u    4 5 @ j  #TU569:AWn VW_./pABl(56?~234;PQYNOVkltCDK`abst!"-Perswx#WX8PQ\ $%tuv~;s  5HUVXwx? + 8 9 = > ` a e f +!,!W!f!g!r!}!!!!!!"""4""""""""#,#G#c#d#o###############$$$$$$$$$$$$c%d%%%%%%&&&&'''6'O'h'''''''''''(( (( (*(+(\(](^(f((()))+),)m)n)p)))'*(*R*S*Z********1+F+S+T+X+Y+l+m+u+v++++++++++++++ ,!,#,G,H,--+-,-3-[-t------..'.(.,.-.@.A.I.J.`.a.h.i.x.y.~............00000000!1"1-1X1m1z1{111111111111 2222I2J222222233G3x333"4#4$4V4W4y4444000000000000000000800000(004(0(000000000 00 000p0 0 00000000 0 08000(00X00 0 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 0 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0H000080000H000H0X00 0 0 0 00 0 008000000000H00000H0X00 0 0 0 0 0 0 0 0 H00000000000000000000080000X00 0 0 0 00 0 0X00 0 0 0 00 0 0 00 0 0H000H00000080000H000H00000000080000H000080000H000H0X00 0 0 0 00 0 0H00000000080000H00000H0X00 0 0 0 00 0 0 00 0 0H00000000000000000000000000000000 0 080000H00000H0X00 0 0 0 00 0 0 00 0 0H00000000000008000000000H00000000H0X00 0 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0H000000800000000H000000H0X00 0 0 0 00 0 0 00 0 0 00 0 0H000000000008000000H0000000H0X00 0 0 0 00 0 0 00 0 0 00 0 0 00 0 0H000008000000H0000000H0X00 0 0 0 00 0 0 00 0 0 00 0 0 00 0 0H000008000000H000000H0X00 0 0 0 00 0 0 000 0 0 00 0 0H0000000000000000000@000p@0M900 01234 !"/CDER.;<mn89\]  O P   V W . / s t u    4 5 @ j  :AWn VW_./ABl(56?234;PQYNOVkltCDK`st!"-Perswx#WX8PQ\ $%tuv~;s  + 8 9 = > ` a e f +!,!W!f!g!r!}!!!!!!"""4""""""""#,#G#c#d#o###############$$$$$$$$$$$$c%d%%%%%%&&&&'''6'O'h'''''''''''(( (( (*(+(\(](^(f((()))+),)m)n)p)))'*(*R*S*Z********1+F+S+T+X+Y+l+m+u+v+++++++++++++ ,!,#,G,H,--+-,-3-[-t------..'.(.,.-.@.A.I.J.`.a.h.i.x.y.~............00000000!1"1-1X1m1z1{111111111111 2222I2J222222233G3x333"4#4$44400000000000000000 0200080808*@08*@08@04804804804804804808080808080 0 00@0@0@0 @0 0:000*0@0fZ0f0~ 0~ 0~ 0~ 0~0~ 0~ @0~ @0~@0~ @0~ 0~ 0~0~ 0~ 0~ 0~0~ 0~ 0~ 0~0~ 0~ 0~ 0~ 0~ 0~ 0~0~ 0~ 0~ 0~ 0~ 0~ 0~ 0~0~ 0~ 0~ 0~0~ 0~ 0~ 0~0~ 0~ 0~ 0~ 0~ 0~ 0~ 0~ 0~ 0~ @0(B0f0 0 0 20f0= 0= 0= J0= 0 0 J0= Z0 0  0  0  0  0 0  0  0 0 2@0f@0= J@0= @0(@0(@0(@0(J@0(Z@0W(@0b( @0b( @0b @0b @0b @0b @0b @0b @0b J@0Q'@0|*@0|*@0|*@0@0@0@0@0|*@0|*@0|*@0|*@0@0@0 20f0 0 0 Z@0 @0  @0  @0  @0  @0 @0  @0  @0 Z@0 @0  @0  @0  @0  @0  @0  @0  @0  @0  @0 J0 0& 0& J0 0C 0C 0C 0C @0(2@0f0 0 0 J0 0 0 J0 0@0000020f000J00020f0=0=0=J0=0K0KJ0=Z00 0 0 0 00 0 0J0=00@0@00@0(20f00J00000J0Z0L0W 0W 0W 0W Oy000W 0W 0W 0W0W 0W 0WJ00@0@0@0@0@0@0Oy00Oy00Oy00@0(:0f0(0(0(J0(0(0(0(0(J0(Z0W(0b( 0b( 0b 0b 0b0b 0b 0b 0b0b 0b 0bJ0000000000000:0f00000000J00/0/0/0/0/0/0/J0Z00 0 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0D 0@J0@0(@0(@0(@0(@0(@:0f@0 @0 @0 @0 @0 @0 @0 @J0 @0x@0x0x0x0xJ0 Z00 0 0D 0 00 0D 0 00 0 0 0 0 0 0J0 0 0 0 0 0 0 0 0 0 0 :0f0!0!0!0!0!J0!0"0"0"0"0"0" J0! Z0a# 0l# 0l# 0l# 0l# 0l# 0l# 0l# 0l# 0l# 0l# 0l# 0l# 0l# 0l# 0l# 0l#h 0l#h0l#h 0l# 0l#@J0!@0)$@0)$@0)$@:0f@0$@0$@0$@0$@0$@J0$@0%@0%@0%0%0%0%hJ0$hZ0-&h08&h 08&h 08& 08&h 08&h08&h 08& 08&h 08&h08&h 08& 08&h 08&h08&h 08& 08&h 08&h08&h 08& 08&@J0$@0&@0&@0&@0&@:0f@0Q'@0Q'@0Q'@0Q'@0Q'@J0Q'@0(@0(0(0(0(hJ0Q'hZ@0)h0)h 0)h 0) 0)@ 0)@0)@ 0) 0)@ 0)@0)@0)@ 0) 0)@ 0)@0)@ 0) 0)J0Q'0|*0|*0|*0|*0|*0|*0|*0|*0|*0|*0|*0|*0|*0|*0|*0|* 0LR, Oy008 0033 :N "$&+/F49<#%(+.158:>ACFHLQX_o V/5aw !"v#w%8((*++,-/01S3335@6x66{99;< "$&')*,-/0234679;<=?@BDEGIJKMNOPRSTUVWYZ[\]^`<!<]k9SZ  P {  ; T  , 4XXXXXXXXXtXXtXtXt+-Xl,2$D~ك ` a e f !+!,!f!n!}!!!!!!"":"""""""""""######,#/#6#7#G#J#Q############$$$$$$$$$$$$$$c%n%%%%%S&T&&&&&''''6'9'O'R'h'k''''''''''''(( (( (*(+(/(0(G(H(\(^(e(f((((())+),)k)p)))):*H*K*R*S*Y*Z*************0+;+D+F+Q+T+X+Y+l+m+u+v+++++++++++++++ ,#,F,H,,,--!-$-+-,-2-3-[-^-t-w---------....%.(.,.-.@.A.I.J.`.a.h.i.x.y.~..........0000000000!1"1,1-1W1b1k1m1x1{11111111111 2222I2J2S2T2222222333?3G3u3x3z333"4$4W444pN01A^lT[   3 "#SU468:@AVZmq UW^_-/op;OYVjtK_ 7;O~,!V!"""""""##+#/#F#J#b#d%%&&9'N'R'g'k''(),)l)********^-s-w------../000000 1-1W1J22222333$4444ER9] / j :ZWl?4;bt"-x\ $5UVX f !!o#$$$h'''*(**1+++#,..0"1b11113#4$4W44444$44robinsgrobinsgrobinsgrobinsgrobinsgTrivadisGarry RobinsonJens-Uwe Petersen{%5d|i=KX޾8^`OJQJo(hH8^`OJQJ^Jo(hHo8pp^p`OJQJo(hH8@ @ ^@ `OJQJo(hH8^`OJQJ^Jo(hHo8^`OJQJo(hH8^`OJQJo(hH8^`OJQJ^Jo(hHo8PP^P`OJQJo(hH8^`OJQJo(hH8^`OJQJ^Jo(hHo8pp^p`OJQJo(hH8@ @ ^@ `OJQJo(hH8^`OJQJ^Jo(hHo8^`OJQJo(hH8^`OJQJo(hH8^`OJQJ^Jo(hHo8PP^P`OJQJo(hH{%5=Kw        w         Kk,BKk,Q0bcJ{ylc cJ{Q'P~cJ{?> /61LVB F _@nt@-1-5vBH MeR|rR>bvcgJeEiT v1MvW2}g} k'uBA,WfH$&dJjo!bZ[uz#JK49))ZaA Q)T mtZy}F>@\j2 !CD.;<m89\ O P   V . s t j   VWl(56?23Persw $tu + 8 9 = ` a e d#o############$$$$$$$$'h''''''''''((( (*(\(](***1+F+S+T+X+l+m+u+++++++++3-t------..'.(.,.@.A.I.`.a.h.x.y.~...X1m1z1{11111111 224@ɝ4`@UnknownGz Times New Roman5Symbol3& z Arial;& z Helvetica?5 z Courier New;Wingdings"h:zsMf1d\f$- `$- `#~4d 4 4 3QH(?' DBMS_SYSTEM"Garry Robinson / Jens-Uwe PetersenJens-Uwe Petersen  Oh+'0 $ @ L Xdlt| DBMS_SYSTEMBMS#Garry Robinson / Jens-Uwe Petersenrarr Normal.dotsJens-Uwe Petersenen19sMicrosoft Word 10.0@?"@L+7@ų= $-՜.+,D՜.+,X hp  "OracleAdvice Ltd. / Trivadis GmbHc` 4A  DBMS_SYSTEM Titel 8@ _PID_HLINKSApTiu$WAIT_FOR_EVENT'3!SET_SQL_TRACE_IN_SESSION:=SET_INT_PARAM_IN_SESSIONbLSET_EV SET_BOOL_PARAM_IN_SESSIONLdREAD_EV}pKSDWRTa~KSDINDcf KSDFLSkc KSDDDT`bKCFRMSvTGET_ENVDIST_TXN_SYNCBShttp://www.oracleadvice.com/  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FЀaȳ=Data bC1TableWordDocument$SummaryInformation(DocumentSummaryInformation8CompObjj  FMicrosoft Word-Dokument MSWordDocWord.Document.89q