Skip to main content
12-Amethyst
July 19, 2024
Solved

how run dbDiag in windchill

  • July 19, 2024
  • 1 reply
  • 865 views

the file path is  D:\ptc\Windchill_10.2\Windchill\utilities\dbDiag\PerformanceDiag_Oracle.sql

 

I want to improve the performance of Oracle in Windhill applications

Best answer by avillanueva

Do you have a SQL tool like Toad or SQL Developer? You can copy that scripts to your machine and run it in those tools.  Otherwise, you would have to connect via an Oracle client through sqlplus to run that scripts. Either way, you need DB access to run that. 

1 reply

avillanueva
23-Emerald I
23-Emerald I
July 20, 2024

Do you have a SQL tool like Toad or SQL Developer? You can copy that scripts to your machine and run it in those tools.  Otherwise, you would have to connect via an Oracle client through sqlplus to run that scripts. Either way, you need DB access to run that. 

12-Amethyst
July 20, 2024
ths