Re: alter user <name> identified by statement truncated in trace file

  • From: "Egor Starostin" <egorst@xxxxxxxxx>
  • To: peter.schauss@xxxxxxx
  • Date: Wed, 28 Jun 2006 23:53:21 +0400

While trying to determine what command a third party application is
using to change users' passwords I discovered that the ALTER USER <name>
IDENTIFIED BY statement is getting truncated when written to a trace
file.  For example

=====================
PARSING IN CURSOR #3 len=38 dep=0 uid=31 oct=43 lid=31 tim=0
hv=2271055062 ad='3
25aafc0'
alter user test identifie
END OF STMT
PARSE #3:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=0
XCTEND rlbk=0, rd_only=1
=====================

Is this a bug or a feature? 
It's a feature documented in 'Performance Tuning Guide':
***
Statement Truncation in SQL Trace
The following SQL statements are truncated to 25 characters in the SQL
Trace file:

SET ROLE
GRANT
ALTER USER
ALTER ROLE
CREATE USER
CREATE ROLE
***


--
Egor
http://www.oracledba.ru
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2006