ba6.us - Dave's Database Related Stuff

I colleague turned me on to a helpful command the other night. Where I work we have an archived log based replication system. It was way behind on processing and the replication process doesn't give any indication of what log its currently chewing on. /sbin/fuser to the rescue!

• 1) 'cd' to a directory where you want to check the files
• 2) run '/sbin/fuser *' to discover what processes are touching files in the directory

[oracle@test /] cd /u01/app/oracle/oradata/TEST
[oracle@test TEST] ls redo*
 Read more »

Helpful tip from the RedHat site if you installed the OS from Cd-Roms and want to add new packages from a disk mount...

http://www.redhat.com/magazine/004feb05/departments/tips_tricks/

– Dave

So my last post was about administration on Linux. After running Oracle on Windows for way too many years we migrated our Oracle systems to 64-bit Linux over the past year. Now that we're on Linux I needed a lightweight way to capture and graph some performance data. The performance data was a mix of OS utilities and 3rd party utilities, but all the utilities output text, so I knew I could screen scrape the output, massage it a little, and save the data to a file. After I had the data in a file I knew I could run it through GnuPlot to graph it.