RE: How to map processes to devices -- URGENT!

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 19 Oct 2006 09:19:02 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08788@EXCNYSM0A1AJ.nysemail.nyenet>

David is correct.

Fuser the database file and it will give you a list of unix pid's that are using the file.

Lookup the pid's and you can trace it back to an Oracle connection.

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hameed, Amir Sent: Thursday, October 19, 2006 9:10 AM To: oracle-l_at_freelists.org
Subject: How to map processes to devices -- URGENT!

folks,
I am in need of an urgent help. I am trying to find out how to identify what processes are using certain devices. Our iostat shows high average service times on some SD devices. Our Unix folks seem to be lacking the expertise on how to identify processes that may be using those devices. Any help would be appreciated.

Thanks
Amir

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 19 2006 - 08:19:02 CDT