05-24-2016 02:10 AM
Is there any way to find oracle sessions from SAS by executing PROC SQL connect TO statement.
I would like to see whether oracle DB is having healthy sessions, SO that I can ensure no performance issue from Oracle DB when I execute ay SQL statements from SAS.
05-24-2016 11:24 AM
This is one way to test. When everything is working OK, I get a table with a dummy variable, no errors.
proc sql; connect to oracle as ora(user=&your_oracle_user. password=&your_oracle_pass. path="@your_path"); create table test as select * from connection to ora ( select * from dual ); disconnect from ora; quit;