Tru64 5.1b error

[Ivan Ferreira]

The network is ok, so the problem sems to be disk I/O related, if the output of monitor is reliable, you have a lot of WAIT, you can check this information with vmstat -w 5 10, and see the column for iowait.

Are you using an storage? HSG? (as you methioned show ohter).

Verify if you don't have a failed disk, run show failed.

[Adam Strobel]

Hi Ivan-

The system is running very slow for database query. I have users that are telling me usually there stuff will run in one hour now it takes five.

It does seam like everyone that is complaining it reffers to DB actions.

[Adam Strobel]

Attached is the vmstat -w 5 10

I'm using a compaq storageworks . I also verified that I have no failed disks.

This is a very strange issue.

thnaks for all your help.

[Adam Strobel]

Attached is the vmstat -w 5 10

I'm using a compaq storageworks . I also verified that I have no failed disks.

This is a very strange issue.

thnaks for all your help.

[Ivan Ferreira]

Again verify the iowait from vmstat, if you see high iowait, check this document:

http://www.dbis.informatik.uni-goettingen.de/Teaching/oracle-doc/admin-guide/appd_tru.htm


Section:

Tuning Asynchronous I/O

Direct I/O Support and Concurrent Direct I/O Support

Are you using a RAID device? What RAID level (RAID1 RAID5 RAID0+1)? Is everything ok at the storage?

[Michael Schulte zur Sur]

It looks like there are many I/Os occuring. Has anything changed on the database? Are there extra jobs running? I would ask the dba to check the performance of the Oracle server and the SQL statements.

Michael

[David_854]

Adam,
What is the complete environment including patches.
You may want to take a look at your messages file and tell us what are the errors. Also, take a look at your console output if you do not have one. I'll suggest you run a console or xterm -C ( -C for console output), save that and take a look at the console messages.

David

[Adam Strobel]

Hi

Attached is my /var/adm messages

I checked the console and I have no errors or messages.

thanks,

Adam

[David_854]

Adam,
There are no errors on your messages file. You might want to start troubleshooting using tcpdump check the status of your network, check the errors in binary.errlog, take a look at all your other logs.

David

[Adam Strobel]

thanks David.

Attached are my crash-data.3.txt and also a crash-data |grep panic

Adam