https://communities.sas.com/t5/New-SAS-User/slowness-in-listing-down-tables-from-oracle-library-SAS-Viya-3-4/m-p/526307#M5076 <P>Its not about the code, I have created a data library in CAS. But i couldn't view the tables under that schema.</P> <P>(NOTE: That specific schema has more than 60,000 tables&lt;sixty thousand&gt;).</P> <P>&nbsp;</P> <P>is it possible that can we see this much table in SAS Using SAS/Access engine?</P> Fri, 11 Jan 2019 08:44:52 GMT jpraveen25 2019-01-11T08:44:52Z https://communities.sas.com/t5/New-SAS-User/slowness-in-listing-down-tables-from-oracle-library-SAS-Viya-3-4/m-p/525333#M4936 <P>We are facing a slowness in listing down the tables from oracle library using both SAS Environment Manager and SAS Visual Analytics (SAS Viya Environment).</P> <P>&nbsp;</P> <P>We have tried to access oracle library using LIBNAME statement and we were able to access the same but it took quite long time to list all the table after assigning the library (there are nearly 3500 tables).</P> <P>The Oracle library was created successfully (Customer is licensed for SAS/ACCESS to Oracle), but when we try to check/list the tables from the library, the page from browser is unresponsive (Below screens are unresponsive). It seems like SAS/ACCESS engine</P> <P>&nbsp;</P> <P>kindly assist me to sort the issue.</P> Tue, 08 Jan 2019 06:37:46 GMT https://communities.sas.com/t5/New-SAS-User/slowness-in-listing-down-tables-from-oracle-library-SAS-Viya-3-4/m-p/525333#M4936 jpraveen25 2019-01-08T06:37:46Z https://communities.sas.com/t5/New-SAS-User/slowness-in-listing-down-tables-from-oracle-library-SAS-Viya-3-4/m-p/525615#M4995 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/180482">@jpraveen25</a>&nbsp;wrote:<BR /> <P>We are facing a slowness in listing down the tables from oracle library using both SAS Environment Manager and SAS Visual Analytics (SAS Viya Environment).</P> <P>&nbsp;</P> <P>We have tried to access oracle library using LIBNAME statement and we were able to access the same but it took quite long time to list all the table after assigning the library (there are nearly 3500 tables).</P> <P>The Oracle library was created successfully (Customer is licensed for SAS/ACCESS to Oracle), but when we try to check/list the tables from the library, the page from browser is unresponsive (Below screens are unresponsive). It seems like SAS/ACCESS engine</P> <P>&nbsp;</P> <P>kindly assist me to sort the issue.</P> <HR /></BLOCKQUOTE> <P>Can you show the code or describe exactly how you tried to check or list the tables?</P> <P>I can't help with Viya or Oracle but do know that different approaches often take different amounts of time and someone else with more specific knowledge may find that helpful.</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 08 Jan 2019 23:47:37 GMT https://communities.sas.com/t5/New-SAS-User/slowness-in-listing-down-tables-from-oracle-library-SAS-Viya-3-4/m-p/525615#M4995 ballardw 2019-01-08T23:47:37Z https://communities.sas.com/t5/New-SAS-User/slowness-in-listing-down-tables-from-oracle-library-SAS-Viya-3-4/m-p/526307#M5076 <P>Its not about the code, I have created a data library in CAS. But i couldn't view the tables under that schema.</P> <P>(NOTE: That specific schema has more than 60,000 tables&lt;sixty thousand&gt;).</P> <P>&nbsp;</P> <P>is it possible that can we see this much table in SAS Using SAS/Access engine?</P> Fri, 11 Jan 2019 08:44:52 GMT https://communities.sas.com/t5/New-SAS-User/slowness-in-listing-down-tables-from-oracle-library-SAS-Viya-3-4/m-p/526307#M5076 jpraveen25 2019-01-11T08:44:52Z