Re: How do I find out what the insert rate is using a simple query statement?

Hi,

What about

  1 select sql_text, EXECUTIONS
  2 from v$sqlarea
  3* order by 2

If you know the SQL that your are looking for this might work, I wouldn't go flushing the pool or anything though :)

J

chin-sim.kang_at_hp.com (Chin-Sim Kang) wrote in message news:<3f358152.0205231127.3f48677d_at_posting.google.com>...

> How do I find out what the insert rate is? Would it be captured in
> one of the
> v$ tables?
Received on Fri May 24 2002 - 05:47:06 CDT