oratop RAC下直接可用

/opt/oracle.ahf/tfa/bin/tfactl.pl oratop -database XXX

Applies to:

Oracle Database - Enterprise Edition - Version 19.17.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Oracle database has 8 instances, but oratop only shows 5 instances. 

$ tfactl version
TFA Version : 238000
TFA Build ID : 20230830021106

$ srvctl status database -d <db_name>
Instance <db_name1> is running on node <host_name>
Instance <db_name2> is running on node <host_name>
Instance <db_name3> is running on node <host_name>
Instance <db_name4> is running on node <host_name>
Instance <db_name5> is running on node <host_name>
Instance <db_name6> is running on node <host_name>
Instance <db_name7> is running on node <host_name>
Instance <db_name8> is running on node <host_name>

$ /opt/oracle.ahf/tfa/bin/tfactl.pl oratop -database <db_name>
oratop: Release 16.5.1 Production on Thu Oct 26 15:07:10 CST 2023
Copyright (c) 2011, Oracle. All rights reserved.
Oracle 19c - 15:07:20 Primary r/w RATE up: 105d, 42k sn, 8 ins, 4 pdb, 26 er, 73T sz, 500G sga, 0%fra, archivelog 13.1%db
ID CPU %CPU LOAD AAS ASC ASI ASW ISW REDO TEMP IORT MBPS IOPS R/S W/S LIO GCPS %FRE PGA NETV UTPS UCPS SQRT %DBC %DBW
1 128 40.7 40.0 30.6 2 1 10 4.9k 157M 0 393u 7k 30k 6.8k 23k 1.9M 140k 70.3 2.4G 19M 3.8k 11k 2.0m 13.6 10.3
2 128 23.2 24.8 22.0 3 0 4 13k 116M 0 362u 946 14k 914 13k 1.1M 110k 65.5 853M 14M 3.6k 11k 1.3m 10 7
6 128 8.6 9.8 0.2 0 0 0 2 758 0 78u 0.5 17.3 8.3 9 444 0 92.7 3.6G 37.5 0 48.3 78u 0.1 0
7 128 22.9 27.6 0.2 0 0 0 2 870 0 3u 0.2 17.3 6.9 10.4 398 0 92.7 627M 28.1 0 43.1 753u 0.2 0
8 128 18 24.0 0.2 0 0 0 4 757 0 81u 118 137 128 9.0 401 0 92.5 3.3G 36.9 0 36.6 753u 0.1 0

Changes

 Install the latest AHF and run oratop.

Cause

Currently, the number of instances that can be listed dynamically by oratop is limited to 5. 

Solution

To see all instances , please run oratop in batch mode with -bn option.

$ /opt/oracle.ahf/tfa/bin/tfactl.pl oratop -database <db_name> -bn3

oratop: Release 16.5.1 Production on Tue Oct 31 11:42:40 CST 2023

Copyright (c) 2011, Oracle. All rights reserved.

Connecting
Cycle 1 - oratop: Release 16.5.1 Production on Tue Oct 31 11:42:43 CST 2023

Oracle 19c - 11:42:22 Pri r/w RATE up: 110d, 41k sn, 500G sga, 0%fra, 2%db
ID %CPU LOAD AAS ASC ASI ASW ISW IORT MBPS %FRE PGA UCPS SQRT %DBC %DBW
-------------------------------------------------------------------------------
1 14 16 4 2 0 9 5k 187u 9k 76 3G 3k 692u 3 0
2 19 23 12 11 0 13 14k 135u 3k 67 463M 8k 1m 9 0
3 10 13 5 5 2 2 16k 172u 167 67 1G 9k 421u 4 0
4 7 8 2 1 0 3 7k 140u 12 71 1G 4k 279u 2 0
5 13 16 0 0 0 0 160 545u 0 91 4G 94 479u 0 0
6 13 20 0 0 0 0 4 41u 4 93 4G 42 768u 0 0
7 20 25 0 0 0 0 3 1m 0 93 658M 39 71u 0 0
8 26 38 0 0 0 0 2 0 1 93 3G 45 669u 0 0

EVENT (C) T/O WAIT TIME AVG %DBT WAIT_CLASS
-------------------------------------------------------------------------------
DB CPU 8y 57
Backup: MML write backup piece 29G 2y 2m 13 Administrativ
gc current block 2-way 302G 259d 100u 5 Cluster
DLM cross inst call completion 11G 22G 187d 2m 4 Other
enq: TX - index contention 18G 138d 462u 3 Concurrency