Re: svrmgrl/sqlplus long connection time before to get the prompt on HP-UX 10.01

On Thu, 06 Aug 1998 16:11:16 +0200, Torsten Borchert <T.Borchert_at_DeutschePost.de> wrote:

>Hi,
>
>it looks like Oracle Trace in 7.3 On Installation of Oracle it is
>automaticly enabled.
>In $ORACLE_HOME/otrace/admin are files *.dat. They are large, and will
>be larger after every connect. Oracle scans these files on startup off
>svrmgrl or sqlplus.(You 'll see it whith "truss svrmgrl "
>Do the following:
>shutdown your instance
>drop all files *.dat
>in your .profile:
>EPC_DISABLE=TRUE
>export EPC_DISABLE
>
>That's all.
>
>Jean-Francois Vincent wrote:
>>
>> Hello, i've got a problem of response time on a HP-UX 10.01 system,
>> when i start svrmgrl or sqlplus i wait several seconds before having the
>> prompt SVRMGRL. Please, what's could be wrong ?
>>
>> thank you.
>> J-Fr.

As a first workaround, using the above mentioned EPC_DISABLE is all you have to do. Shutdown of instances and deleting these files is not required.

If you want to get some disk space back you probably want to delete the *.dat files, or at least bring them to their default size.

Only for this you have to shutdown your Oracle instance.

By the way, these *.dat files are not instance-wide, but product-wide files.

Assume you have installed a couple of Oracle 7.3.3 Instances and a couple of Oracle 7.3.4 instances on the same server.

All instances of the same version uses the *.dat files on Oracle-product directory. So, if you want to delete them, you have to shutdown all Oracle instances of the same Oracle version.

Silvio Seifert
Foehrer Strasse 34
65199 Wiesbaden
Germany Received on Sun Aug 09 1998 - 09:50:05 CDT