Skip to main content
12-Amethyst
Jul 19, 2024 1:52 AM UTC
Solved

how run dbDiag in windchill

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

avillanueva
23-Emerald II
Jul 20, 2024 8:12 PM UTC

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. 

2 replies

avillanueva
23-Emerald II
Jul 20, 2024 8:12 PM UTC

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. 

Translate
12-Amethyst
Jul 20, 2024 10:46 PM UTC
ths
Translate