tailieunhanh - Oracle Built−in Packages- P78

Oracle Built−in Packages- P78: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk 16 Sort Progression 0 1 1 16 dbms_application_info 9 1000 1000 3 rows selected. Each session is allocated a maximum of four rows in the V SESSION_LONGOPS virtual table for tracking long operations. Rows are identified by the combination of context and stepid. If calls to are made with more than four distinct combinations of context and stepid rows will be re-used in least-recently-used order. All of the parameters except hint correspond directly to like-named columns in the V SESSION_LONGOPS virtual table. While there are no restrictions on values stored in these columns Oracle makes the following suggestions as a way of organizing information about the progress of long running operations stepsofar If the long-running operation consists of distinct individual steps the amount of work which has been done so far for this step. steptotal If the long-running operation consists of distinct individual steps the total amount of work expected to be done in this step. sofar The amount of work that has been done so far. totalwork The total amount of work expected to be done in this long-running operation. applicationdatal application_data_2 application_data_3 Any numbers the client wishes to store. Also note that all parameters to SET_SESSION_LONGOPS except hint default to zero. This means that calls to the procedure need not specify values for all parameters which is convenient in the case of such a long parameter list. However it also means that any unspecified parameters in a call to SET_SESSION_LONGOPS will have their corresponding columns in V SESSION_LONGOPS set to zero for that row after the call which may not be the desired behavior. PREVIOUS HOME HEXT Getting Started with B00KIMDEX DBMS_APPLICATION_INFO DBMS_APPLICATION_INFO Examples .Oracle PL SQL Oracle PL SQL Oracle Advanced PL SQL Oracle Web Applications Oracle PL SQL Oracle PL SQL H Programming I Programming I Budt-in I .