Ramin Hossaini's Blog

20Feb/10

Update statistics on all objects in a database

This helps Oracle choose the best execution plan for queries:

BEGIN
dbms_stats.gather_database_stats(options=> 'GATHER AUTO');
END;
/

Related posts:

  1. Backing up an Oracle database without RMAN
  2. Enabling Trace
  3. Recompile invalid objects in an Oracle schema
  4. Oracle: List all database-links
  5. Listing key Oracle Database files
Tagged as: , Leave a comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

(required)

No trackbacks yet.

» «

Pages

Categories

Bear