Re: How to get SQL commands executed on Oracle database in certain period?
From: <qazmlp1209_at_rediffmail.com>
Date: 6 Oct 2006 03:59:38 -0700
Message-ID: <1160132378.760656.242570_at_e3g2000cwe.googlegroups.com>
Date: 6 Oct 2006 03:59:38 -0700
Message-ID: <1160132378.760656.242570_at_e3g2000cwe.googlegroups.com>
DA Morgan wrote:
> If you look at gv$sql you will see a column named LAST_ACTIVE_TIME.
> That will give you the last time executed. The command, itself, can
> be found in the SQL_FULLTEXT column.
>
> As you didn't supply version or other related information this may,
> or may not, work for you.
Thanks, it helped!
I use the following Oracle version:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bi
I used the following command to check the SQL commands executed in the
Oracle Database:
SQL> select SQL_FULLTEXT, LAST_LOAD_TIME from gv$sql where
LAST_LOAD_TIME is not null order by LAST_LOAD_TIME ASC;
Received on Fri Oct 06 2006 - 12:59:38 CEST