OraFAQ Forum: Server Administration » Transaction conducted in the last n min or m sec. in oracle

Home » RDBMS Server » Server Administration » Transaction conducted in the last n min or m sec. in oracle

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

Transaction conducted in the last n min or m sec. in oracle [message #370782]

Mon, 07 February 2000 09:33

vimal
Messages: 46
Registered: February 2000

Member

I want the SQL to list the transactions that occurred in the last, say 5 min.

thank you.

Report message to a moderator

Re: Transaction conducted in the last n min or m sec. in oracle [message #370784 is a reply to message #370782]

Mon, 07 February 2000 20:07

Paul
Messages: 164
Registered: April 1999

Senior Member

Vimal,
For transactions in the last 5 minutes, just substitute your column names and table name in the SQL below:

SELECT whatever
FROM your_table
WHERE tran_date >= SYSDATE - (5/1440);

if you want smaller intervals, use this - substituting the number of seconds you want for n

SELECT whatever
FROM your_table
WHERE tran_date >= SYSDATE - (n/86400);

Regards,
Paul

Report message to a moderator

Previous Topic:	Re: Interview
Next Topic:	Finding the sql statements executed in a session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:36:48 CDT 2024