Home » RDBMS Server » Server Administration » table query (oracle 10g)
table query [message #589850] Thu, 11 July 2013 07:22 Go to next message
mrdb
Messages: 60
Registered: December 2009
Location: dubai
Member

Is there any query to view sql delete command executed on a table.
means the sql commands issued on the particular table.
Re: table query [message #589854 is a reply to message #589850] Thu, 11 July 2013 08:01 Go to previous messageGo to next message
BlackSwan
Messages: 21967
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


DBMS_LOGMNR can provide desired details
Re: table query [message #589857 is a reply to message #589850] Thu, 11 July 2013 08:12 Go to previous messageGo to next message
Michel Cadot
Messages: 57644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends long time ago or in the last minutes?

Regards
Michel
Re: table query [message #590935 is a reply to message #589857] Wed, 24 July 2013 05:10 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
this issue may be a performance tuning issue, whereby you can use TKPROF utility method, or by checking with dynamic performance views such as v$session_longops..,while the query is running for a longer period, the columns 'start_time', 'sofar' ( v$session_longops) needs to be checked..,



Re: table query [message #590940 is a reply to message #590935] Wed, 24 July 2013 05:20 Go to previous message
Michel Cadot
Messages: 57644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"executed" means the execution is over.

Regards
Michel
Previous Topic: Change datatype to HEX notation / base 64
Next Topic: TNS connection closed - Remote Job
Goto Forum:
  


Current Time: Thu Apr 24 02:09:54 CDT 2014

Total time taken to generate the page: 0.11745 seconds