-
Physical Reads on DWH DB
Hi,
I'm working on a DWH project, and our IO (physical reads MB/s) seems pretty bad.
We are using a Sunfire 6800 (20 CPUs) connect via two fibre channels to a SAN (sorry I dont have yet much more information about the system).
I checked the physical read values of v$sysstat in a interval of 10 seconds and only got an average of something like 200 MB/s. I got this result while executing simple parallel fts on the DB.
So I was wondering what kind of IO (MB/s) you got on your systems when you excute simple fts against large tables and what kind of server/disk system you are using.
I would be gratefull if some of you could give me some examples so that I got an idear if the IO performance of our server is ok or if I could expect much more of it.
Thanks
Mike
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|