Estimated the number of transactions
Microsoft Windows 2000 [Version 5.00.2195]
(C) All rights reserved 1985-2000 Microsoft Corp.
C: /> SQLPLUS "/ as sysdba"
SQL * Plus: Release 9.2.0.1.0 - Production on Thursday, June 17, 15:35:46 2004
CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved.
Connected to:
Oracle9i
Enterprise
Edition Release 9.2.0.1.0 - Production
With the OLAP AND ORACLE DATA MINING OPTIONS
JServer Release 9.2.0.1.0 - Production
SQL> Conn Lunar / Lunar
connected.
SQL> SELECT USN, WRITES from V $ ROLLSTAT;
USN WRITES
---------- ----------
0 6780
1 27114
2 26350
3 31946
4 26456
5 26944
6 41234
7 32780
8 27350
9 33232
10 26224
11 lines have been selected.
SQL> CREATE TABLE TT
2 (cc number);
The table has been created.
SQL> SELECT USN, WRITES from V $ ROLLSTAT;
USN WRITES
---------- ----------
0 6780
1 27114
2 26350
3 31946
4 28222 --------------- Changed 1766 Byte
5 26944
6 41234
7 32780
8 27350
9 33232
10 26224
11 lines have been selected.
SQL> INSERT INTO TT VALUES (1);
It has created a row.
SQL> SELECT USN, WRITES from V $ ROLLSTAT;
USN WRITES
---------- ----------
0 6780
1 27220
2 26568
3 32052
4 28304
5 27162
6 41340
7 32998
8 27456
9 33286
10 26412
11 lines have been selected.
It can be seen that this INSERT operates a total of 1402 Byte's rollback segment space.
SQL> UPDATE TT SET CC = 10;
1 line has been updated.
SQL> SELECT USN, WRITES from V $ ROLLSTAT;
USN WRITES
---------- ----------
0 6780
1 27326
2 26786
3 32158
4 28394
5 27380
6 41446
7 33216
8 27562
9 33340
10 26600
11 lines have been selected.
It can be seen that this UPDATE has a total of 1410 Byte's rollback segment space.
SQL> Delete from TT WHERE CC = 10;
1 line has been deleted.
SQL> SELECT USN, WRITES from V $ ROLLSTAT; USN WRITES
---------- ----------
0 6780
1 29008
2 28842
3 33990
4 28500
5 29436
6 43278
7 35272
8 29394
9 34248
10 28292
11 lines have been selected.
It can be seen that this delete has a total of 16052 Byte's rollback segment space.
SQL> TRUNCATE TABLE TT;
The table has been cut off.
SQL> SELECT USN, WRITES from V $ ROLLSTAT;
USN WRITES
---------- ----------
0 6780
1 30246
2 29030
3 34096
4 28554
5 29654
6 43384
7 35490
8 29500
9 34466
10 28398
11 lines have been selected.
It can be seen that this Truncate has a total of 18610 byte's rollback segment space.
SQL> Drop Table TT;
The table has been discarded.
SQL> SELECT USN, WRITES from V $ ROLLSTAT;
USN WRITES
---------- ----------
0 6780
1 31734
2 29268
3 34510
4 28554
5 29654
6 43384
7 35490
8 29500
9 34466
10 28398
11 lines have been selected.
SQL>
It can be seen that this DROP has a total of 18610 Byte's rollback segment space.
