Re: ALTER USER and the sql cache

On Jun 6, 6:24 am, matthias.h..._at_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 Received on Wed Jun 06 2007 - 08:04:00 CDT