OraFAQ Forum: Performance Tuning » SQL ordered by Elapsed Time & SQL Module

Home » RDBMS Server » Performance Tuning » SQL ordered by Elapsed Time & SQL Module (10g & AIX 6.1)

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

SQL ordered by Elapsed Time & SQL Module [message #578084]

Sun, 24 February 2013 06:41

gatetec
Messages: 38
Registered: December 2012

Member

Elapsed Time (s) CPU Time (s) Executions  Elap per Exec (s)  % Total DB Time SQL Id SQL Module SQL Text 
2,423 1 3,919 0.62 1.83 gt49gg0fnc5x8 srv_dr@ahs (TNS V1-V3)  UPDATE /*+ CCL<OENDB_FILE... 
2,227 14 1 2227.16 1.68 bggfx8a04prj9 SQL*Plus  select * from (select n.source... 
.........

On [SQL ordered by Elapsed Time], [SQL Module] shows an indication that a SQL was executed by which process (i.e. srv_dr@ahs)outside of SQL*PLUS.
If [SQL Modeule] shows as [SQL*Plus], does it mean the query was run in SQL*PLUS manually or directly?
I have the SQL ID. How do I find out who, how, and exactly what time it was run?

Thank you.

Report message to a moderator

Re: SQL ordered by Elapsed Time & SQL Module [message #578100 is a reply to message #578084]

Sun, 24 February 2013 08:07

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

Senior Member
Account Moderator

Quote:

does it mean the query was run in SQL*PLUS manually or directly?

What does this mean? What does mean "manually"? What do you mean by "directly"? What is a non-"manual" run and a non-"direct" run?

Regards
Michel

Report message to a moderator

Re: SQL ordered by Elapsed Time & SQL Module [message #578122 is a reply to message #578100]

Sun, 24 February 2013 08:28

gatetec
Messages: 38
Registered: December 2012

Member

I meant "Manually and Directly" as a user logged in the database UNIX host and su - to oracle and executed the sql in SQl PLUS, rather than the sql was executed by applications.

Report message to a moderator

Re: SQL ordered by Elapsed Time & SQL Module [message #578126 is a reply to message #578122]

Sun, 24 February 2013 08:31

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

Senior Member
Account Moderator

If the module is SQL*Plus then it is most likely that this is a sqlplus session without b eing ure as anyone can set the module as SQL*Plus if he wants.

Regards
Michel

Report message to a moderator

Re: SQL ordered by Elapsed Time & SQL Module [message #578130 is a reply to message #578126]

Sun, 24 February 2013 08:36

gatetec
Messages: 38
Registered: December 2012

Member

Is there any way to trace back what time by which user the sql was executed? I know the SQL ID, and it was executed less than 24 hours.

Thank you

Report message to a moderator

Re: SQL ordered by Elapsed Time & SQL Module [message #578133 is a reply to message #578130]

Sun, 24 February 2013 08:43

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/

>Is there any way to trace back what time by which user the sql was executed? I know the SQL ID, and it was executed less than 24 hours.
no

Report message to a moderator

Previous Topic:	DELETE taking long time
Next Topic:	performance tuning on SQL Queries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 29 16:29:38 CST 2025