Database Administration (MOSC)

MOSC Banner

To know all sql ran on database between time t1 and t2

edited Feb 22, 2009 5:18PM in Database Administration (MOSC) 3 commentsAnswered
 Hi all,  A quick question. What are different ways to have list of all the sql (select/insert/update/delete) which ran on the database in a time range from t1 to t2. Idea is run a GUI screen and see what are the commands being fired on the database (any performance stats along with it be a bonus).

Logminer could be one way, but I am trying to find some views/queries or traces enabling to get this data. Ideas?

thanks in advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center