BookmarkSubscribeRSS Feed
Prab
Calcite | Level 5

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

1 REPLY 1
carlosmirandad
Obsidian | Level 7

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;

 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1187 views
  • 0 likes
  • 2 in conversation