RE: Aout plan stabilty matching.

From: Chuan Zhang <Chuan.Zhang_at_transact.com.au>
Date: Wed, 11 Sep 2002 10:08:03 +1000
Message-Id: <22528.293413@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPartTM-000-c70e1900-0db6-4aa6-9c84-4dd3b91334c9 Content-Type: text/plain;

        charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Yes, But how could I ensure offensive statements in outline exactly matching the incoming statements?

Thanks

CHuan

-----Original Message-----
From: Edward Shevtsov [mailto:eshevtsov_at_detmir.ru] Sent: Tuesday, 10 September 2002 6:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: Aout plan stabilty matching.=20

Chuan,

If I remember right, you're supposed to turn the outlines on and then run your sikvel or procedure to catch the offensive statement(s).

Regards,
Ed

>=20

> Hi, All,
> From Oracle Doc: "if the SQL text of the incoming statement=20
> exactly matches the SQL text in an outline in that category,=20
> then Oracle considers both texts identical, and Oracle uses=20
> the outline. Oracle considers any differences a mismatch."=20

>=20

> How could I ensure the incoming SQL text exactly match the=20
> SQL text in an outline? If I fish out an offensive SQL from=20
> library cache by some scripts in SQL*Plus, is this offensive=20
> SQL text identical to the incoming SQL text? Supposed this=20
> SQL text is extracted from stored procedure.=20

>=20

> Appreciated your experience.

>=20

> Chuan

>=20
>=20

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Edward Shevtsov
  INET: eshevtsov_at_detmir.ru

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).

------=_NextPartTM-000-c70e1900-0db6-4aa6-9c84-4dd3b91334c9 Content-Type: text/plain;

        name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;

        filename="InterScan_Disclaimer.txt"

Unless otherwise stated, this e-mail does not represent the views of TransACT Communications Pty Limited. This text and any attachments of this e-mail are confidential and may be legally privileged. This email is for the use of the intended recipient only. If you are not the intended recipient do not take any action in relation to this email, other than to notify TransACT Communications by replying to this e-mail and destroying the original communication. Except as required by law, TransACT Communications does not represent that this transmission is free of errors, viruses or interference. Received on Tue Sep 10 2002 - 19:08:03 CDT