Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: alter user <name> identified by statement truncated in trace file
> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 28 2006 - 14:53:21 CDT
![]() |
![]() |