www.eygle.com

[oracle@order ~]$ sqlplus eygle/eygle

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jun 16 11:29:49 2006
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> show sga

Total System Global Area 2483027968 bytes
Fixed Size 1262344 bytes
Variable Size 536874232 bytes
Database Buffers 1929379840 bytes
Redo Buffers 15511552 bytes

SQL> create table t as select * from dba_objects where 1=0;

Table created.

SQL> begin
2 for i in 1 .. 10000 loop
3 insert into t select * from dba_objects where rownum <1001;
4 commit;
5 end loop
6 ;
7 end;
8 /

PL/SQL procedure successfully completed.

[oracle@xcstat ~]$ iostat -k 5|grep -v "0.00 0.00 0.00"
Linux 2.6.9-34.ELsmp (xcstat.xcsky.cn) 06/16/2006

avg-cpu: %user %nice %sys %iowait %idle
4.70 0.00 2.40 25.24 67.67

Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sda 1164.47 7.98 18447.11 40 92420
sda5 4613.37 7.98 18445.51 40 92412
sda7 0.40 0.00 1.60 0 8

avg-cpu: %user %nice %sys %iowait %idle
4.75 0.00 3.60 28.23 63.41

Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sda 670.94 0.00 48109.82 0 240068
sda5 12026.85 0.00 48107.41 0 240056
sda7 0.60 0.00 2.40 0 12