Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!198.186.194.247.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!q69g2000hsb.googlegroups.com!not-for-mail From: "fitzjarrell@cox.net" Newsgroups: comp.databases.oracle.server Subject: Re: ALTER USER and the sql cache Date: Wed, 06 Jun 2007 06:04:00 -0700 Organization: http://groups.google.com Lines: 15 Message-ID: <1181135040.315525.181010@q69g2000hsb.googlegroups.com> References: <1181129080.580912.80670@o5g2000hsb.googlegroups.com> NNTP-Posting-Host: 138.32.32.166 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Trace: posting.google.com 1181135041 19797 127.0.0.1 (6 Jun 2007 13:04:01 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 6 Jun 2007 13:04:01 +0000 (UTC) In-Reply-To: <1181129080.580912.80670@o5g2000hsb.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: q69g2000hsb.googlegroups.com; posting-host=138.32.32.166; posting-account=B_KC8Q0AAADcSTVy4DZ59utFaLrVLOo4 Xref: news.f.de.plusline.net comp.databases.oracle.server:199012 On Jun 6, 6:24 am, matthias.h...@gmail.com wrote: > Oracle 10.2.0.3 on Linux. > > When I issue a statement like 'ALTER USER scott IDENTIFIED BY newpwd', > I can't fnd the query in the shared pool query cache (v$sql). Is there > a security mechanism in place which protects against caching these > kind of queries ? > > Matthias ALTER statements aren't DML, they're DDL and aren't found in V$SQL. David Fitzjarrell