Database Tuning (MOSC)

MOSC Banner

Sqlt9i is reporting NumRows=0 - when table has statistics

edited Apr 20, 2011 11:08PM in Database Tuning (MOSC) 13 commentsAnswered ✓
 Sqlt9i is reporting NumRows=0 - when table has statistics run by

spool /export/home/oracle/dba/logs/analyze_schemas.log
execute dbms_stats.gather_schema_stats(ownname=>'VA',cascade=>true);
execute dbms_stats.gather_schema_stats(ownname=>'ODS',cascade=>true);
execute dbms_stats.gather_schema_stats(ownname=>'DM',cascade=>true);

SQL> select last_analyzed from dba_tables where table_name='STG_MOVE_PHYSICAL_DEVICE';

LAST_ANAL
---------
09-APR-11

SQL>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center