Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to get SQL commands executed on Oracle database in certain period?

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

From: <qazmlp1209_at_rediffmail.com>
Date: 5 Oct 2006 04:47:18 -0700
Message-ID: <1160048838.434079.315190@c28g2000cwb.googlegroups.com>


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 - 06:47:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US