- You can also use the new procedure called. - You can also use the new. - It is either 1 (serial execution) or DEFAULT_DEGREE (the system default value based on the number of CPUs and initialization parameters) according to the size of the object.. - LOCK_TABLE_STATS procedure of the DBMS_STATS package. - You can query the STATTYPE_LOCKED column in the {USER | ALL. - You can restore statistics by using the RESTORE procedures of the DBMS_STATS package. - Using this page, you can do the following:. - The following are some consequences of the desupport of RBO:. - The normal mode of the optimizer generates a reasonable execution plan for the vast majority of SQL statements. - SQL tuning is not only one of the most critical aspects of managing the. - SQL Tuning Advisor is primarily the driver of the tuning process. - Partial execution of the statement. - Past execution history statistics of the statement. - The slide shows the process flow of the creation and use of a SQL Profile. - you can implement it if you want.. - Note: Using the DBMS_SQLTUNE package, you can also export or import SQL Tuning Sets in the same way.. - You can change the category of a SQL Profile:. - With these options, you can reduce the scope of the SQL statements that are present in the workload. - recommendations of the highest quality. - By default, indexes are placed in the schema and tablespace of the table they reference. - You can also instruct the. - On most of the performance-related pages, you can navigate within these three dimensions.. - In this case, one of the biggest contention area is Concurrency. - In the example, 25 percent of the computing resource units are idle. - Session count by instance – Run queue length of the node – Service goodness. - Services are also created implicitly at startup of the instance according to the values set for the SERVICE_NAMES initialization parameter.. - Using the General tabbed page of the Resource Consumer Group Mapping page, you can set up a mapping of sessions connecting with a service name to consumer groups. - Note: Using the Priorities tabbed page of the Resource Consumer Group Mapping page, you can set priorities for the mappings that you set up on the General tabbed page. - To configure a job to run under a specific service, click the Job Classes link in the Database Scheduler section of the Administration page. - Note: It is possible to set job attributes, such as INSTANCE_STICKINESS, by using the SET_ATTRIBUTE procedure of the DBMS_SCHEDULER PL/SQL package.. - ERP is the name of the service used by the example shown in the slide.. - Note: At the end of the execution, the slaves revert to the default database service.. - You can define service-level thresholds:. - You can react on generated alerts:. - The screenshot shows a portion of the page where you can see the Service CPU Time (per user call) and Service Response Time (per user call) metrics.. - original consumer group at the end of the top call. - To prevent this situation, you can set the RESOURCE_MANAGER_PLAN parameter to the name of the plan you want for the system and prefix the name with FORCE:. - At the end of the top call, the Resource Manager automatically switches the user back to the initial consumer group.. - meaningful only at session login time, when the Database Resource Manager determines the initial consumer group of the session. - You can establish a priority ordering between conflicting mappings of the attributes by using the Priorities tab. - The mappings at the top of the list have the highest priority.. - In addition, a number of statistics have been introduced and you can now monitor the functioning of the Database Resource Manager at the session level.. - The Consumer Group Statistics table lists a series of statistics for the consumer groups that are part of the current resource plan.. - You can specify the program (what) and schedule (when) as part of the job definition, or you can use an existing program or schedule instead. - You can define arguments for a program, allowing users to modify the run-time behavior of the task.. - You can also customize the job by specifying argument values.. - This calendaring expression is used to generate the next date of the schedule. - You can use Enterprise Manager to create schedules as shown in the slide. - minutes, or even every second, you can do this by using a combination of the frequency and the interval. - Every 15th day of the month: FREQ=MONTHLY. - You can use the minus sign. - with the specifier to specify a backward count from the end of the interval period. - You provide a list of dates with the day of the year specified in the [YYYY]MMDD format. - DBMS_SCHDULER.CREATE_SCHEDULE procedure, or you can specify the schedule parameters as part of the job creation. - Use the CREATE_JOB procedure of the DBMS_SCHEDULER package to create a job. - All job names are of the form: [schema.]name.. - You can create a job in another schema by specifying the name of the schema, as shown in the slide example. - Jobs are executed with the privileges of the job owner. - For example, you may need to reference one or more of the following books:. - You can include user data. - This event object contains the event type, which can be one of the following:. - You can use. - Jobs, programs, and schedules are created in the schema of the current user. - This role is part of the DBA role by default.. - LOG_ID : The unique identifier of the log entry. - LOG_DATE : The time stamp of the log entry. - JOB_NAME : The name of the job. - STATUS : The status of the job execution. - ERROR#: The number of the first error encountered. - RUN_DURATION: The duration of execution of the job. - SLAVE_PID : The process ID of the slave process used to perform the job execution. - You can also query the [ALL|DBA|USER]_SCHEDULER_JOB_RUN_DETAILS view for a list of all completed (failed or successful) job runs.. - Each step can point to one of the following:. - All procedures mentioned are part of the DBMS_SCHEDULER package, unless noted otherwise.. - You can also choose to end the execution of the job chain, returning either a value or a step name and error code.. - instead, it represents the final action of the chain, as defined in the chain rules.. - You can also configure rules to be evaluated at regular intervals by using the evaluation_interval attribute of the chain.. - You can use the following to describe the chain condition:. - The current state of the chain step:. - You can also create conditions that refer to attributes of chain steps of the chain by using the chain step name as a bind variable.. - Some examples of the bind variable syntax are:. - Set the job_type to 'CHAIN' and the job action to the name of the job chain you want to execute. - On the Scheduler Chains page, you can create or edit a job chain. - On the Create Chain page, you must enter the name and owner of the job chain. - You can create job chain steps of the following type:. - At the bottom of the page is a Show SQL button that you can use to store the generated SQL commands in a script.. - You can also:. - the name and owner of the job that points to the chain. - the name of the steps in the chain and their current state. - and the name of the job running the step, if it is current executing.. - to 6:00 p.m.” The recurring time window is specified as a schedule specifying a pattern of start dates and duration (in minutes).. - The second prioritization is within the class, using the job priority attribute of the job.. - You can specify job priorities by using the SET_ATTRIBUTE procedure. - You can use the CREATE_JOB_CLASS procedure of the DBMS_SCHEDULER package to create a job class. - Enter the Name of the job class and Resource Consumer Group with which this job class is associated. - You can select the resource consumer group by using the search function.. - Altering the program and schedule for the job and observing the behavior change of the job. - You can modify these.. - On the Edit Tablespace page, you can:. - With Oracle Database 10g, you can now shrink segments
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt