Re: column session_info appear empty on logminer

if i remember correctly(from a presentation i did like 3 years ago), its a bug.

joe

Mauricio Vélez wrote:

> Hello everybody
>
> I normally have no problems with logminer.
> The database es oracle 8.1.7.4.1 on Windows NT
>
> but in this case the results show me the username and session_info
> columns empty
>
> Here is the output:
> (First I created log_detalle_giros_20040124 as select * from
> v$logmnr_contents where seg_name = 'GIROS')
>
> SQL> select username,
> 2 to_char(timestamp, 'dd/mm/yyyy hh24:mi:ss'),
> 3 sql_redo,
> 4 session_info
> 5 from log_detalle_giros_20040124
> 6 where sql_redo like '%3420653%';
>
>
> USERNAME TO_CHAR(TIMESTAMP,' SQL_REDO SESSION_INFO
> -------- ------------------- ------------------------------ ------------
> 24/01/2004 11:48:47 update "LCA"."GIROS" set "CONS
> ECUTIVO" = -3420653, "REMITENT
> E" = 'AMINTA CAMACHO ROJAS', "
> BENEFICIARIO" = 'ELVIA ROJAS D
> E CAMACHO', "SECUENCIA" = 9304
> 38, "NUMERO_ORDEN" = '00930438
> ', "CODIGO_CORRESPONSAL" = '00
> 55', "CODIGO_CIUDAD" = '0004',
> &nb! sp; "FECHA" = TO_DATE('23-ENE-200
> 4 10:24:07', 'DD-MON-YYYY HH24
> :MI:SS'), "CODIGO_MONEDAR" = '
> 0012', "CODIGO_MONEDAE" = '000
> 2', "VALORR" = 852,44, "VALORE
> " = 2299781, "TASA_DE_CAMBIO"
> = 2697,88, "MENSAJE" = 'AUTORI
> ZADO EL PAGO CON UN NOMBRE', "
> CLAVE" = NULL, "TELEFONO1" = '
> &nbs! p; 4118035', "TELEFONO2" = NULL,
> "PAGADO" = 'S', "ACTUALIZADO"
> = 'N', "ACTIVADO" = 'S', "OBSE
> RVACIONES" = 'SE AUT PAG//NO S
> AVE MONT/ES CLTE 18 OPER Y CON
> F REMIT Y TLF SEG OF/JM.R.', "
> INVESTIGACION" = 'N' where ROW
> ID = 'AAAGHoAAOAACviHAAG';
> So why do those columns appear empty on v$logmnr_contents?
>
> Thanks
> Mauricio Vélez
> Oracle DBA
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. *Try it!*
> <http://us.rd.yahoo.com/evt=21608/*http://webhosting.yahoo.com/ps/sb/>

-- 
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the "CACHE"


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).