I use SAS 9.3 pass-through to send SQL to an Oracle 10g database to read data from a view. Usually the query runs just fine. Sometimes the query runs extremely slow. Are there SAS options that I can turn on to try to understand what the issue is? (Note: I don't believe it is the load on the server nor running during a database maintenance window). Thanks. Type of query shown below: proc sql noprint; connect to oracle as myconn (user=x password=y path=z); create table test as select * from connection to myconn( select * from T.V where my_condition = 'TRUE'); disconnect from myconn; quit; ... View more