RE: SQL Trace

From: Zhong Hong <zhong_at_cantametrix.com>
Date: Tue, 26 Sep 2000 10:52:58 -0700
Message-Id: <10631.117892@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C027E2.9AE95910
Content-Type: text/plain;

charset="iso-8859-1"

I'm looking for an installation guide for OID 2.0.6 on NT. Can anybody point me to the direction?
TIA, Zhong
It's another beautiful day!

-----Original Message-----
From: Armstead, Michael A [mailto:maa25681_at_glaxowellcome.com] Sent: Tuesday, September 26, 2000 8:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: SQL Trace

Why don't you try a quick look at the V$SQLAREA first?

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo Wellcome

> -----Original Message-----
> From: Ken Gerrbo [SMTP:ken_gerrbo_at_yahoo.com]
> Sent: Tuesday, September 26, 2000 10:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL Trace
>
> Hi Oracle Juru's ,
>
> I have an application running on ODBC linked to an ORACLE 8i , I got
> ORA-00900 INVALID SQL . I want to know what SQL is passed to the Database
> . Where can I intiate the sql trace to be able to know . Thanks

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Armstead, Michael A
  INET: maa25681_at_glaxowellcome.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).

------_=_NextPart_001_01C027E2.9AE95910
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2651.75">
<TITLE>RE: SQL Trace</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>I'm looking for an installation guide for OID 2.0.6 on NT. Can anybody point me to the direction?</FONT>
<BR><FONT SIZE=2>TIA,</FONT>
</P>

<P><FONT SIZE=2>Zhong</FONT>
<BR><FONT SIZE=2>It's another beautiful day!</FONT>
</P>
<BR>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Armstead, Michael A [<A HREF="mailto:maa25681_at_glaxowellcome.com">mailto:maa25681_at_glaxowellcome.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Tuesday, September 26, 2000 8:16 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RE: SQL Trace</FONT>
</P>
<BR>

<P><FONT SIZE=2>Why don't you try a quick look at the V$SQLAREA first?</FONT>
</P>

<P><FONT SIZE=2>Michael Armstead</FONT>
<BR><FONT SIZE=2>Database Administrator, OCP-Certified</FONT>
<BR><FONT SIZE=2>Corporate &amp; Finance Information Systems</FONT>
<BR><FONT SIZE=2>Glaxo Wellcome</FONT>
</P>
<BR>

<P><FONT SIZE=2>&gt; -----Original Message-----</FONT>
<BR><FONT SIZE=2>&gt; From: Ken Gerrbo [SMTP:ken_gerrbo_at_yahoo.com]</FONT>
<BR><FONT SIZE=2>&gt; Sent: Tuesday, September 26, 2000 10:51 AM</FONT>
<BR><FONT SIZE=2>&gt; To:&nbsp;&nbsp; Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt; Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL Trace</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Hi Oracle Juru's ,</FONT>
<BR><FONT SIZE=2>&gt;&nbsp; </FONT>
<BR><FONT SIZE=2>&gt;&nbsp; I have an application running on ODBC linked to an ORACLE 8i , I got</FONT>
<BR><FONT SIZE=2>&gt; ORA-00900 INVALID SQL . I want to know what SQL is passed to the Database</FONT>
<BR><FONT SIZE=2>&gt; . Where can I intiate the sql trace to be able to know . Thanks </FONT>
</P>

<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Armstead, Michael A</FONT>
<BR><FONT SIZE=2>&nbsp; INET: maa25681_at_glaxowellcome.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>

Received on Tue Sep 26 2000 - 12:52:58 CDT