Home » RDBMS Server » Performance Tuning » SQL ordered by Elapsed Time & SQL Module (10g & AIX 6.1)
SQL ordered by Elapsed Time & SQL Module [message #578084] Sun, 24 February 2013 06:41 Go to next message
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.

Re: SQL ordered by Elapsed Time & SQL Module [message #578100 is a reply to message #578084] Sun, 24 February 2013 08:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59409
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: SQL ordered by Elapsed Time & SQL Module [message #578122 is a reply to message #578100] Sun, 24 February 2013 08:28 Go to previous messageGo to next message
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.
Re: SQL ordered by Elapsed Time & SQL Module [message #578126 is a reply to message #578122] Sun, 24 February 2013 08:31 Go to previous messageGo to next message
Michel Cadot
Messages: 59409
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: SQL ordered by Elapsed Time & SQL Module [message #578130 is a reply to message #578126] Sun, 24 February 2013 08:36 Go to previous messageGo to next message
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
Re: SQL ordered by Elapsed Time & SQL Module [message #578133 is a reply to message #578130] Sun, 24 February 2013 08:43 Go to previous message
BlackSwan
Messages: 22901
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/


>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
Previous Topic: DELETE taking long time
Next Topic: performance tuning on SQL Queries
Goto Forum:
  


Current Time: Tue Oct 21 12:46:09 CDT 2014

Total time taken to generate the page: 0.11617 seconds