Re: Netapps vs EMC -- db file scattered read

From: <jmourik_at_yahoo.com>
Date: 28 Jan 2005 12:05:56 -0800
Message-ID: <1106942756.867285.176350@z14g2000cwz.googlegroups.com>

Yes, a lot of "it depends" for sure... btw, netapp is nas attached, emc with fibrechannel.
Just as fun facts some statspack data:

Before (NETAPP)...

SNAPTIME	EVENT	                WAIT_MS	WAITS
01/18/2005 08:00:39	db file sequential read	  5	134732
01/18/2005 08:15:05	db file sequential read	  5	541650
01/18/2005 08:30:22	db file sequential read	  18	269556
01/18/2005 08:45:55	db file sequential read	  18	287182
01/18/2005 09:00:22	db file sequential read	  11	403432
01/18/2005 09:15:51	db file sequential read	  15	506866
01/18/2005 09:30:16	db file sequential read	  15	481645
01/18/2005 09:45:47	db file sequential read	  8	776100
01/18/2005 10:00:11	db file sequential read	  7	800140

SNAP_TIME        PART          NAME                      ELAPSED

PERCENTAGE
---------------- ------------- ------------------------- --------

---

01/18 09:00:22   Wait Time     db file scattered read    1:38:48  39.49
01/18 09:00:22   Wait Time     db file sequential read   1:25:52  34.32
01/18 09:00:22   Service Time  Other cpu                 0:20:38   8.24
01/18 09:00:22   Wait Time     buffer busy waits         0:13:38   5.45
01/18 09:00:22   Wait Time     PL/SQL lock timer         0:09:34   3.83
01/18 09:00:22   Wait Time     enqueue                   0:06:22   2.55
01/18 09:00:22   Service Time  recursive cpu usage       0:04:32   1.81
01/18 09:00:22   Wait Time     latch free                0:02:23   0.95
01/18 09:00:22   Service Time  parse time cpu            0:01:37   0.64
01/18 09:00:22   Wait Time     SQL*Net more data to clie 0:01:07   0.45


After (EMC):
SNAPTIME	EVENT	                WAIT_MS	WAITS
01/25/2005 08:00:47	db file sequential read	  3	142288
01/25/2005 08:15:08	db file sequential read	  2	328645
01/25/2005 08:30:32	db file sequential read	  2	124573
01/25/2005 08:45:55	db file sequential read	  2	137748
01/25/2005 09:00:18	db file sequential read	  1	629697
01/25/2005 09:15:39	db file sequential read	  1	334728
01/25/2005 09:30:03	db file sequential read  1	289293
01/25/2005 09:45:25	db file sequential read	  1	225040
01/25/2005 10:00:49	db file sequential read	  1	212765

SNAP_TIME        PART          NAME                      ELAPSED

PERCENTAGE
---------------- ------------- ------------------------- --------

---

01/25 21:00:25   Service Time  Other cpu                1:04:28   70.44
01/25 21:00:25   Wait Time     PL/SQL lock timer        0:14:47   16.16
01/25 21:00:25   Wait Time     db file scattered read   0:06:17    6.86
01/25 21:00:25   Wait Time     db file sequential read  0:02:22    2.59
01/25 21:00:25   Service Time  parse time cpu           0:02:04    2.25
01/25 21:00:25   Service Time  recursive cpu usage      0:01:08    1.24
01/25 21:00:25   Wait Time     latch free               0:00:13    0.23

01/25 21:00:25   Wait Time     log file parallel write  0:00:06    0.10

btw, we run bmc patrol express, hence the pl/sql lock timer. We're getting an eval netapp filer, we'll see how that one performs... jan Received on Fri Jan 28 2005 - 14:05:56 CST