|
21.12.2017, 20:21
#39574033
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
|
|
Участник
Откуда: Middlebury, CT USA
Сообщения: 10 588
Рейтинг:
0
/ 0
|
|
|
|
Беру свои слова обратно:
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.
SQL> select 'AAAAA' from dual
2 /
'AAAA
-----
AAAAA
SQL> select sql_id,
2 executions,
3 invalidations
4 from v$sqlstats
5 where sql_text = q'[select 'AAAAA' from dual]'
6 /
SQL_ID EXECUTIONS INVALIDATIONS
------------- ---------- -------------
bvj89m357jzpp 4 0
SQL> select count(*) from bonus
2 /
COUNT(*)
----------
0
SQL> select sql_id,
2 executions,
3 invalidations
4 from v$sqlstats
5 where sql_text = q'[select count(*) from bonus]'
6 /
SQL_ID EXECUTIONS INVALIDATIONS
------------- ---------- -------------
26xhgam4bmuyd 5 0
SQL> create materialized view emp_mv
2 refresh complete
3 on demand
4 as
5 select e.*,
6 d.dname
7 from emp e,
8 dept d
9 where d.deptno = e.deptno
10 /
Materialized view created.
SQL> begin dbms_mview.refresh(list => 'EMP_MV', method =>'c', atomic_refresh => false , out_of_place => false); end;
2 /
PL/SQL procedure successfully completed.
SQL> select sql_id,
2 executions,
3 invalidations
4 from v$sqlstats
5 where sql_text = q'[select 'AAAAA' from dual]'
6 /
SQL_ID EXECUTIONS INVALIDATIONS
------------- ---------- -------------
bvj89m357jzpp 4 0
SQL> select sql_id,
2 executions,
3 invalidations
4 from v$sqlstats
5 where sql_text = q'[select count(*) from bonus]'
6 /
SQL_ID EXECUTIONS INVALIDATIONS
------------- ---------- -------------
26xhgam4bmuyd 5 0
SQL> begin dbms_mview.refresh(list => 'EMP_MV', method =>'c', atomic_refresh => false , out_of_place => true); end;
2 /
PL/SQL procedure successfully completed.
SQL> select sql_id,
2 executions,
3 invalidations
4 from v$sqlstats
5 where sql_text = q'[select 'AAAAA' from dual]'
6 /
no rows selected
SQL> select sql_id,
2 executions,
3 invalidations
4 from v$sqlstats
5 where sql_text = q'[select count(*) from bonus]'
6 /
no rows selected
SQL>
Так-что открывай SR.
SY. |
|
|
