SQL & PL/SQL

Hi Experts,

I copied a only audit sys log trigger code that is for a single instance database. We have a 3 nodes (instances) cluster database.

As I know session ID value can be duplicate in each instance in cluster database. How can we get a log audit information for each instance?

I declared v_INST_ID sys.gv_$session.INST_ID%TYPE; how do I get a instance ID ? USERENV('INST_ID')?

SELECT username, machine, command ,INST_ID
INTO v_username, v_machine, v_command,v_INST_ID
FROM sys.gv_$session
WHERE audsid = USERENV('SESSIONID')
AND audsid != 0 -- Don't Check SYS Connections
AND ROWNUM = 1
AND INST_ID= what? or USERENV('INST_ID')?

I have a 10GR2 3 nodes cluster database.

Thanks for help!

Jin