OraFAQ Forum: Performance Tuning » how to find list of sql statements ran in the past time.

Home » RDBMS Server » Performance Tuning » how to find list of sql statements ran in the past time. (oracle 10.2.0.3)

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

how to find list of sql statements ran in the past time. [message #362293]

Mon, 01 December 2008 13:09

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

Report message to a moderator