Ramin Hossaini (blog)

20Feb/100

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;
/
Share and make me happy:
  • Twitter
  • Facebook
  • Digg
  • StumbleUpon

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


Please leave these two fields as-is:

No trackbacks yet.

« Starting, stopping, and Status of Oracle Enterprise Manager (EM) Turning Archive-log mode on and off »

Categories

Meta

Bear