Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to get SQL commands executed on Oracle database in certain period?
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