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
|
SQL> set timi on
SQL> select b.value
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and a.name = 'redo size'
5 /
VALUE
----------
2076
EcoulÚ : 00 :00 :00.03
SQL> create table t_redo as
2 select * from all_objects
3 /
Table crÚÚe.
EcoulÚ : 00 :00 :10.01
SQL> select b.value
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and a.name = 'redo size'
5 /
VALUE
----------
166696
EcoulÚ : 00 :00 :00.01
SQL> create table t_redo2(
2 OWNER VARCHAR2(30),
3 OBJECT_NAME VARCHAR2(30),
4 SUBOBJECT_NAME VARCHAR2(30),
5 OBJECT_ID NUMBER,
6 DATA_OBJECT_ID NUMBER,
7 OBJECT_TYPE VARCHAR2(19),
8 CREATED DATE,
9 LAST_DDL_TIME DATE,
10 TIMESTAMP VARCHAR2(19),
11 STATUS VARCHAR2(7),
12 TEMPORARY VARCHAR2(1),
13 GENERATED VARCHAR2(1),
14 SECONDARY VARCHAR2(1),
15 NAMESPACE NUMBER,
16 EDITION_NAME VARCHAR2(30)
17 )
18 /
Table crÚÚe.
EcoulÚ : 00 :00 :00.02
SQL> select b.value
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and a.name = 'redo size'
5 /
VALUE
----------
189056
EcoulÚ : 00 :00 :00.01
SQL> insert into t_redo2
2 select * from all_objects
3 /
68230 ligne(s) crÚÚe(s).
EcoulÚ : 00 :00 :09.94
SQL> select b.value
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and a.name = 'redo size'
5 /
VALUE
----------
8427396
EcoulÚ : 00 :00 :00.01
SQL> commit
2 /
Validation effectuÚe.
EcoulÚ : 00 :00 :00.06
SQL> select b.value
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and a.name = 'redo size'
5 /
VALUE
----------
8427520
EcoulÚ : 00 :00 :00.01 |
Partager