Re: oratop

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> 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