Anyone aware of the related tools for HITACHI Storage Boxes?
Mucho Appreciado in advance..
-Original Message-
Sent: Friday, September 14, 2001 4:39 PM
To: Multiple recipients of list ORACLE-L
!! Please do not post Off Topic to this List !!
We use EMC Symmetrics. When I got
!! Please do not post Off Topic to this List !!
Hi Jonathan,
Thx for your input.
If I look at v$filestat I see many columns.
Searching the documents don't give me the explanation for them. Where do I
get this info or maybe you can explain.
AVGIOTM seems to be the column I need (units
!! Please do not post Off Topic to this List !!
The other workload I would say was about the same (Relatively speaking)
Both machines did have idle time on the CPU (I/O intensive job).
What are the dominant wait events - in Oracle? It sounds like its probably I/O,
but you might want to
!! Please do not post Off Topic to this List !!
Hi Don,
wait_events that are dominant.
db_file_scattered_reads, db_file_sequential_reads,
db_file_parallel_write,sort_segment_request
are the dominant wait (right under SQL*Net message from client rdbms ipc
message)
So yes I know I have an I/O
!! Please do not post Off Topic to this List !!
Hi Don,
I think I can get your don't believe everything you
hear list to 10no make that 14. This is not
specific to any storage vendor :
8) I/O access patterns on datafiles and redo logfiles
are the same, hence can co-exist without any I/O
Title: RE: I/O Performance/bottlenecks on EMC Symmetrix
Rules of tuning
databases.
There is always a bottleneck.
Once you solve the bottle neck, refer to rule number 1.
Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you
!! Please do not post Off Topic to this List !!
It seems that the I/O wait statistics, along with the increased time it takes
for the job to run, is pretty good circumstantial evidence (enough for the
grand jury hearing). That should be sufficient motivation to start the ball
rolling to collect
!! Please do not post Off Topic to this List !!
Gaja,
I REALLY like #14 :)
Rachel
From: Gaja Krishna Vaidyanatha [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: I/O Performance/bottlenecks on EMC Symmetrix
Date: Fri, 14
!! Please do not post Off Topic to this List !!
corollary to rule 2
after a certain point, just stop. It ain't worth it anymore.
From: Christopher Spence [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: I/O Performance
after a certain point, just stop. It ain't worth it anymore.
From: Christopher Spence [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: I/O Performance/bottlenecks on EMC Symmetrix
Date: Fri, 14 Sep 2001 05:45:20 -0800
!! Please do not post Off Topic to this List !!
We use EMC Symmetrics. When I got here, the folks who set things up
initially where under the impression that you will never have to worry about
placement/io with a Symm. Wrong! I underwent a painstaking process of
relaying out the disks according
!! Please do not post Off Topic to this List !!
Hi All,
Does anybody here on the list have experience with EMC/symmetrix storage
units.?
We have our databases on this machine and I have a feeling the the I/O
performance is not very good. I can not proof it since I do not have any
!! Please do not post Off Topic to this List !!EMC supplies very good tools and
support. Ask your EMC rep to show you how to use them.
[EMAIL PROTECTED] 09/13/01 07:55AM
!! Please do not post Off Topic to this List !!
Hi All,
Does anybody here on the list have experience with
Title: RE: I/O Performance/bottlenecks on EMC Symmetrix
At one site I worked using Oracle Financials we were having serious performance problems at what seemed to us random intervals. Spent months looking at the database after the Unix boys had said that there was no way we could have I/O
!! Please do not post Off Topic to this List !!
WOW! Is the other workload on these similar when this job runs? Are you sure
the problem is the Symmetrix and not something in the OS or instance
configuration? Does this job spend a lot of time waiting (in Oracle) on physical
I/O - or on
Title: RE: I/O Performance/bottlenecks on EMC Symmetrix
We saw
this at a previous location and we found that we had logical volumes on the same
disk.. Used for different applications, and even different systems!! For
example-someone placed TEMP for DB1 and TEMP for DB2 on the same disk
=text/html; charset=iso-8859-1
META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12
TITLERE: I/O Performance/bottlenecks on EMC Symmetrix/TITLE
/HEAD
BODY
PFONT SIZE=2At one site I worked using Oracle Financials we were having
serious performance problems at what seemed to us random
Title: RE: I/O Performance/bottlenecks on EMC Symmetrix
Good list Don, and a dentist as well (repairing a bridge)!!!
-Original Message-
From: Don Granaman [mailto:[EMAIL PROTECTED]]
Sent: 13 September 01 15:15
To: Multiple recipients of list ORACLE-L
Subject: Re: I/O Performance
!! Please do not post Off Topic to this List !!
Hi,
The other workload I would say was about the same (Relatively speaking)
Both machines did have idle time on the CPU (I/O intensive job).
The quicker test machine was a bit stretched on memory at the time (running
about 8 databases) but not
!! Please do not post Off Topic to this List !!
Hi
Given that you don't seem to have access to the hardware, I'd suggest
timestamping. Choose say a few dozen points in the process and collect
timestamps at each one. Compare the prod timestamps to the test timestamps,
something may jump out,
Title: RE: I/O Performance/bottlenecks on EMC Symmetrix
John, I have to say that's a very interesting post. Two shops I've worked in utilizing an EMC Symmetrix claimed that there's no way you could ever end up with i/o problems and you shouldn't even consider it when creating a database
!! Please do not post Off Topic to this List !!
I have had, and heard of, poor performance
from EMC boxes before now because of the
big black box principal.
You might check out James Morle's book
(scaling Oracle 8i) for some thoughts.
From an Oracle perspective, you may
find that simply
22 matches
Mail list logo
