Re: How to vew SQL queries received from external application

From: Mladen Gogala <>
Date: Wed, 6 Mar 2013 12:46:19 +0000 (UTC)
Message-ID: <kh7dqr$a5t$>

On Tue, 05 Mar 2013 16:32:19 -0800, Yaq wrote:

> Hi, I'm new to Oracle and working a solution that having Oracle talks to
> an external application. The external application sends some sql queries
> to Oracle db. I don't own this external application, so I need to find
> out what exact sql queries are sent. Can anyone tell me how to view
> these queries please?
> Many thanks in advance.

You will have to use an external algorithm, like SHA-512 to compute checksums. Mathias Hoys suggested something similar, but I usually prefer Perl and Digest::SHA module for that, for the reasons of computational efficiency. Perl is using C-language routines, while I suspect that DBMS_CRYPTO uses PL/SQL to compute the hashes.

Received on Wed Mar 06 2013 - 13:46:19 CET

Original text of this message