Chto sporit - eto proveriaetsia v 5 minut:
ispolzuia statistiku sessii
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.
SQL> select n.name, m.value
from v$mystat m, v$statname n
where m.statistic# = n.statistic#
and
n.name in ('opened cursors cumulative',
'opened cursors current');
NAME VALUE
----------------------------------------------------- ----------
opened cursors cumulative 48
opened cursors current 1
SQL> declare
cursor cr is select 1 from dual;
n number;
begin
open cr;
fetch cr into n;
dbms_output.put_line('\nn = '||to_char(n));
close cr;
exception when others then
if cr%isopen then close cr; end if;
end;
/
PL/SQL procedure successfully completed.
SQL> select n.name, m.value
from v$mystat m, v$statname n
where m.statistic# = n.statistic#
and
n.name in ('opened cursors cumulative',
'opened cursors current');
NAME VALUE
----------------------------------------------------- ----------
opened cursors cumulative 51
opened cursors current 1
SQL> declare
cursor cr is select 1 from dual;
n number;
begin
open cr;
fetch cr into n;
dbms_output.put_line('\nn = '||to_char(n));
-- close cr;
--exception when others then
-- if cr%isopen then close cr; end if;
end;
/
PL/SQL procedure successfully completed.
SQL> select n.name, m.value
from v$mystat m, v$statname n
where m.statistic# = n.statistic#
and
n.name in ('opened cursors cumulative',
'opened cursors current');
NAME VALUE
----------------------------------------------------- ----------
opened cursors cumulative 54
opened cursors current 1
SQL> select n.name, m.value
from v$mystat m, v$statname n
where m.statistic# = n.statistic#
and
n.name in ('opened cursors cumulative',
'opened cursors current');
moget bit kursor ostaetsia gdeto v sistemnoy oblasti (i uhodit iz statistiki sessii) ?
ispolzuia system statistics
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.
SQL> select name, value
from v$sysstat
where name in ('opened cursors cumulative',
'opened cursors current');
NAME VALUE
---------------------------------------------------------------- ----------
opened cursors cumulative 3044385
opened cursors current 1
SQL> declare
cursor cr is select 1 from dual;
n number;
begin
open cr;
fetch cr into n;
dbms_output.put_line('\nn = '||to_char(n));
close cr;
exception when others then
if cr%isopen then close cr; end if;
end;
/
PL/SQL procedure successfully completed.
SQL> select name, value
from v$sysstat
where name in ('opened cursors cumulative',
'opened cursors current');
2 3 4
NAME VALUE
---------------------------------------------------------------- ----------
opened cursors cumulative 3044448
opened cursors current 1
SQL> declare
cursor cr is select 1 from dual;
n number;
begin
open cr;
fetch cr into n;
dbms_output.put_line('\nn = '||to_char(n));
-- close cr;
--exception when others then
-- if cr%isopen then close cr; end if;
end;
/
PL/SQL procedure successfully completed.
SQL> select name, value
from v$sysstat
where name in ('opened cursors cumulative',
'opened cursors current');
NAME VALUE
---------------------------------------------------------------- ----------
opened cursors cumulative 3044451
opened cursors current 1
vivod -- po krainey mere dlia neimennovannih progpammnih blokov cursor zakrivaetsia pri
vihode iz bloka.
