gather_table_stats from Oracle in SAS

[GeorgeSAS]

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!

[ChrisNZ]

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.

[Tom]

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)  )
);