How to get SQL commands executed on Oracle database in certain period?

From: <qazmlp1209_at_rediffmail.com>
Date: 5 Oct 2006 04:47:07 -0700
Message-ID: <1160048827.491399.84620_at_i42g2000cwa.googlegroups.com>



[Quoted] [Quoted] Is it possible to get the SQL commands executed on a Oracle database from a certain time?

We have a system connected with Server-1 and Server-2. Server-1 uses Oracle RDBMS and Server-2 uses some other database for Data storage. In regular intervals, the application running on the System should fetch all the SQL commands executed on Server-1 from the last interval, convert if required and then apply these changes on the Server-2. I cannot use redo logs, as I have to apply the changes on a non-Oracle database. For this reason, I would like to know how exactly I can get the SQL commands executed on a Oracle database from a certain time(or in certain time period). Received on Thu Oct 05 2006 - 13:47:07 CEST

Original text of this message