You must own the object to be analyzed or have the ANALYZE ANY privilege to issue this command. If you want to use the LIST CHAINED ROWS operation to list into a table, that table must be in your schema or you must have the INSERT privilege on it. COMPUTE STATISTICS will result in more accurate statistics, but is likely to take longer. ESTIMATE STATISTICS will normally be much faster and almost as accurate. Note that the object being analyzed will be locked while statistics are being collected, so the faster ESTIMATE STATISTICS may be preferable in a heavy transaction environment. Statistics are stored in the DBA_TABLES data dictionary view, and some column statistics are stored in the DBA_TAB_COLUMNS data dictionary view.