How to monitor I/O bottle necks ?


 
Thread Tools Search this Thread
Operating Systems HP-UX How to monitor I/O bottle necks ?
# 1  
Old 07-24-2008
How to monitor I/O bottle necks ?

Hi ,
I am an Oracle DBA. My database is on HP-UX 11.23. Our production system are experiencing huge performance problems recently. I know that the performance problems are due to amount of I/O done on some files. Is there any way to find out which files are being written into or read most often at Unix Level.

Any help is appreciated.

Thanks,
Vikings...
# 2  
Old 07-24-2008
Don't know how to do this at unix level. Not available from "sar", "top" or "glance".

Easy in Oracle 9 with sqlplus:

select substr(name,1,50) name,phyrds,phywrts
from v$datafile a,v$filestat b
where a.file# = b.file#;
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Infrastructure Monitoring

Searching for Saas Monitor service which monitor my servers which are sitting in different providers

Sorry if this is the wrong forum Searching for Saas Monitor service which monitor my servers which are sitting in different providers . This monitor tool will take as less CPU as possible , and will send info about the server to main Dashboard. The info I need is CPU / RAM / my servers status (... (1 Reply)
Discussion started by: umen
1 Replies

2. Hardware

Fedora 16 dual monitor - dual head - automatic monitor shutdown

Hi, I am experiencing troubles with dual monitors in fedora 16. During boot time both monitors are working, but when system starts one monitor automatically shut down. It happend out of the blue. Some time before when I updated system this happend but then I booted older kernel release and... (0 Replies)
Discussion started by: wakatana
0 Replies

3. Shell Programming and Scripting

Monitor script

Does anyone have a monitoring script in solaris that monitors the drives in an exclosure? The script should be in /bin/bash or /bin/sh thnks again This should be for solaris 10/11 looking for something that tells me a drive is down or offline.:confused: (0 Replies)
Discussion started by: walnutpony123
0 Replies

4. AIX

How to monitor ftp?

If somebody ftp a file from one server to my server, can I know what he ftp? And when he ftp? (2 Replies)
Discussion started by: rainbow_bean
2 Replies

5. Shell Programming and Scripting

Help with HD monitor script

Hi, I'm new to linux and I'm trying to compile a hard drive monitoring script. I've seen a few on the internet and I've attempted to stumble through but I'm stuck at my while/do scenario. I assigned the variable NUM then took the percentage from my output and cut the % so it would be just a... (6 Replies)
Discussion started by: crocyson
6 Replies

6. Shell Programming and Scripting

Monitor: Read from the monitor

Hello, I would like to write a script that use the display as an input. In the display there is a list of file. I want to use it as an array and this would be the input in my script. Does somebody know how do I make it? (2 Replies)
Discussion started by: mig8
2 Replies

7. Shell Programming and Scripting

Monitor via crontab

Hi , I have a configuration file which i have to monitor via a crontab. Now i should be able to control the first cron job via a second one i start depending on the start time and stop time in config file. say if the starttime is 10:00 AM and stop time is 12:00 Noon , i have to start the... (4 Replies)
Discussion started by: rvenkam
4 Replies

8. SCO

temperature monitor

Is there command in sco unixware 7.1.3 from which i can find the temperature of the system/hardware. Something equivalent to prtdiag in solaris maybe thanks (1 Reply)
Discussion started by: gsb81
1 Replies

9. Solaris

PC monitor

In order to use a regular PC monitor would I need to do any configuration changes to my Ultra 5 box running Solaris 8 ? (1 Reply)
Discussion started by: mangolinux
1 Replies
Login or Register to Ask a Question