Skip to main content
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

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

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. 

Jul 20, 2024 10:46 PM UTC
ths