Thanks Please why is my last_analyzed query giving 0 rows selected. i just gather table stats. SQL> select last_analyzed from dba_tables where table_name='dept11' 2 ; no rows selected SQL> EXEC DBMS_STATS.gather_table_stats('ggtraining1', 'dept11') PL/SQL procedure successfully completed. SQL> select last_analyzed from dba_tables where table_name='dept11' 2 ; no rows selected
Thanks a lot for his very clear and valuable explanation. Would it be possible to have the slides you've used for it?. Thanks
Nice Presentation.
Yes it's helpful👍👍👍
Thanks
Please why is my last_analyzed query giving 0 rows selected. i just gather table stats.
SQL> select last_analyzed from dba_tables where table_name='dept11'
2 ;
no rows selected
SQL> EXEC DBMS_STATS.gather_table_stats('ggtraining1', 'dept11')
PL/SQL procedure successfully completed.
SQL> select last_analyzed from dba_tables where table_name='dept11'
2 ;
no rows selected
Same here how u solved?
Very bad explanation,just repeating the ppt. Nothing more
Great video, but you should stop underlining randomly. It confused more than it helped - at least for me.
such a poor explanation, just reading the slide twice...and that too no reading it correctly
:)))
dont just read the slide