Hi Alan,
Could we please have just the event name and time waited and only for the
session that did the inserts?
Regards,
Steve Adams
In article <924529781.4585.0.nnrp-11.c2d97406_at_news.demon.co.uk>,
"Alan Barclay" <escribe_at_my-dejanews.com> wrote:
> 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.
>
> ** CPU load during test was ~30% **
>
> ----------------------------------------------------------------------------
> -------------------------------------------------
>
> 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.
>
> ** CPU load during test was 10-15% **
>
> ----------------------------------------------------------------------------
> -------------------------------------------------
>
>
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Apr 19 1999 - 15:20:37 CDT
