Re: 8i: Identified externally and autotrace?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 03 Feb 2000 14:32:18 -0500
Message-ID: <eqlj9sochho72sht4mnhpfued3d52ru42a@4ax.com>

A copy of this was sent to "Lothar Armbüster" <lothar.armbruester_at_rheingau.netsurf.de> (if that email address didn't require changing) On 3 Feb 2000 14:29:7 +0100, you wrote:

>Hello out there,
>
>it seems that autotrace in SQL*Plus does not work for externally
>identified users.
>When I connect with 'sqlplus /' and then issue
>
>set autotrace on
>
>I get
>
>SP2-0619: Fehler bei DB-Anmeldung
>SP2-0611: Fehler beim Initialisieren von STATISTICS - Bericht
>
>The system is Oracle 8.1.5.0.1 on Linux.
>
>Any Ideas?
>
>Lothar

that is correct -- its a bug fixed in 8.1.6. You can get the explain plan but not the v$ stats.

It also won't work if you change your password in a session BEFORE you issue set autotrace (also fixed in 8.1.6)

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Feb 03 2000 - 13:32:18 CST