| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert Speed on 8.0.5 on Linux/Solaris
Steve Adams wrote in message <7ff352$mm$1_at_nnrp1.dejanews.com>...
>Hi Alan,
>
>Could you please re-run your tests and post the output from v$session_event
>and the 'CPU used by this session' value from v$sesstat. That will show us
>where the difference in time is.
>
>Regards,
>Steve Adams
OK. Here we are. I hope it helps! The other columns were all 0.
I should also point out that the Linux box barely accesses its HD where as the Solaris box is thrashing its HD - so perhaps they make use of filesystem cacheing very differently??
Linux - before test (36000 inserts)
SQL> select * from v$session_event;
SID EVENT
TOTAL_WAITS TOTAL_TIMEOUTS
--------- ---------------------------------------------------------------- -
---------- -------------
1 pmon timer
17 17
2 rdbms ipc message
31 17
3 rdbms ipc message
29 17
6 rdbms ipc message
1 1
4 rdbms ipc message
19 17
2 control file sequential read
27 0
4 control file sequential read
9 0
3 control file sequential read
20 0
3 control file parallel write
8 0
4 control file parallel write
16 0
3 log file sequential read
4 0
3 log file single write
4 0
3 log file parallel write
10 0
5 db file sequential read
15 0
8 db file sequential read
236 0
5 db file scattered read
18 0
2 db file parallel write
4 0
2 direct path read
7 0
3 direct path read
7 0
3 direct path write
7 0
5 smon timer
3 0
2 file identify
7 0
3 file identify
4 0
4 file identify
6 0
2 file open
13 0
8 file open
1 0
5 file open
8 0
4 file open
9 0
3 file open
14 0
8 SQL*Net message to client
40 0
8 SQL*Net message from client
39 0
31 rows selected.
Linux - after test (36000 inserts)
SQL> select * from v$session_event;
SID EVENT
TOTAL_WAITS TOTAL_TIMEOUTS
--------- ---------------------------------------------------------------- -
---------- -------------
1 pmon timer
131 131
2 rdbms ipc message
493 129
3 rdbms ipc message
36212 91
6 rdbms ipc message
2 2
4 rdbms ipc message
211 131
2 control file sequential read
27 0
4 control file sequential read
476 0
3 control file sequential read
957 0
3 control file parallel write
477 0
4 control file parallel write
361 0
3 log file sequential read
82 0
3 log file single write
160 0
3 log file parallel write
36094 0
2 log file sync
5 0
5 db file sequential read
18 0
8 db file sequential read
236 0
6 db file sequential read
7 0
5 db file scattered read
20 0
2 db file parallel write
1889 0
2 direct path read
7 0
3 direct path read
7 0
4 direct path read
539 0
3 direct path write
7 0
4 direct path write
539 0
5 smon timer
4 1
2 file identify
7 0
3 file identify
160 0
4 file identify
6 0
2 file open
13 0
3 file open
170 0
5 file open
8 0
8 file open
1 0
6 file open
1 0
4 file open
16 0
8 SQL*Net message to client
44 0
8 SQL*Net message from client
43 0
36 rows selected.
SQL> select * from v$sesstat where statistic# = 12;
SID STATISTIC# VALUE
--------- ---------- ---------
1 12 0
2 12 0
3 12 0
4 12 0
5 12 0
6 12 0
8 12 0
7 rows selected.
Solaris - before test (36000 inserts)
SQL> select * from v$session_event;
SID EVENT
TOTAL_WAITS TOTAL_TIMEOUTS
--------- ---------------------------------------------------------------- -
---------- -------------
5 latch free
1 1
1 pmon timer
14 14
2 rdbms ipc message
25 14
3 rdbms ipc message
20 14
6 rdbms ipc message
1 1
4 rdbms ipc message
16 14
2 control file sequential read
27 0
4 control file sequential read
9 0
3 control file sequential read
20 0
3 control file parallel write
8 0
4 control file parallel write
13 0
3 log file sequential read
4 0
3 log file single write
4 0
3 log file parallel write
7 0
5 db file sequential read
17 0
8 db file sequential read
246 0
5 db file scattered read
18 0
2 db file parallel write
3 0
2 direct path read
7 0
3 direct path read
7 0
3 direct path write
7 0
5 smon timer
2 0
2 file identify
7 0
3 file identify
4 0
4 file identify
6 0
2 file open
13 0
8 file open
2 0
5 file open
8 0
4 file open
9 0
3 file open
14 0
8 SQL*Net message to client
40 0
8 SQL*Net message from client
39 0
32 rows selected.
Solaris - after test (36000 inserts)
SQL> select * from v$session_event;
SID EVENT
TOTAL_WAITS TOTAL_TIMEOUTS
--------- ---------------------------------------------------------------- -
---------- -------------
2 latch free
2 2
3 latch free
3 3
5 latch free
1 1
1 pmon timer
188 188
2 rdbms ipc message
463 141
3 rdbms ipc message
36144 44
4 rdbms ipc message
268 178
6 rdbms ipc message
2 2
2 control file sequential read
27 0
3 control file sequential read
968 0
4 control file sequential read
483 0
3 control file parallel write
482 0
4 control file parallel write
421 0
3 log file sequential read
83 0
3 log file single write
162 0
3 log file parallel write
36084 0
2 log file sync
26 0
5 db file sequential read
20 0
6 db file sequential read
7 0
8 db file sequential read
246 0
5 db file scattered read
20 0
2 db file parallel write
1910 1
2 direct path read
7 0
3 direct path read
7 0
4 direct path read
553 0
3 direct path write
7 0
4 direct path write
553 0
5 smon timer
3 1
2 file identify
7 0
3 file identify
162 0
4 file identify
6 0
2 file open
13 0
4 file open
16 0
5 file open
8 0
8 file open
2 0
6 file open
1 0
3 file open
172 0
8 SQL*Net message to client
44 0
8 SQL*Net message from client
43 0
39 rows selected.
SQL> select * from v$sesstat where statistic# = 12;
SID STATISTIC# VALUE
--------- ---------- ---------
1 12 0
2 12 0
3 12 0
4 12 0
5 12 0
6 12 0
8 12 0
7 rows selected.
 |
 |