Re: oratop

Thanks Franck!

I have indeed set statistics level to ALL in one of the PDB's because I needed estimated rows/actual rows in the explain plan. I will see whether resetting it back to default will help. However, the bug you mentioned doesn't seem to be a published one.

Regards

On 11/14/20 10:40 AM, Franck Pachot wrote:
> Hi, this is a bug when a parameter is defined at PDB level and then
> shows two rows in V$SYSTEM_PARAMETER
> https://twitter.com/FranckPachot/status/1284517133867716608
> <https://twitter.com/FranckPachot/status/1284517133867716608>
> Bug 31843564
> <https://support.oracle.com/epmos/faces/BugDisplay?id=31843564&parent=SrDetailText&sourceId=3-23599918151> -
> ORATOP FAILS (ORA-01422) IN MULTITENANT WHEN STATISTICS_LEVEL IS
> MODIFIED IN A PDB
> (bug opened last month)
> Franck
>
> On Sat, Nov 14, 2020 at 5:03 AM Mladen Gogala <gogala.mladen_at_gmail.com
> <mailto:gogala.mladen_at_gmail.com>> wrote:
>
> I have one instance of Oracle 19.9 (EE) on Linux x86_64 where oratop
> exhibits some strange behaviour:
>
> [oracle_at_callisto ~]$ oratop -s -f / as sysdba
>
> oratop: Release 15.0.0 Production on Sat Nov 14 00:25:39 2020
> Copyright (c) 2011, Oracle.  All rights reserved.
>
>
>
> Connecting ..
>
> ORA-01422: exact fetch returns more than requested number of rows
>
> [oracle_at_callisto ~]$
>
> Any ideas? I'll trap the error the next week and get the exact
> statement
> that causes this, but has anyone seen this before?
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
> <http://www.freelists.org/webpage/oracle-l>
>
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l