1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
|
Connected to Oracle9i Enterprise Edition Release 9.2.0.5.0
Connected as mni
SQL>
SQL> Create Or Replace Function f Return Number Is
2 Begin
3 dbms_application_info.set_client_info( sys_context( 'userenv', 'client_info')+1 );
4 return 1;
5 End;
6 /
Function created
SQL> exec dbms_application_info.set_client_info(0)
PL/SQL procedure successfully completed
SQL>
SQL> With generator As
2 (Select rownum As id,
3 rpad('x',50,'x') lib
4 From all_objects
5 Where rownum <= 10
6 ),
7 Data As
8 (Select id, lib, f() As fonc
9 From generator
10 )
11 Select count(*)
12 From Data
13 /
COUNT(*)
----------
10
SQL>
SQL> select sys_context( 'userenv', 'client_info')
2 from dual
3 /
SYS_CONTEXT('USERENV','CLIENT_
--------------------------------------------------------------------------------
0
SQL>
SQL> With generator As
2 (Select rownum As id,
3 rpad('x',50,'x') lib
4 From all_objects
5 Where rownum <= 10
6 ),
7 Data As
8 (Select id, lib, f() As fonc
9 From generator
10 )
11 Select count(fonc)
12 From Data
13 /
COUNT(FONC)
-----------
10
SQL>
SQL> select sys_context( 'userenv', 'client_info')
2 from dual
3 /
SYS_CONTEXT('USERENV','CLIENT_
--------------------------------------------------------------------------------
10
SQL> exec dbms_application_info.set_client_info(0)
PL/SQL procedure successfully completed
SQL>
SQL> With generator As
2 (Select rownum As id,
3 rpad('x',50,'x') lib
4 From all_objects
5 Where rownum <= 10000
6 ),
7 Data As
8 (Select id, lib, f() As fonc
9 From generator
10 )
11 Select count(fonc)
12 From Data
13 /
COUNT(FONC)
-----------
10000
SQL>
SQL> select sys_context( 'userenv', 'client_info')
2 from dual
3 /
SYS_CONTEXT('USERENV','CLIENT_
--------------------------------------------------------------------------------
10000
SQL> |