Using tusc on Oracle

[Michael Steele_2]

Hello All:

I'm trying to collect some quantitative data on oracle writes to an EMC Sym. using 'tusc' and I'm having trouble isolating a process or executable to track with tusc. The error is 'permission denied' and seems to be related to the SETUID bit not being set to 'x'.

I'd appreciate any pointers about what process is writing to the Sym so I can proceed with my time collection testing.

Oracle /u01 and /u02 sits atop vxfs file systems.

Thanks in advance.

[Victor Fridyev]

Hi,

ps -fuoracle|grep $ORACLE_SID| grep -e lgw -e dbw

HTH

[Michael Steele_2]

I have a process for oracle id'd as ora_dbwb but this isn't sufficient. What process is used to write? 'db_writer' for example.

[Victor Fridyev]

Michael,

Which Oracle version are you using ?
In any case the most active processes work with redo logs, so you can use fuser in order to see the process[es].
If you have glance installed on the computer, try to use it.

HTH

[IT_2007]

tusc gives you finding out what that process is doing on the server.

Do you want to see what type of data writing to EMC sym by Oracle?

Didn't understand clearly. Please explain.

[Michael Steele_2]

OK. Here's the problem and perhaps I'm approaching it with the wrong tool and I'll look into glance for time stamps.

I've got oracle, ( and I'll have to double check the version on Monday ), sitting atop vxfs file systems mounted with 'delaylog' in order to speed up the writes. 'delaylog' acts like 'async' writing. I want to gather data on the increase of oracle writes to disc and I planned on time stamping oracle first without 'delaylog' and then with 'delaylog' for comparison purposes.

I'm investigating /oracle/u01 and /oracle/u02.

The problem is identifying the the oracle write process or executable.

Now there may be a 'vxfs' write process involved but the 'vxfsd' daeomon is also presenting problems.

Any ideas?

Thanks in advance guys and gals.

[Michael Steele_2]

For example, using 'tusc' with the 'syncer' daemon? What 'tusc' command syntax would I use to monitor 'syncer'?

[Michael Steele_2]

.