RE: who execute scripts in Win NT like Unix!!

From: Thomas, Kevin <Kevin.Thomas_at_calanais.com>
Date: Wed, 14 Nov 2001 03:32:50 -0800
Message-ID: <F001.003C452A.20011114031053@fatcity.com>

Alex,

echo spool output.lis                        > sql_file.sql
echo SELECT s.sid,                          >> sql_file.sql
echo        s.serial#,                      >> sql_file.sql
echo        p.pid,                          >> sql_file.sql
echo        p.spid,                         >> sql_file.sql
echo        s.osuser,                       >> sql_file.sql
echo        s.machine,                      >> sql_file.sql
echo        s.program                       >> sql_file.sql
echo   FROM v$session s, v$process p        >> sql_file.sql
echo  WHERE p.addr = s.paddr                >> sql_file.sql
echo    AND s.schemaname <> 'SYS'           >> sql_file.sql
echo  ORDER BY p.spid,s.sid, p.pid, p.spid; >> sql_file.sql
echo  exit                                  >> sql_file.sql
echo spool off                              >> sql_file.sql

sqlplus dbvision/dbvision_at_t_nhspint @sql_file.sql

Put the above commands into a DOS batch file and then run it...you can add in things like SET LINESIZE etc...just the same way as the spool command is written.

Cheers,
Kev.

"hit any user to continue"

---

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)

Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com

-----Original Message-----
Sent: 13 November 2001 23:00
To: Multiple recipients of list ORACLE-L

Hi gurus!!!
I need execute any scripts in win nt like oracle in unix!!! example:
sqlplus user/password << fin

SELECT s.sid,
       s.serial#,
       p.pid,
       p.spid,
       s.osuser,
       s.machine,
       s.program

FROM v\$session s, v\$process p
WHERE p.addr = s.paddr
  AND s.schemaname <> 'SYS'
  ORDER BY p.spid,s.sid, p.pid, p.spid;
fin

@lex

---

  Lic. Alexander Ordóñez Arroyo

  Caja Costarricense del Seguro Social                             
  Soporte Técnico - División de Informática                     
  Telefono: 295-2004, San José, Costa Rica                    
  Aordonez_at_ccss.sa.cr        Icq# 30173325

------------------------------------------------------------

The true is out there in WWW

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alexander Ordonez
  INET: aordonez_at_ccss.sa.cr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas, Kevin
  INET: Kevin.Thomas_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Wed Nov 14 2001 - 05:32:50 CST