|
Home > Archive > Oracle Server > July 2005 > TIMED_STATISTICS and Oracle 8.1.5
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
TIMED_STATISTICS and Oracle 8.1.5
|
|
| Andreas Sheriff 2005-07-28, 3:23 am |
| Ok,
I want to hear some horror stories about using the TIMED_STATISTICS
parameter in 8.1.5 (unpatched).
I've found some interesting nightmares on the web, but I want to get
everyone's experiences here.
Please also specify your platform/operating system and *exact* version of
the RDBMS.
You can also talk about 8.1.6 and 8.1.7 as well.
I don't have access to metalink, but I can bet there are some interesting
stories there.
--
Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"
DO NOT REPLY TO THIS EMAIL
Reply only to the group.
| |
| Sybrand Bakker 2005-07-28, 3:23 am |
| On Wed, 27 Jul 2005 21:33:20 -0700, "Andreas Sheriff"
<spamcontrol@iion.com> wrote:
>Ok,
>
>I want to hear some horror stories about using the TIMED_STATISTICS
>parameter in 8.1.5 (unpatched).
>I've found some interesting nightmares on the web, but I want to get
>everyone's experiences here.
IMO the fairy tales you want to hear don't exist. I have never seen
any problem.
--
Sybrand Bakker, Senior Oracle DBA
| |
| DA Morgan 2005-07-28, 3:23 am |
| Andreas Sheriff wrote:
> Ok,
>
> I want to hear some horror stories about using the TIMED_STATISTICS
> parameter in 8.1.5 (unpatched).
> I've found some interesting nightmares on the web, but I want to get
> everyone's experiences here.
>
> Please also specify your platform/operating system and *exact* version of
> the RDBMS.
>
> You can also talk about 8.1.6 and 8.1.7 as well.
>
> I don't have access to metalink, but I can bet there are some interesting
> stories there.
The only horror story to be had is you are on a version of Oracle that
has not been supported during the current millenium.
8.1.6 should be avoided like the plague.
8.1.7.4 is decent though also totally unsupported.
Are you working toward a resume that will leave you near unemployable?
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
| |
|
| DA Morgan apparently said,on my timestamp of 28/07/2005 6:10 PM:
>
> The only horror story to be had is you are on a version of Oracle that
> has not been supported during the current millenium.
Hehehe! Bingo!
--
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k@yahoo.com.au.nospam
| |
|
|
"Andreas Sheriff" <spamcontrol@iion.com> wrote in message
news:AeZFe.27020$bp.18977@fed1read03...
> Ok,
>
> I want to hear some horror stories about using the TIMED_STATISTICS
> parameter in 8.1.5 (unpatched).
> I've found some interesting nightmares on the web, but I want to get
> everyone's experiences here.
>
> Please also specify your platform/operating system and *exact* version of
> the RDBMS.
>
> You can also talk about 8.1.6 and 8.1.7 as well.
>
> I don't have access to metalink, but I can bet there are some interesting
> stories there.
> --
>
There was a problem that sql was not reused if timed_statistics was set to
true. We encountered this long time ago with 81500 on aix 433.
Regards..
| |
| Anurag Varma 2005-07-29, 3:23 am |
| Andreas Sheriff wrote:
> Ok,
>
> I want to hear some horror stories about using the TIMED_STATISTICS
> parameter in 8.1.5 (unpatched).
> I've found some interesting nightmares on the web, but I want to get
> everyone's experiences here.
>
> Please also specify your platform/operating system and *exact* version of
> the RDBMS.
>
> You can also talk about 8.1.6 and 8.1.7 as well.
>
> I don't have access to metalink, but I can bet there are some interesting
> stories there.
There are multiple bugs related to turning on timed_statistics and/or sql_trace
in 8.1.5. and 8.1.6. Bugs like non-sharable sql, parallel query CTAS and table corruption
and various ORA-600 errors have been reported.
Steve Adams mentions couple such bugs here: http://www.ixora.com.au/q+a/library.htm
I guess you probably already know that 8.1.5 was one of the buggiest versions of oracle.
Anurag
|
|
|
|
|