Oracle with Hammerdb, test results TPM is 0

[springeee]

Hi all:
I use Hammerdb test Oracle , my step as follows:
1, install Oracle 19c on Linux
2, create tablespace tpcctab and user
SQL> create bigfile tablespace tpcctab datafile '/mnt/dp32t/tpcctab.dbf' size 180g;

SQL> create user tpcc identified by tpcc default tablespace tpcctab;
3, open Hammerdb, Schema Build

4, Driver Options

5, Virtual User Options

6, run

7, output

from the output we can see the Oracle TPM is 0.
I don't know why.

Please help to give me some advices?
Thanks.

[sm-shaw]

Hi,
From the instance name it looks like you are using a testing a pluggable database? If so this is a known issue recorded in this issue here: "Oracle 12.2 multitenant" #13. Oracle changed some of the view names in 12.2 that broke backward compatibility with some of the queries that previously worked against pluggable databases TPM being one of them. It should be possible to provide the system connection to the CDB and get the same statistics that were available previously. NOPM is extracted from the schema so is not affected by the view name changes.
Steve

[springeee]

Hi Steve:

Thanks for your reply.
now use CDB , the TPM result is ok.

Thanks.