Home » RDBMS Server » Server Administration » Transaction conducted in the last n min or m sec. in oracle
Transaction conducted in the last n min or m sec. in oracle [message #370782] Mon, 07 February 2000 09:33 Go to next message
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.
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 Go to previous message
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
Previous Topic: Re: Interview
Next Topic: Finding the sql statements executed in a session
Goto Forum:
  


Current Time: Sat Oct 24 04:22:47 CDT 2020