Re: Readout Shared Cursor Cache within Oracle

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 29 Oct 2002 16:08:01 -0000
Message-ID: <3dbeb261$0$8508$ed9e5944@reading.news.pipex.net>

look at the v$sqlarea view.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"ecki" <eckard.biskup_at_gmx.de> wrote in message
news:60600e9b.0210290804.d40fcad_at_posting.google.com...


> Hi all,

>

> how is it possible to readout the Oracle Shared Cursor Cache (Oracle

> 8.1.7.4, UNIX) to identify especially SQL statements for No-Logging

> DDL's?

>

> Eckard

Received on Tue Oct 29 2002 - 10:08:01 CST