{"id":180,"date":"2014-05-29T10:00:00","date_gmt":"2014-05-29T08:00:00","guid":{"rendered":"https:\/\/www.carajandb.com\/2014\/05\/29\/automatic-maintenance-and-optimizer-statistic-collection-managing-with-12c-and-11g\/"},"modified":"2014-05-29T10:00:00","modified_gmt":"2014-05-29T08:00:00","slug":"automatic-maintenance-and-optimizer-statistic-collection-managing-with-12c-and-11g","status":"publish","type":"post","link":"https:\/\/carajandb.com\/en\/2014\/05\/29\/automatic-maintenance-and-optimizer-statistic-collection-managing-with-12c-and-11g\/","title":{"rendered":"Automatic Maintenance and Optimizer Statistic Collection managing with 12c and 11g"},"content":{"rendered":"<p>Theoretically, the Automatic Maintenance Tasks which controlled the automatic optimizer statistics can easily configured via Cloud Control. The problem is that, with version 12c, the database comes by standard only with the Enterprise Manager Database Express 12c. With EM Express you can only get to know that Automatic Maintenance is in use or it is not (Configuration &gt; Used database features). In the &#8220;standard&#8221; Enterprise Manager 11g the appropriate configuration option still was installed (Server &gt; Automated Maintenance Tasks).<\/p>\n<p>So the only way with 12c beside Cloud Control is the command line. The following works with both 12c and 11g.<\/p>\n<p>  <!--more-->  <\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-524\" src=\"https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01.jpg\" width=\"574\" height=\"174\" alt=\"AMT 01\" title=\"\" srcset=\"https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01.jpg 822w, https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01-450x136.jpg 450w, https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01-768x233.jpg 768w, https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01-300x91.jpg 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-525\" src=\"https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_02.jpg\" width=\"574\" height=\"347\" alt=\"AMT 02\" title=\"\" srcset=\"https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_02.jpg 800w, https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_02-450x272.jpg 450w, https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_02-768x465.jpg 768w, https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_02-300x182.jpg 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Installed by default, the database comes with three preconfigured Automatic Maintenance Tasks, called clients. First, the collection of optimizer statistics (Optimizer Statistics Collection), the Segment Advisor (Space Advisor) and the automatic SQL tuning (SQL Tuning Advisor).<\/p>\n<p class=\"article-count\">&nbsp;<\/p>\n<p class=\"article-count\">a. Status<\/p>\n<p>First, the query for the current state of the database in DBA_AUTOTASK_CLIENTS. Only in Enterprise Edition is the SQL Tuning Advisor ENABLED.<\/p>\n<pre><span>SQL&gt; select client_name, status, attributes from dba_autotask_client;<br \/><\/span><br \/><span style=\"color: #000000;\"><span style=\"font-size: 9pt; font-family: 'Courier New';\"><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">CLIENT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STATUS&nbsp;&nbsp; ATTRIBUTES<\/span><\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">---------------------------------&nbsp; -------&nbsp; ----------------------------------------<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">auto optimizer stats collection&nbsp;&nbsp;&nbsp; ENABLED&nbsp; ON BY DEFAULT, VOLATILE, SAFE TO KILL<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">auto space advisor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; ON BY DEFAULT, VOLATILE, SAFE TO KILL<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">sql tuning advisor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; ONCE PER WINDOW, ON BY DEFAULT, VOLATILE, SAFE TO KILL <\/span><\/pre>\n<p>&nbsp;<\/p>\n<p>As a further query the configured time window in DBA_AUTOTASK_WINDOW_CLIENTS:<\/p>\n<pre><span>select window_name, autotask_status, optimizer_stats from dba_autotask_window_clients;<br \/><\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">WINDOW_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUTOTASK_STATUS&nbsp; OPTIMIZER_STATS<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">------------------------&nbsp; ---------------- ----------------<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">SUNDAY_WINDOW&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">SATURDAY_WINDOW&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">FRIDAY_WINDOW&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">THURSDAY_WINDOW&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">WEDNESDAY_WINDOW &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">TUESDAY_WINDOW&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">MONDAY_WINDOW&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED <\/span><\/pre>\n<p>&nbsp;<\/p>\n<p>By default seven time windows are configured:<\/p>\n<pre><span>select * from DBA_SCHEDULER_WINDOWS;<\/span> <\/pre>\n<p>&nbsp;<\/p>\n<table border=\"0\">\n<colgroup width=\"200\" span=\"3\"><\/colgroup>\n<tbody>\n<tr>\n<td>\n<p><span style=\"font-family: verdana, geneva; font-size: small;\">Time Window<\/span><\/p>\n<\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">Start<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">Duration<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">Status<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">MONDAY_WINDOW<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">22<span style=\"font-family: verdana, geneva; font-size: small; line-height: normal;\">&nbsp;= 10 pm<\/span><\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">4h<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">enabled<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">TUESDAY_WINDOW<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">22<span style=\"font-family: verdana, geneva; font-size: small; line-height: normal;\">&nbsp;= 10 pm<\/span><\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">4h<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">enabled<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">WEDNESDAY_WINDOW<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">22<span style=\"font-family: verdana, geneva; font-size: small; line-height: normal;\">&nbsp;= 10 pm<\/span><\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">4h<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">enabled<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">THURSDAY_WINDOW<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">22<span style=\"font-family: verdana, geneva; font-size: small; line-height: normal;\">&nbsp;= 10 pm<\/span><\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">4h<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">enabled<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">FRIDAY_WINDOW<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">22 = 10 pm<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">4h<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">enabled<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">SATURDAY_WINDOW<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">6 am<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">20h<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">enabled<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">SUNDAY_WINDOW<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">6 am<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">20h<\/span><\/td>\n<td><span style=\"font-family: verdana, geneva; font-size: small;\">enabled<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>DBA_AUTOTASK_SCHEDULE supplies the configured time windows for the next 32 days:<\/p>\n<pre><span>select * from DBA_AUTOTASK_SCHEDULE order by start_time;<\/span> <\/pre>\n<p class=\"article-count\">&nbsp;<\/p>\n<p class=\"article-count\">b. Activation \/ Deactivation<\/p>\n<p>Quite generally, the auto tasks can be controlled with the DBMS_AUTO_TASK_ADMIN package.<\/p>\n<p>To start and stop AUTO_TASKS enable or disable is sufficient.<\/p>\n<pre><span>exec dbms_auto_task_admin.disable;<\/span><\/pre>\n<pre><span>select window_name, autotask_status, optimizer_stats from dba_autotask_window_clients;<br \/><br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">WINDOW_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUTOTASK_STATUS&nbsp; OPTIMIZER_STATS<\/span><br \/><span style=\"color: #000000;\"><span style=\"font-size: 9pt; font-family: 'Courier New';\">------------------------&nbsp; ---------------- ----------------<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">SUNDAY_WINDOW&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">SATURDAY_WINDOW&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">FRIDAY_WINDOW&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">THURSDAY_WINDOW&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">WEDNESDAY_WINDOW &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">TUESDAY_WINDOW&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New'; color: #000000;\">MONDAY_WINDOW&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED <\/span><\/pre>\n<p>&nbsp;<\/p>\n<p>Following command deactivates only Optimizer Stats Collection:<\/p>\n<pre><span style=\"color: #000000;\"><span style=\"font-size: 9pt;\">begin<\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">&nbsp; <br \/>dbms_auto_task_admin.disable(<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">&nbsp;&nbsp;&nbsp; client_name =&gt; 'auto optimizer stats collection',<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">&nbsp;&nbsp;&nbsp; operation =&gt; NULL,<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">&nbsp;&nbsp;&nbsp; window_name =&gt; NULL);<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">end;<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">\/<\/span> <\/span><\/pre>\n<p>&nbsp;<\/p>\n<pre><span>select window_name, autotask_status, optimizer_stats from dba_autotask_window_clients;<br \/><\/span><br \/><span style=\"color: #000000;\"><span style=\"font-size: 9pt; font-family: 'Courier New';\">WINDOW_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUTOTASK_STATUS&nbsp; OPTIMIZER_STATS<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">------------------------&nbsp; ---------------- ----------------<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">SUNDAY_WINDOW&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">SATURDAY_WINDOW&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">FRIDAY_WINDOW&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">THURSDAY_WINDOW&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">WEDNESDAY_WINDOW &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">TUESDAY_WINDOW&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">MONDAY_WINDOW&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED<\/span> <\/span><\/pre>\n<p>&nbsp;<\/p>\n<pre><span><span style=\"font-size: 9pt; font-family: 'Courier New';\">SQL&gt; select client_name, status from dba_autotask_client;<br \/><\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New';\">CLIENT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STATUS&nbsp;&nbsp; <br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">---------------------------------&nbsp; ---------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">auto optimizer stats collection&nbsp;&nbsp;&nbsp; DISABLED <br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">auto space advisor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">sql tuning advisor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENABLED<\/span> <\/span><\/pre>\n<p class=\"article-count\">&nbsp;<\/p>\n<p class=\"article-count\">c. Changing START time<\/p>\n<p>If you want to change the start time, you have to adjust the REPEAT_INTERVAL. Below we will change for the MONDAY_WINDOW the start time to 5 clock with DBMS_SCHEDULER.SET_ATTRIBUTE:<\/p>\n<pre><span><span style=\"font-size: 9pt; font-family: 'Courier New';\">begin<\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">&nbsp; <br \/>dbms_scheduler.set_attribute(<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt; 'MONDAY_WINDOW',<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">&nbsp;&nbsp;&nbsp; attribute =&gt; 'repeat_interval',<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">&nbsp;&nbsp;&nbsp; value&nbsp;&nbsp;&nbsp;&nbsp; =&gt; 'freq=daily;byday=MON;byhour=5;byminute=0; bysecond=0');<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">end;<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">\/<\/span> <\/span><\/pre>\n<p>&nbsp;<\/p>\n<pre><span><span style=\"font-size: 9pt; font-family: 'Courier New';\">select window_name, repeat_interval, from dba_scheduler_windows where window_name = 'MONDAY_WINDOW';<\/span><br \/><span style=\"font-size: 9pt; font-family: 'Courier New';\"><br \/>WINDOW_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REPEAT_INTERVAL<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">---------------- -----------------------------------------------------<br \/><\/span><span style=\"font-size: 9pt; font-family: 'Courier New';\">MONDAY_WINDOW&nbsp;&nbsp;&nbsp; freq=daily;byday=MON;byhour=5;byminute=0; bysecond=0<\/span> <\/span><\/pre>\n<p class=\"article-count\">&nbsp;<\/p>\n<p class=\"article-count\">d. Changing DURATION<\/p>\n<p>Is the time window of 4 hours not enough to work through all the tables and the Optimizer Statistics Collection runs out of the predetermined windows, the DURATION must be adjusted. Below, we set the window up to 5 hours.<\/p>\n<pre><span style=\"font-size: 9pt; color: #000000;\">begin<\/span><br \/><span style=\"font-size: 9pt; color: #000000;\">&nbsp; dbms_scheduler.set_attribute(<\/span><br \/><span style=\"color: #000000;\">&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt; 'MONDAY_WINDOW',<\/span><br \/><span style=\"font-size: 9pt; color: #000000;\">&nbsp;&nbsp;&nbsp; attribute =&gt; 'duration',<\/span><br \/><span style=\"color: #000000;\">&nbsp;&nbsp;&nbsp; value&nbsp;&nbsp;&nbsp;&nbsp; =&gt; numtodsinterval(5, 'hour'));<\/span><br \/><span style=\"font-size: 9pt; color: #000000;\">end;<\/span><br \/><span style=\"font-size: 9pt; color: #000000;\">\/<\/span> <\/pre>\n<pre><span>select window_name, duration from dba_scheduler_windows where window_name = 'MONDAY_WINDOW';<\/span><br \/>&nbsp;<br \/><span style=\"font-size: 9pt; color: black;\">WINDOW_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REPEAT_INTERVAL<\/span><br \/><span style=\"color: #000000;\">---------------  --------------------<\/span><br \/><span style=\"font-family: 'Courier New'; font-size: 9pt; line-height: normal; color: #000000; background-color: transparent;\">MONDAY_WINDOW&nbsp;&nbsp;&nbsp; +00 05:00:00.000000<\/span><\/pre>\n<p class=\"article-count\">&nbsp;&nbsp;<\/p>\n<p class=\"article-count\">e. Creating a new WINDOW<\/p>\n<pre><span>begin<\/span><br \/><span style=\"font-size: 9pt; color: black;\">&nbsp; dbms_scheduler.create_window(<\/span><br \/><span style=\"font-size: 9pt; color: black;\">&nbsp;&nbsp;&nbsp; window_name&nbsp;&nbsp;&nbsp;&nbsp; =&gt; 'SPECIAL_WINDOW',<\/span><br \/><span style=\"font-size: 9pt; color: black;\">&nbsp;&nbsp;&nbsp; duration&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;&nbsp; numtodsinterval(3, 'hour'),<\/span><br \/><span style=\"font-size: 9pt; color: black;\">&nbsp;&nbsp;&nbsp; resource_plan&nbsp;&nbsp; =&gt; 'DEFAULT_MAINTENANCE_PLAN',<\/span><br \/><span style=\"font-size: 9pt; color: black;\">&nbsp;&nbsp;&nbsp; repeat_interval =&gt; 'FREQ=DAILY;BYHOUR=10;BYMINUTE=0;BYSECOND=0');<\/span><br \/><span style=\"font-size: 9pt; color: black;\">&nbsp; dbms_scheduler.add_group_member(<\/span><br \/><span style=\"font-size: 9pt; color: black;\">&nbsp;&nbsp;&nbsp; group_name&nbsp; =&gt; 'MAINTENANCE_WINDOW_GROUP',<\/span><br \/><span style=\"font-size: 9pt; color: black;\">&nbsp;&nbsp;&nbsp; member&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt; 'SPECIAL_WINDOW');<\/span><br \/><span style=\"font-size: 9pt; color: black;\">end;<\/span><br \/><span style=\"font-size: 9pt; color: black;\">\/<\/span><\/pre>\n<p class=\"article_title\">&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Theoretically, the Automatic Maintenance Tasks which controlled the automatic optimizer statistics can easily configured via Cloud Control. The problem is that, with version 12c, the database comes by standard only with the Enterprise Manager Database Express 12c. With EM Express you can only get to know that Automatic Maintenance is in use or it is not (Configuration &gt; Used database features). In the &#8220;standard&#8221; Enterprise Manager 11g the appropriate configuration option still was installed (Server &gt; Automated Maintenance Tasks). So the only way with 12c beside Cloud Control is the command line. The following works with both 12c and 11g.<\/p>\n","protected":false},"author":3,"featured_media":524,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_crdt_document":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[],"tags":[136,137,22,23,41,135,107],"class_list":["post-180","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-dnfs","tag-linux","tag-oracle","tag-oracle-11g","tag-oracle-12c","tag-oracle-direct-nfs","tag-windows"],"acf":{"occupation":"Write the Occupation of the Person","person_can-be-speaker":true,"person_is-team":true,"person_related-user-account":null,"person_ordering-number":50,"publication_speakers":null,"publication_content-language":["de"],"publication_files":null,"publication_event":"","publication_date":null},"spectra_custom_meta":{"_thumbnail_id":["524"],"_fgj2wp_old_id":["180"],"_yoast_wpseo_metadesc":["Oracle Direct NFS, dNFS, Windows, Linux"],"_yoast_wpseo_metakeywords":["Oracle Direct NFS, dNFS, Windows, Linux, Oracle, Oracle 11g, Oracle 12c"],"layout_show-author-box":["1"],"_layout_show-author-box":["field_5a64ee9cc6490"],"_edit_lock":["1517511559:1"],"_wpml_media_duplicate":["1"],"_wp_attachment_metadata":[""],"rank_math_description":["Oracle Direct NFS, dNFS, Windows, Linux"],"rank_math_news_sitemap_robots":["index"],"rank_math_robots":["a:1:{i:0;s:5:\"index\";}"],"rank_math_internal_links_processed":["1"],"wpil_sync_report3":["1"],"wpil_links_inbound_internal_count":["0"],"wpil_links_inbound_internal_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_links_outbound_internal_count":["0"],"wpil_links_outbound_internal_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_links_outbound_external_count":["0"],"wpil_links_outbound_external_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_sync_report2_time":["2024-08-27T11:47:29+00:00"],"astra_style_timestamp_css":["1776968304"],"copied_media_ids":["a:2:{i:0;i:7231;i:1;i:7232;}"],"referenced_media_ids":["a:1:{i:0;i:524;}"],"_uag_css_file_name":["uag-css-180.css"],"_uag_page_assets":["a:9:{s:3:\"css\";s:25293:\".uag-blocks-common-selector{z-index:var(--z-index-desktop) !important}@media(max-width: 976px){.uag-blocks-common-selector{z-index:var(--z-index-tablet) !important}}@media(max-width: 767px){.uag-blocks-common-selector{z-index:var(--z-index-mobile) !important}}.uagb-icon-list__wrap{display:flex;align-items:flex-start;justify-content:flex-start}.wp-block-uagb-icon-list-child{padding:0;transition:all .2s;display:inline-flex;color:#3a3a3a;align-items:center;text-decoration:none;box-shadow:none}.wp-block-uagb-icon-list-child span.uagb-icon-list__source-wrap{display:block;align-items:center}.uagb-icon-list__source-wrap svg{display:block}.uagb-icon-list__source-image{width:40px}.uagb-icon-list__outer-wrap .uagb-icon-list__content-wrap{color:#3a3a3a;display:flex;align-items:center}.wp-block-uagb-icon-list-child{position:relative}.wp-block-uagb-icon-list-child>a{position:absolute;top:0;left:0;width:100%;height:100%}img.uagb-icon-list__source-image{max-width:unset}.wp-block-uagb-icon-list-child .uagb-icon-list__label{word-break:break-word}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;color: var(--ast-global-color-0);fill: var(--ast-global-color-0);}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{border-color: #28368200;padding: 0px;border-radius: 100px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__label{font-size: 20px;text-decoration: !important;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__label{text-align: left;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child{text-decoration: !important;font-size: 20px;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-wrap{margin-right: 15px;}.uagb-block-d4bae936.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{fill: var(--ast-global-color-0) !important;color: var(--ast-global-color-0) !important;}.uagb-block-d4bae936.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-d4bae936.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-d4bae936.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child{margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.uagb-block-375284f0.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-375284f0.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-dfc53cb7.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-dfc53cb7.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap {padding: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}@media only screen and (max-width: 767px) {.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{padding: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;color: var(--ast-global-color-0);fill: var(--ast-global-color-0);}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{border-color: #28368200;padding: 0px;border-radius: 100px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__label{font-size: 20px;text-decoration: !important;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__label{text-align: left;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child{text-decoration: !important;font-size: 20px;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-wrap{margin-right: 15px;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{fill: var(--ast-global-color-0) !important;color: var(--ast-global-color-0) !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child{margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.uagb-block-66131845.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-66131845.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-b2264876.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-b2264876.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap {padding: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}@media only screen and (max-width: 767px) {.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{padding: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}.wp-block-uagb-container{display:flex;position:relative;box-sizing:border-box;transition-property:box-shadow;transition-duration:.2s;transition-timing-function:ease}.wp-block-uagb-container .spectra-container-link-overlay{bottom:0;left:0;position:absolute;right:0;top:0;z-index:10}.wp-block-uagb-container.uagb-is-root-container{margin-left:auto;margin-right:auto}.wp-block-uagb-container.alignfull.uagb-is-root-container .uagb-container-inner-blocks-wrap{display:flex;position:relative;box-sizing:border-box;margin-left:auto !important;margin-right:auto !important}.wp-block-uagb-container .wp-block-uagb-blockquote,.wp-block-uagb-container .wp-block-spectra-pro-login,.wp-block-uagb-container .wp-block-spectra-pro-register{margin:unset}.wp-block-uagb-container .uagb-container__video-wrap{height:100%;width:100%;top:0;left:0;position:absolute;overflow:hidden;-webkit-transition:opacity 1s;-o-transition:opacity 1s;transition:opacity 1s}.wp-block-uagb-container .uagb-container__video-wrap video{max-width:100%;width:100%;height:100%;margin:0;line-height:1;border:none;display:inline-block;vertical-align:baseline;-o-object-fit:cover;object-fit:cover;background-size:cover}.wp-block-uagb-container.uagb-layout-grid{display:grid;width:100%}.wp-block-uagb-container.uagb-layout-grid>.uagb-container-inner-blocks-wrap{display:inherit;width:inherit}.wp-block-uagb-container.uagb-layout-grid>.uagb-container-inner-blocks-wrap>.wp-block-uagb-container{max-width:unset !important;width:unset !important}.wp-block-uagb-container.uagb-layout-grid>.wp-block-uagb-container{max-width:unset !important;width:unset !important}.wp-block-uagb-container.uagb-layout-grid.uagb-is-root-container{margin-left:auto;margin-right:auto}.wp-block-uagb-container.uagb-layout-grid.uagb-is-root-container>.wp-block-uagb-container{max-width:unset !important;width:unset !important}.wp-block-uagb-container.uagb-layout-grid.alignwide.uagb-is-root-container{margin-left:auto;margin-right:auto}.wp-block-uagb-container.uagb-layout-grid.alignfull.uagb-is-root-container .uagb-container-inner-blocks-wrap{display:inherit;position:relative;box-sizing:border-box;margin-left:auto !important;margin-right:auto !important}body .wp-block-uagb-container>.uagb-container-inner-blocks-wrap>*:not(.wp-block-uagb-container):not(.wp-block-uagb-column):not(.wp-block-uagb-container):not(.wp-block-uagb-section):not(.uagb-container__shape):not(.uagb-container__video-wrap):not(.wp-block-spectra-pro-register):not(.wp-block-spectra-pro-login):not(.uagb-slider-container):not(.spectra-image-gallery__control-lightbox):not(.wp-block-uagb-info-box),body .wp-block-uagb-container>.uagb-container-inner-blocks-wrap,body .wp-block-uagb-container>*:not(.wp-block-uagb-container):not(.wp-block-uagb-column):not(.wp-block-uagb-container):not(.wp-block-uagb-section):not(.uagb-container__shape):not(.uagb-container__video-wrap):not(.wp-block-spectra-pro-register):not(.wp-block-spectra-pro-login):not(.uagb-slider-container):not(.spectra-container-link-overlay):not(.spectra-image-gallery__control-lightbox):not(.wp-block-uagb-lottie):not(.uagb-faq__outer-wrap){min-width:unset !important;width:100%;position:relative}body .ast-container .wp-block-uagb-container>.uagb-container-inner-blocks-wrap>.wp-block-uagb-container>ul,body .ast-container .wp-block-uagb-container>.uagb-container-inner-blocks-wrap>.wp-block-uagb-container ol,body .ast-container .wp-block-uagb-container>.uagb-container-inner-blocks-wrap>ul,body .ast-container .wp-block-uagb-container>.uagb-container-inner-blocks-wrap ol{max-width:-webkit-fill-available;margin-block-start:0;margin-block-end:0;margin-left:20px}.ast-plain-container .editor-styles-wrapper .block-editor-block-list__layout.is-root-container .uagb-is-root-container.wp-block-uagb-container.alignwide{margin-left:auto;margin-right:auto}.uagb-container__shape{overflow:hidden;position:absolute;left:0;width:100%;line-height:0;direction:ltr}.uagb-container__shape-top{top:-3px}.uagb-container__shape-bottom{bottom:-3px}.uagb-container__shape.uagb-container__invert.uagb-container__shape-bottom,.uagb-container__shape.uagb-container__invert.uagb-container__shape-top{-webkit-transform:rotate(180deg);-ms-transform:rotate(180deg);transform:rotate(180deg)}.uagb-container__shape.uagb-container__shape-flip svg{transform:translateX(-50%) rotateY(180deg)}.uagb-container__shape svg{display:block;width:-webkit-calc(100% + 1.3px);width:calc(100% + 1.3px);position:relative;left:50%;-webkit-transform:translateX(-50%);-ms-transform:translateX(-50%);transform:translateX(-50%)}.uagb-container__shape .uagb-container__shape-fill{-webkit-transform-origin:center;-ms-transform-origin:center;transform-origin:center;-webkit-transform:rotateY(0deg);transform:rotateY(0deg)}.uagb-container__shape.uagb-container__shape-above-content{z-index:9;pointer-events:none}.nv-single-page-wrap .nv-content-wrap.entry-content .wp-block-uagb-container.alignfull{margin-left:calc(50% - 50vw);margin-right:calc(50% - 50vw)}@media only screen and (max-width: 767px){.wp-block-uagb-container .wp-block-uagb-advanced-heading{width:-webkit-fill-available}}.wp-block-uagb-image--align-none{justify-content:center}.wp-block-uagb-container.uagb-block-add44f6f .uagb-container__shape-top svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-add44f6f .uagb-container__shape.uagb-container__shape-top .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-add44f6f .uagb-container__shape-bottom svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-add44f6f .uagb-container__shape.uagb-container__shape-bottom .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-add44f6f .uagb-container__video-wrap video{opacity: 1;}.wp-block-uagb-container.uagb-is-root-container .uagb-block-add44f6f{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-add44f6f{box-shadow: 0px 0px   #00000070 ;padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;overflow: visible;order: initial;border-color: inherit;flex-direction: column;align-items: stretch;justify-content: center;flex-wrap: nowrap;row-gap: 20px;column-gap: 20px;max-width: 100% !important;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 25px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 25px;height: 25px;font-size: 25px;color: var(--ast-global-color-0);fill: var(--ast-global-color-0);}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{border-color: #28368200;padding: 0px;border-radius: 100px;border-width: 0px;align-self: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__label{font-size: 20px;text-decoration: !important;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__label{text-align: left;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child{text-decoration: !important;font-size: 20px;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-wrap{margin-right: 20px;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{fill: var(--ast-global-color-0) !important;color: var(--ast-global-color-0) !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child{margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.uagb-block-66131845.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-66131845.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-bb602a54.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-bb602a54.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-b2264876.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-b2264876.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-add44f6f{width: 100%;}.wp-block-uagb-container.uagb-block-add44f6f{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;align-items: stretch;max-width:  !important;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 25px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 25px;height: 25px;font-size: 25px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap {padding: 0px;border-width: 0px;align-self: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}@media only screen and (max-width: 767px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-add44f6f{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-add44f6f{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;align-items: stretch;flex-wrap: wrap;max-width: 100% !important;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 25px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 25px;height: 25px;font-size: 25px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{padding: 0px;border-width: 0px;align-self: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}.wp-block-uagb-container.uagb-block-e8cad69e .uagb-container__shape-top svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-e8cad69e .uagb-container__shape.uagb-container__shape-top .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-e8cad69e .uagb-container__shape-bottom svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-e8cad69e .uagb-container__shape.uagb-container__shape-bottom .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-e8cad69e .uagb-container__video-wrap video{opacity: 1;}.wp-block-uagb-container.uagb-is-root-container .uagb-block-e8cad69e{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-e8cad69e{box-shadow: 0px 0px   #00000070 ;padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;overflow: visible;order: initial;border-color: inherit;flex-direction: column;align-items: center;justify-content: center;flex-wrap: nowrap;row-gap: 20px;column-gap: 20px;max-width: 100% !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-e8cad69e{width: 100%;}.wp-block-uagb-container.uagb-block-e8cad69e{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;max-width:  !important;}}@media only screen and (max-width: 767px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-e8cad69e{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-e8cad69e{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;flex-wrap: wrap;max-width: 100% !important;}}.wp-block-uagb-container.uagb-block-0921a5e7 .uagb-container__shape-top svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-0921a5e7 .uagb-container__shape.uagb-container__shape-top .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-0921a5e7 .uagb-container__shape-bottom svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-0921a5e7 .uagb-container__shape.uagb-container__shape-bottom .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-0921a5e7 .uagb-container__video-wrap video{opacity: 1;}.wp-block-uagb-container.uagb-is-root-container .uagb-block-0921a5e7{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-0921a5e7{box-shadow: 0px 0px   #00000070 ;padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;overflow: visible;order: initial;border-color: inherit;flex-direction: column;align-items: center;justify-content: center;flex-wrap: nowrap;row-gap: 20px;column-gap: 20px;max-width: 100% !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-0921a5e7{width: 100%;}.wp-block-uagb-container.uagb-block-0921a5e7{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;max-width:  !important;}}@media only screen and (max-width: 767px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-0921a5e7{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-0921a5e7{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;flex-wrap: wrap;max-width: 100% !important;}}\";s:2:\"js\";s:0:\"\";s:18:\"current_block_list\";a:14:{i:0;s:15:\"core\/categories\";i:1;s:17:\"core\/latest-posts\";i:2;s:14:\"core\/tag-cloud\";i:3;s:14:\"core\/paragraph\";i:4;s:11:\"core\/search\";i:5;s:12:\"core\/heading\";i:6;s:9:\"core\/list\";i:7;s:14:\"core\/list-item\";i:8;s:14:\"uagb\/icon-list\";i:9;s:20:\"uagb\/icon-list-child\";i:10;s:10:\"core\/group\";i:11;s:14:\"uagb\/container\";i:12;s:10:\"core\/image\";i:13;s:17:\"uagb\/loop-builder\";}s:8:\"uag_flag\";b:1;s:11:\"uag_version\";s:10:\"1777211871\";s:6:\"gfonts\";a:1:{s:7:\"Default\";a:2:{s:10:\"fontfamily\";s:7:\"Default\";s:12:\"fontvariants\";a:0:{}}}s:10:\"gfonts_url\";s:77:\"https:\/\/fonts.googleapis.com\/css?family=Default&subset=latin&display=fallback\";s:12:\"gfonts_files\";a:0:{}s:14:\"uag_faq_layout\";b:0;}"]},"uagb_featured_image_src":{"full":["https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01.jpg",822,249,false],"thumbnail":["https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01-200x200.jpg",200,200,true],"medium":["https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01-450x136.jpg",450,136,true],"medium_large":["https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01-768x233.jpg",768,233,true],"large":["https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01.jpg",822,249,false],"1536x1536":["https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01.jpg",822,249,false],"2048x2048":["https:\/\/carajandb.com\/wp-content\/uploads\/2014\/05\/AMT_01.jpg",822,249,false]},"uagb_author_info":{"display_name":"Johannes Ahrends","author_link":"https:\/\/carajandb.com\/en\/author\/9aa6cdb2095bd409\/"},"uagb_comment_info":14,"uagb_excerpt":"Theoretically, the Automatic Maintenance Tasks which controlled the automatic optimizer statistics can easily configured via Cloud Control. The problem is that, with version 12c, the database comes by standard only with the Enterprise Manager Database Express 12c. With EM Express you can only get to know that Automatic Maintenance is in use or it is&hellip;","_links":{"self":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/comments?post=180"}],"version-history":[{"count":0,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/180\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media\/524"}],"wp:attachment":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media?parent=180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/categories?post=180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/tags?post=180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}