topic Re: How to check oracle sessions from SAS in Administration and Deployment

How to check oracle sessions from SAS

Prab — Tue, 24 May 2016 06:10:03 GMT

HI All,

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.

Thanks,

Prab

Re: How to check oracle sessions from SAS

carlosmirandad — Tue, 24 May 2016 15:24:17 GMT

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;