cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

how run dbDiag in windchill

TB_10966080
11-Garnet

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

ACCEPTED SOLUTION

Accepted Solutions
avillanueva
22-Sapphire II
(To:TB_10966080)

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. 

View solution in original post

2 REPLIES 2
avillanueva
22-Sapphire II
(To:TB_10966080)

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. 

ths
Announcements


Top Tags