OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » table query (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

table query [message #589850]

Thu, 11 July 2013 07:22

mrdb
Messages: 62
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.

Report message to a moderator

Re: table query [message #589854 is a reply to message #589850]

Thu, 11 July 2013 08:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: table query [message #589857 is a reply to message #589850]

Thu, 11 July 2013 08:12

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It depends long time ago or in the last minutes?

Regards
Michel

Report message to a moderator

Re: table query [message #590935 is a reply to message #589857]

Wed, 24 July 2013 05:10

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..,

Report message to a moderator

Re: table query [message #590940 is a reply to message #590935]

Wed, 24 July 2013 05:20

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"executed" means the execution is over.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 14:31:32 CST 2024