select 产生redo的疑问
SQL> desc scott.test
Name Null? Type
----------------------------------------- -------- -------------------------
NAME VARCHAR2(5)
IP_ADDR VARCHAR2(100)
session 1:
SQL> insert into scott.test values('test','127.0.0.1');
1 row created.
session 2:
SQL> select * from scott.test;
no rows selected
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
9 consistent gets
0 physical reads
108 redo size
318 bytes sent via SQL*Net to client
376 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
0 rows processed
Name Null? Type
----------------------------------------- -------- -------------------------
NAME VARCHAR2(5)
IP_ADDR VARCHAR2(100)
session 1:
SQL> insert into scott.test values('test','127.0.0.1');
1 row created.
session 2:
SQL> select * from scott.test;
no rows selected
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
9 consistent gets
0 physical reads
108 redo size
318 bytes sent via SQL*Net to client
376 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
0 rows processed
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7192804/viewspace-346788/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
关于驱动表的选择
请登录后发表评论
登录
全部评论
