When passing method_opt as 'FOR ALL COLUMNS SIZE 1', it means no histogram is collected for columns on the table(s). exec dbms_stats.gather_schema_stats('SCOTT', method_opt=>'FOR ALL COLUMNS SIZE 1'); One can find the default value by executing as follows: select DBMS_STATS.GET_PARAM('METHOD_OPT') from dual;
Tag: without
How to pass host, port, SID/Service name to connect to a database?
Using the following command one can pass hostname, port, servicename and SID and connect to a database without having an entry in tnsnames.ora $ sqlplus username/password@hostname:port/SERVICENAME OR $ sqlplus username Enter password: password@//hostname:port/SERVICENAME OR $ sqlplus /nolog SQL> connect username/password@hostname:port/SERVICENAME
alexlima.com 