Forum Stats

  • 3,872,914 Users
  • 2,266,489 Discussions


Cannot get explain plan in tkprof trace file for a pluggable database

Laury Member Posts: 1,672 Silver Badge


I am working with an Oracle 19c container database.

If I attenpt with tkprof to generate a readable trace file fro an existing file, I get this error:

-- TNS for PDB: MARKTT01

tkprof ASGARD_ora_11327.trc TKPROF_2_ASGARD_ora_11327.trc [email protected] as sysdba

I get this:


TKPROF: Release - Development on Sat Sep 17 15:25:06 2022

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

password =


If I provide the password, the trace file is creted, but inside it I find this ORA- error:


error connecting to database using: sysdba

ORA-01017: invalid username/password; logon denied


Does someone know how to get the explain plan with tkprof for a pluggable database?

Kind Regards