Re: Frequent Queries

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 19 Jan 2007 13:44:34 -0800
Message-ID: <1169243073.978821.194000@11g2000cwr.googlegroups.com>

ExecMan wrote:
> Hi,
>
> Is there a way to somehow record what the most frequent running queries
> are in your database? We want to know what our most frequently used
> queries are............
>
> Thank you.

Hi,

desc v$sql

Depending on your version of Oracle and your license, look into DBA_HIST_SQLSTAT (if on 10.x), or whatever the corresponding table name is in STASPACK if you are on less than 10.x.

HTH, Steve Received on Fri Jan 19 2007 - 15:44:34 CST