Home » RDBMS Server » Performance Tuning » how to find list of sql statements ran in the past time. (oracle 10.2.0.3)
how to find list of sql statements ran in the past time. [message #362293] Mon, 01 December 2008 13:09 Go to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Experts,

i want to find the list of sql statements ran in the past time.
i am taking snapshot on every hour and i am keeping it up to 30 days.

for a performance analysis i need to take explain plan for one statement which ran in the past. i am able to see some sql statements in awr reports which are only time resource consuming sql statements.

now i need to find all the sql statements which are ran from
1:00 AM to 4:00 am GMT TIME.

is there any way to get sql_id's and what time it was ran?


Thanks,

Jyothy ..
Re: how to find list of sql statements ran in the past time. [message #362295 is a reply to message #362293] Mon, 01 December 2008 13:16 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_HIST_SQLTEXT
DBA_HIST_SQL_PLAN

But you can't have ALL unless you activate sql trace for all sessions.

Regards
Michel

[Updated on: Mon, 01 December 2008 13:17]

Report message to a moderator

Previous Topic: ORACLE V$SQL issue ....
Next Topic: Createing index
Goto Forum:
  


Current Time: Tue Dec 06 04:28:20 CST 2016

Total time taken to generate the page: 0.18905 seconds