.NET/Java PDF, Tiff, Barcode SDK Library

Listing 24-6 shows the components of the DBMS_SYSTEM package (log in as the user SYS). Listing 24-6. The DBMS_SYSTEM Package SQL> DESC DBMS_SYSTEM Argument Name Type In/Out Default ----------------------------- --------------- ---------------PROCEDURE READ_EV_/* Get the level of events in the current session*/ IEV BINARY_INTEGER IN OEV BINARY_INTEGER OUT PROCEDURE SET_BOOL_PARAM _IN_SESSION SID NUMBER IN SERIAL# NUMBER IN PARNAM VARCHAR2 IN BVAL BOOLEAN IN PROCEDURE SET_EV /*Set an event in a session*/ SI BINARY_INTEGER IN SE BINARY_INTEGER IN EV BINARY_INTEGER IN LE BINARY_INTEGER IN NM VARCHAR2 IN PROCEDURE SET_INT_PARAM _IN_SESSION /*Set integer_type init parameters in a session*/ SID NUMBER IN SERIAL# NUMBER IN PARNAM VARCHAR2 IN INTVAL BINARY_INTEGER IN PROCEDURE SET_SQL_TRACE_IN _SESSION /* Trace any user session */ SID NUMBER IN SERIAL# NUMBER IN SQL_TRACE BOOLEAN IN PROCEDURE WAIT_FOR_EVENT /* Puts the current session in a wait mode for a wait event */ EVENT EXTENDED_ID TIMEOUT SQL>

how to make barcodes in excel 2010, barcode font in excel 2003, barcode for excel 2010 free, 2d barcode excel 2013, active barcode excel 2007 download, excel barcode add in, excel 2010 barcode control, barcode add in excel free, barcode excel 2010 microsoft, barcode generator excel 2007 free,

The SET_SQL_TRACE_IN_SESSION procedure is ideal for turning tracing on and off in sessions other than your own. The following example shows how to use the SET_SQL_TRACE_IN_SESSION procedure. The first statement uses the TRUE flag to turn tracing on. The second statement shows how to turn tracing off once you no longer need it. Oracle traces any SQL statements that are run by the user while the tracing is on, and you can get the trace file from the user_dump_dest directory, as is the case when you use the SQL Trace utility. SQL> EXECUTE SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(9,271,true); PL/SQL procedure successfully completed. SQL> EXECUTE SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(9,271,false); PL/SQL procedure successfully completed. SQL>

if [ $fields -lt 3 ] then proc_age_hr=0 proc_age_day=0 else proc_age_hr=`echo $proc_age | awk -F: '{print $(NF-2)}'` fields=`echo $proc_age_hr | awk -F- '{print NF}'` if [ $fields -ne 1 ] then proc_age_day=`echo $proc_age_hr | awk -F- '{print $1}'` proc_age_hr=`echo $proc_age_hr | awk -F- '{print $2}'` else proc_age_day=0 fi fi

The SET_INT_PARAM_IN_SESSION procedure is another useful procedure for managing active user sessions from your session. It lets you alter the initialization parameters (integer-valued parameters only) for a certain session. Its effects are similar to the use of the following statement: SQL> ALTER SESSION SET parameter_name = xxx; For example, you can set the sort area size in a user s session using the SET_INT_PARAM_IN_ SESSION procedure, as shown here: SQL> EXECUTE SYS.DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION (999, 8888, 'sort_area_size', 5000000);

When you want to set parameters such as tracing on and off in another user s session, you can use the SET_BOOL_PARAM_IN_SESSION procedure, as shown in the following example. Unlike the SET_SQL_TRACE_IN_SESSION procedure, this procedure enables you to set other Boolean (TRUE/FALSE) parameters as well. SQL> EXE DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION(9,271,'sql_trace',true); PL/SQL procedure successfully completed. SQL> EXEC DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION(9,271,'sql_trace',false); PL/SQL procedure successfully completed. SQL>

It s common for Oracle technical support or other Oracle experts to ask you to set an event in a session so you can gather information to debug or tune code. You use the ALTER SESSION SET EVENTS statement to set an event. Note that the event 10046 denotes sql_trace. The level could be anything from 1 to 12, with each level producing more detailed output than the one below it. Level 12 is the most detailed level at which you can collect trace statistics, and it includes all wait events and the bind variables. As usual, the trace information is output to the udump directory. Here s an example: SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 8'; Session altered. SQL>

File Type: EXECUTABLE IMAGE Section contains the following imports: MSCOREE.DLL 402000 406270 0 0 Import Address Table Import Name Table time date stamp Index of first forwarder reference

You can achieve the same result using the SET_EV procedure, except that you can set events for any session without logging into the session. The following example illustrates the use of the SET_EV procedure. Note that you can leave the fourth parameter (NM) blank. SQL> EXECUTE SYS.DBMS_SYSTEM.SET_EV(9,271,10046,8,''); PL/SQL procedure successfully completed. SQL>

curr_age=\ `echo "$proc_age_day*1440+$proc_age_hr*60+$proc_age_min" \ | bc` test $debug -gt 0 && echo "Current age of $process pid \ $pid is $curr_age minutes"