This forum is currently locked. You can't register or post questions at this time. (read more)

How to whick table is getting data

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

venkat
Member
Posts: 30
Joined: Sat Jan 05, 2013 5:13 am

How to whick table is getting data

Postby venkat » Tue May 13, 2014 8:54 am

Dear Tim,

I am using Oracle apps i need ti know when the end user is doing transaction i need to know the tables which are affecting is there any way i can find the list of tables are getting data during the specific time

Please

Thanks & regards
venkat

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: How to whick table is getting data

Postby Tim... » Tue May 13, 2014 10:23 am

Hi.

There are a few things you can do...

1) You can turn on auditing for that user, which gives you as much or as little detail about the user's actions as you need.

http://www.oracle-base.com/articles/10g ... -10gr2.php

2) If you identify the session in the v$session view, you can identify the open cursors relevant to that session.

http://www.oracle-base.com/dba/script.p ... ssions.sql
http://www.oracle-base.com/dba/script.p ... by_sid.sql

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

venkat
Member
Posts: 30
Joined: Sat Jan 05, 2013 5:13 am

Re: How to whick table is getting data

Postby venkat » Tue May 13, 2014 11:40 am

Dear Tim,

I would like to know which table is affecting because i am unable to find the table from the application so when the user enters data from application
from data base can i see what are the tables are getting affected

Thanks & Regards
Venkat

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: How to whick table is getting data

Postby Tim... » Tue May 13, 2014 4:34 pm

Hi.

Exactly what auditing or looking for open cursors will do!

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 3 guests

cron