OraFAQ Forum: Server Administration » my update sql dees not appear in v$session

Home » RDBMS Server » Server Administration » my update sql dees not appear in v$session_longops (11.2.0.1.0 Windos XP)

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

my update sql dees not appear in v$session_longops [message #520819]

Wed, 24 August 2011 20:08

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
How can i make my update sql(update tb_test set a='test') appear in v$session_longops? now i execute my sql,there is no any rows in v$session_longops. note:the update run for a long time.

Report message to a moderator

Re: my update sql dees not appear in v$session_longops [message #520820 is a reply to message #520819]

Wed, 24 August 2011 20:11

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,
The table tb_test has been analyzeed and the parameters sql_trace is set to true.

Report message to a moderator

Re: my update sql dees not appear in v$session_longops [message #520821 is a reply to message #520819]

Wed, 24 August 2011 20:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>(11.2.0.1.0 Windos XP)
REALLY? That is a nice unsupported combination of OS & Oracle version.

>How can i make my update sql(update tb_test set a='test') appear in v$session_longops?
why should it appear?

When all else fails Read The Fine Manual

http://www.oracle.com/pls/db112/search?remark=quick_search&word=v%24session_longops

Report message to a moderator

Re: my update sql dees not appear in v$session_longops [message #520834 is a reply to message #520819]

Wed, 24 August 2011 23:27

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You cannot make a SQL appears in v$session_longops, Oracle does it when it wants.
Note that v$session_longops does NOT contain long SQL but long OPERATIONS. A SQL is (can be) many and many short operations.

Regards
Michel

Report message to a moderator

Previous Topic:	Not able to kill the session
Next Topic:	problem in login using local naming (tnsnames.ora)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 02:24:57 CDT 2024