DBA > Job Interview Questions > Oracle DBA Checklist

Oracle DBA Checklist - Daily Procedures - analyz

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Oracle DBA Checklist - Daily Procedures - analyze5pct.sql

-- analyze5pct.sql
--
-- To analyze tables and indexes quickly, using a 5% sample size
-- (do not use this script if you are performing the overnight
-- collection of volumetric data)
--

BEGIN
dbms_utility.analyze_schema ( '&OWNER', 'ESTIMATE', NULL, 5 ) ;
END ;
/

(Continued on next question...)

Other Job Interview Questions