topic Re: gather_table_stats from Oracle in SAS in SAS Programming

gather_table_stats from Oracle in SAS

GeorgeSAS — Tue, 04 Jun 2019 19:08:09 GMT

Hello everyone,

After I submited sql in SAS to created table in Oracle I want to check table status,I find the code below using dbms_stats.gather_table_stats:

proc sql;
&connectToOracle;
execute by oracle (
begin
dbms_stats.gather_table_stats('user', 'mytable', degree => 15);
end;);

In this code, where/what is the output table I can find the table's information?

Thanks!

Re: gather_table_stats from Oracle in SAS

ChrisNZ — Tue, 04 Jun 2019 21:44:52 GMT

1. I reckon this question would be best answered in an Oracle forum

2. My understanding is that the results of gather_table_stats are used by Oracle to optimise queries by using the information collected rather than for human consumption.

Re: gather_table_stats from Oracle in SAS

Tom — Tue, 04 Jun 2019 21:54:26 GMT

That doesn't look like the type of command that would actually return anything, but perhaps you can try using the TABLE() function to convert what it does return into something that looks like a table you can query?

select * from connection to oracle 
(
select * from table(  dbms_stats.gather_table_stats('user', 'mytable', degree => 15)  )
);