asked on
#!/bin/sh
for BASE in $(ps -ef | grep pmon | grep -v "grep" | awk -F "pmon_" '{print$2}')
do
export ORACLE_SID=$BASE
. oraenv $BASE
${ORACLE_HOME}/bin/sqlplus -S / as sysdba << !
SET TERMOUT OFF
SET VERIFY OFF
select '"'||'US'||'"'||','||'"'||SYS_CONTEXT('USERENV','HOST') ||'"'||','||'"'||instance_name||'"'||','||'"'||u.username||'"'||','||'"'||u.PROFILE||'"'||','||'"'||p.limit||'"'||','||'"' ||sysdate||'"' from dba_users u, dba_profiles p, v\$instance, dual where u.profile=p.profile;
!
done
Thank you