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@xxxxxxxxx>
wrote:
I have one instance of Oracle 19.9 (EE) on Linux x86_64 where oratop
exhibits some strange behaviour:
[oracle@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@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
--
//www.freelists.org/webpage/oracle-l
