Re: Performance problem, Oralce 8.0.4 / Solaris 2.6 / EMC Disk

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 16 Aug 1999 12:59:29 -0500
Message-ID: <7p9ji1$ord$1@garnet.tc.umn.edu>

Some blind suggestions:

I do not know enough about how many buffers, other shared memory in oracle. You may need lots of buffers, sort space, hash space.

Do you use Parallel Query Option? Are the tables partitioned?

Also how is disk paging at the Solaris level? What is happening in vmstat, iostat, sar? At Solaris 2.6 there is a page_priority tunable kernel parameter that may help, you need a patch to implement it. Is it turned on? Check in /etc/system.

--

---

Steven Hauser
email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011

---

Received on Mon Aug 16 1999 - 12:59:29 CDT