Open files

[071]

One of our oracle servers is running very slowly.
Does anyone know the command to display a list of open files ?

 

[cgswong]

You can use the 'ps -ef' command to obtain a list of all running processes which should also give you a list of open files. However, since your more interested in what Oracle is doing (I assume), you might just want to run an Oracle query (or use Enterprise Manager's 'Performance Monitor') to see what files/processes Oracle has open, and what it's doing with them. For more info on the Oracle table you would need to query, you can check your Oracle manual, or a DBA handbook.

I would check into the Oracle side of things just to make sure your database does not need any tuning.

Hope this helps some .

- Stuart

 

[071]

Thanks Stuart,
However, I have already tried the ps -ef command as well as vmstat & perfmon, netstat etc..
We seem to be having memory problems, which we suspect may be caused by a particular process...The problem is finding the b****rd !!

 

[cgswong]

If it's memory problems (and not disk or something else) and you suspect it's your Oracle server, you need to check this out by running queries against certain tables like v$session, v$system, etc. You also need to check your SGA and it's contents.

You can also try 'prtdiag' (/usr/platform/sun4u/sbin).

Hope you find the *#$%*#$ process soon Regards.

- Stuart

 

[071]

Thanks Stuart,
But the 'prtdiag' showed no failures on the system.

Cheers anyway

 

[mcardleg]

you might take a look at the sar command.

# sar -d

Shows disk activity

# sar -u

Shows central processor unit utilization.

Grace

 

[d3funct]

You might also look at downloading the program lsof which you can get at

http://www.gnu.org,

it is a program for listing open files hence ls-o-f. It will tell you who's file it is when it was open and I believe it will show memory usage and cpu usage also. d3funct
borg@pcgeek.net
The software required `Windows 95 or better', so I installed Linux.

 

[071]

That would be very usefull, but I can't seem to find the program. I did a search in gnu on lsof but did'nt get any results.

 

[071]

Found it in

http://www.sunfreeware.com

Thanks !