ITPub博客

To control data of a database, access routes are important concern.Frequently used access routes are:SQL*Net application server(application data access component name and ap server ip)SQL*Net other to...

execute dbms_stats.gather_table_stats(ownname => 'owner',tabname => 'table_name' ,estimate_percent => null ,method_opt => 'for all indexed columns' ,cascade => true);