Shulou(Shulou.com)05/31 Report--

This article mainly explains "analyzing Oracle shutdown and job viewing and stopping". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "analyze Oracle shutdown and job viewing and stopping".

Oracle11g automatic maintenance task # automatically collects optimizer statistics collect optimizer statistics for all schema objects with no or expired statistics in the database. The collected statistics are used for SQL query optimization to improve SQL execution performance. # automatic segment recommends evaluating the performance of high-load SQL and giving how to tune these SQL. It can be configured to configure SQL profile automatic implementation. # automatic SQL optimization recommendations evaluate the performance of high-load SQL, give how to tune these SQL, you can configure the recommended configuration SQL profile automatic implementation. # since the latter two are of very low practical use in practice, it can be turned off. If the optimizer collects statistics, you can choose to turn it off, or adjust the scheduling task to execute window (1) scheduler job: through dbms_scheduler creation and maintenance, you can use dba_scheduler_jobs,dba_scheduler_job_log,dba_scheduler_job_log (2) job: created in maintenance through dbms_job, basically can now be replaced by dbms_scheduler It can be queried through dba_jobs. (3) autotask:Oracle automatic maintenance tasks can be maintained through dbms_auto_task_admin, can be queried through dba_autotask_task,dba_autotask_client,dba_autotask_window_clients (4) autotask client, automatic maintenance tasks can be executed through client, client also has execution window client, and can be queried through * autotask* data dictionary view. (5) window: task execution window, maintained by dbms_scheduler and window related procedure, that is, a predefined continuous time interval of fixed or interval (6) window group/scheduler group: task window group, which can be composed of multiple window member, can be empty in DBA_SCHEDULER_WINDOWS,DBA_SCHEDULER_WINDOW_DETAILS,DBA_SCHEDULER_WINDOW_GROUPS,DBA_SCHEDULER_WINDOW_LOGDBA_SCHEDULER_JOBS, then program_name has related programs You can query related programs and final calls through the DBA_SCHEDULER_PROGRAMS view. Tasks at the beginning of ORA$AT_ will be created during automatic maintenance. You can query # DBA_AUTOTASK_CLIENT_JOB in the dba_scheduler_job_log view to query running automatic tasks. # system automatic maintenance believes that statistics are automatically collected, SQL AUTOTUNE and SPACE ADVISOR are managed by dbms_auto_task_admin, and window, which is also maintained by dbms_scheduler, is used to perform automatic maintenance tasks on a regular basis. Automatic maintenance tasks can only be enabled, disabled, modified and not deleted. two。 Maintenance window # maintenance window is the continuous time interval for automatic maintenance tasks to run # close sql tuning advisorBEGIN dbms_auto_task_admin.disable (client_name = > 'sql tuning advisor', operation = > NULL, window_name = > NULL); END;/BEGIN dbms_auto_task_admin.disable (client_name = >' auto space advisor', operation = > NULL, window_name = > NULL); END / # enable To enable this maintenance task again, use the ENABLE procedure, as follows:BEGIN dbms_auto_task_admin.enable (client_name = > 'sql tuning advisor', operation = > NULL, window_name = > NULL); END / # if you do not want to close, you can adjust the running task window, you can query the dba_scheduler_windows query window BEGIN dbms_auto_task_admin.disable (client_name = > 'sql tuning advisor', operation = > NULL, window_name = >' MONDAY_WINDOW'); END;/# closes all automatic tasks EXECUTE DBMS_AUTO_TASK_ADMIN.DISABLE;3. Adjust maintenance window time # enable or disable a specified execution window BEGIN dbms_auto_task_admin.disable for a specific task (client_name = > 'sql tuning advisor', operation = > NULL, window_name = >' MONDAY_WINDOW'); END;/# enable, disable, modify a window BEGIN dbms_scheduler.disable (name = > 'SATURDAY_WINDOW') Dbms_scheduler.set_attribute (name = > 'SATURDAY_WINDOW', attribute = >' DURATION', value = > numtodsinterval (4, 'hour')); dbms_scheduler.enable (name = >' SATURDAY_WINDOW'); END / # create a custom window BEGIN dbms_scheduler.create_window (window_name = > 'EARLY_MORNING_WINDOW', duration = > numtodsinterval (1,' hour'), resource_plan = > 'DEFAULT_MAINTENANCE_PLAN', repeat_interval = >' FREQ=DAILY;BYHOUR=5;BYMINUTE=0;BYSECOND=0'); dbms_scheduler.add_group_member (group_name = > 'MAINTENANCE_WINDOW_GROUP', member = >' EARLY_MORNING_WINDOW'); END / # Delete a task window BEGIN DBMS_SCHEDULER.REMOVE_GROUP_MEMBER (group_name = > 'MAINTENANCE_WINDOW_GROUP', member = >' EARLY_MORNING_WINDOW'); END;/4. Automatic tasks using Resource Manager Plan description use DEFAULT_MAINTENANCE_PLAN resource management plan by default: it needs to be managed through DBMS_RESOURCE_MANAGER. Thank you for your reading, the above is the "Analysis of Oracle shutdown and job view and stop" content, after the study of this article, I believe you have a deeper understanding of the analysis of Oracle shutdown and job view and stop this problem, the specific use also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.