|
Oracle DBA Checklist - Daily Procedures - analyze5pct.sql
Oracle DBA Checklist
(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 Interview Questions
| 