Is v$sqlarea a view that stored all sql that are being cached in
shared pool? If not, where can I find such information? Thanks.

On May 29, 8:30 pm, Susan <susan... (AT) hotmail (DOT) com> wrote:
http://www.oracle.com/pls/db102/sear...qlarea&partno=

The first link returned by the search engine is this page:
http://download-east.oracle.com/docs...views_2129.htm

At the top of that page is the following "V$SQLAREA lists statistics
on shared SQL area and contains one row per SQL string. It provides
statistics on SQL statements that are in memory, parsed, and ready for
execution."

Another interesting link is this one, which provides quick access to
the many V$ views, among other things:
http://download-east.oracle.com/docs...4237/index.htm

The Instance Tuning portion of the Oracle 10g R2 Performance Tuning
Guide makes several references to the V$SQLAREA view:
http://download-east.oracle.com/docs...tance_tune.htm

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.