Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: timed_statistics = true and db "hangs"
"sven" <tiestes_at_arcor.de> wrote in message
news:3f634d87$0$23104$9b4e6d93_at_newsread2.arcor-online.net...
> Hello,
>
> the maintennance and performance tuning of a db seems difficult without
> the timed_statistics parameter. So, after installing statspack I set
> it true (alter system set timed_statistics=true). Only a few seconds
> later telephone rings and user told me they could not connect to the
> db. So I tried to connect first from the console with sqlplus and then
> with the dbastudio both worked well. They could not connect until
> bouncing the db and resetting of the parameter.
> What's going wrong?
> It is a 8.1.7.4 with compatible-parameter set to 8.1.6 on a AIX 4.3....
> The application the used by the users is called unilab4.0.
> It is written with Powerbuilder.
> I found some docs at metalink about problems with timed_statistics but
> they should all resolved in 8.1.7.
> Any experience with this?
> Thanks for thinking about and gretting from sunny germany.
> Sven
There were problems regarding library cache / shared pool latches and not reusing reusable sql when setting timed statistics to true (8.1.5.0.0, AIX), but we never encountered such problem after moving from that version.
Regards... Received on Tue Sep 16 2003 - 10:13:17 CDT