Thanks for the question, sanjeev.
Asked: October 30, 2019 - 11:18 am UTC
Last updated: November 01, 2019 - 1:07 am UTC
Version: Oracle Database 12c EE Extreme Perf Release 12.1.0.2.0 - 64bit Production
Viewed 1000+ times
You Asked
Hi Tom,
I am working on a database application, and i need to know how a table is being populated in the database schema.
I have tried querying xxx_dependencies and xxx_source but of no use.
I believe that this table might be populated from an external server by means of oracle net service.
Is there a way to find out the source of the data, or the server from which the data is being pushed into oracle.
Thanks in advance.
and Connor said...
I have tried querying xxx_dependencies and xxx_source but of no use.
which means it is not PLSQL or similar.
A couple of options you could try:
1) enable auditing on that table - we collect some session/program metadata along with the fact that the table was accessed.
audit insert, update, delete on "my_table" by access;
2) Start with V$SQL to find statements that refer to the table. With a list of relevant SQL_ID's, query V$ACTIVE_SESSION_HISTORY to get information on those sessions that issued those statements.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment