auto stats job

BEGIN
SYS.DBMS_SCHEDULER.DROP_JOB
(job_name => 'SYS.GATHER_STATS_JOB');
END;
/

BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'SYS.GATHER_STATS_JOB'
,schedule_name => 'SYS.MAINTENANCE_WINDOW_GROUP'
,program_name => 'SYS.GATHER_STATS_PROG'
,comments => 'Oracle defined automatic optimizer statistics collection job'
);
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'SYS.GATHER_STATS_JOB'
,attribute => 'RESTARTABLE'
,value => TRUE);
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'SYS.GATHER_STATS_JOB'
,attribute => 'LOGGING_LEVEL'
,value => SYS.DBMS_SCHEDULER.LOGGING_RUNS);
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
( name => 'SYS.GATHER_STATS_JOB'
,attribute => 'MAX_FAILURES');
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
( name => 'SYS.GATHER_STATS_JOB'
,attribute => 'MAX_RUNS');
BEGIN
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'SYS.GATHER_STATS_JOB'
,attribute => 'STOP_ON_WINDOW_CLOSE'
,value => TRUE);
EXCEPTION
-- could fail if program is of type EXECUTABLE...
WHEN OTHERS THEN
NULL;
END;
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'SYS.GATHER_STATS_JOB'
,attribute => 'JOB_PRIORITY'
,value => 3);
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
( name => 'SYS.GATHER_STATS_JOB'
,attribute => 'SCHEDULE_LIMIT');
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'SYS.GATHER_STATS_JOB'
,attribute => 'AUTO_DROP'
,value => FALSE);

SYS.DBMS_SCHEDULER.ENABLE
(name => 'SYS.GATHER_STATS_JOB');
END;
/

good plasma tv's

PRO-111FD
PDP-5020FD
TH-50PZ850U
TH-50PZ800U
TH-50PZ85U
TH-46PZ850U
TH-46PZ800U
TH-46PZ85U

TC-P46G10
TC-P50V10

dish

SOFTWARE DOWNLOAD INSTRUCTIONS
Updating Software
Verify signal from Point Dish:
Press the Menu button on the remote.
Select System Setup from the Main Menu, if no System Setup, select Installation, (e.g. Model 1000.)
Select Installation from the System Setup menu.
Select Point Dish from the Installation menu.
Verify the signal bar is green and indicates "Locked".
After checking signal verify you have "Without My Permission" selected under system upgrades.
Press the Menu button on the remote.
Select System Setup from the Main Menu, if no System Setup, select Installation, (e.g. Model 1000.)
Select Installation from the System Setup menu.
Select System Upgrades from the Installation menu.
The check mark should be in "Without My Permission". If it is not, select this option, then select Save.
Power the receiver off for 15 minutes to take the download.
Initial Software Download
On power up, the receiver will go to the Point Dish screen. (Receivers with factory software will not to turn off.)
Verify the signal bar is green and indicates "Locked".
Select Save. If there is not an option for Save, Select Cancel.
Message 055 or 056 will pop up, "Is the mounting and positioning of your dish complete...". Select Yes.
A progress message is displayed with the following, "Warning: Vital program information will now download into your receiver. Do not disturb or unplug it until this screen disappears." This step normally takes 10-15 minutes. If there is an OK button, select it now.
A message stating "Your receiver's memory is now being programmed. Do not disturb or unplug the receiver while the green front panel light is blinking". There is no time limit for this step. Simply follow the onscreen instructions.
If the software download is interrupted, unplug the receiver from the electrical outlet.
Wait 15 seconds, plug it back in and turn it on.
Repeat steps 1 - 3.
Run a Check Switch test.
Press the Menu button on the remote.
Select System Setup from the Main Menu, if no System Setup, select Installation.
Select Installation from the System Setup menu.
Select Point Dish from the Installation menu.
Select Check Switch from the Point Dish menu.
Select Test or "Check".
The receiver displays an Attention message to wait until the switch setup check is done.
Once complete, cancel out to the Installation and Setup Menu.
Select System Info.
Call 1-800-333-3474 to activate your receiver.
Thanks for Chuck&Oleg Ph.D.

IOGEAR GHDMIS4 4-Port HDMI Switch with Remote

Image Viewer

Original Price: $69.99

You Save: $20.00

$49.99

Free Shipping*

* Free shipping not available to AK, HI and PR

http://www.codeproject.com/KB/audio-video/ReprogramYourMouse.aspx

http://www.codeproject.com/KB/audio-video/ReprogramYourMouse.aspx

http://forum.notebookreview.com/showthread.php?t=195238

http://forum.notebookreview.com/showthread.php?t=195238

BLACK SEED OIL

Amazing Herbs
BLACK SEED OIL
A Multi-Purpose Theraputic

Amazing Herbs Black Seed oil (Black Cumin oil) is fresh cold-pressed from Nigella Sativa seeds which contain about 28-35% oil. It is a rich source essential fatty acids which are the building blocks of cells and help the body produce Prostaglandin E1. Chemical analysis and scientific research show that our Black Seed oil contains more than 100 components, some of which are still unidentified, that work together synergistically.

Amazing Herbs Black Seed oil is freshly cold-pressed daily at our own state-of-the-art facility in Atlanta, Georgia. Using only the highest quality Eygptian and Turkish Black Cumin seeds, our oil is Guaranteed 100% Pure, Fresh, and Un-Refined. So, unlike imported mystery oils, you will be happy know that our oil is fresh and has been cold-pressed just days prior to when you receive it.

Lab analysis show that Black Seed oil contains the following Essential Fatty Acids: Myristic Acid(0.5%), Palmitic Acid (13.7%), Palmitoleic Acid (0.1%), Stearic Acid (2.6%), Oleic Acid (23.7%), Linoleic Acid [Omega-6] (57.9%), Linolenic Acid [Omega-3] (0.2%), Arachidic Acid (1.3%) - and the following nutrient components Protein, Thiamin, Riboflavin, Pyridoxine, Niacin, Folacin, Calcium, Iron, Copper, Zinc, Phosphorus.

Black Seed Oil's areas of application range from external skin care and to internal use as support for the body's functions. *

Please note that due to the nature of these products, Black Seed Oil cannot be returned or exchanged. We apologize for this inconvenience.

Black Seed Oil Capsules Made with 100% Pure, Fresh, Cold-Pressed Black Seed Oil (90 Vegetarian Capsules) • 500mg Oil #13090 Regular price: $22.00Sale: $16.99 Black Seed Oil - 1oz 5-7 Day Supply Seed Origin: Turkey Cold-Pressed in USA #12001 Regular price: $6.00Sale: $4.99, 3/$14.40 Black Seed Oil - 4oz 20-24 Day Supply Seed Origin: Choose from Egyptian or Turkish. Cold-Pressed in USA #12004 Regular price: $20.00Sale: $16.99 Black Seed Oil - 8oz 40-45 Day Supply Seed Origin: Choose from Egyptian or Turkish. Cold-Pressed in USA #12008 Regular price: $28.00Sale: $22.99 Select: TurkishEgyptian Black Seed Oil - 16oz 80-90 Day Supply Seed Origin: Choose from Egyptian or Turkish. Cold-Pressed in USA #12016 Regular price: $48.00Sale: $38.99 Select: TurkishEgyptian Black Seed Oil - 32oz 160-180 Day Supply Seed Origin: Choose from Egyptian or Turkish. Cold-Pressed in USA #12032 Regular price: $72.00Sale: $72.00, 3/$172.80 Select: TurkishEgyptian Black Seed Oil - 1 Gallon Seed Origin: Turkish. Cold-Pressed in USA #12128 Regular price: $300.00Sale: $275.00, 3/$720.00 Black Seed & Flax Oil Blend - 8oz 16-20 Day Supply Premium Blend Black Seed Oil & Flax Seed Oil offering Omega 3/6/9 EFA's #11008 Regular price: $28.00Introductory Price: $22.99 Black Seed & Pumpkin Seed Oil Blend 16-20 Day Supply Premium Blend Black Seed Oil & Styrian Pumpkin Seed Oil offering Omega 6/9 EFA's #14008 Regular price: $28.00Introductory Price: $22.99

The Recycle Bin does not appear on the desktop

View products that this article applies to.

On This Page

• SYMPTOMS
• CAUSE
• RESOLUTION
  • Method 1: Use the program that removed the Recycle Bin to restore the Recycle Bin
  • Method 2: Edit the registry to restore the Recycle Bin
  • Method 3: Use the Group Policy Object Editor to restore the Recycle Bin
• WORKAROUND

Expand all | Collapse all

SYMPTOMS

The Recycle Bin does not appear on the desktop in Windows XP or in Windows Vist...

The Recycle Bin does not appear on the desktop in Windows XP or in Windows Vista. Therefore, you cannot restore a file that was deleted.

Back to the top

CAUSE

This issue may occur if any of the following conditions is true: A third-party...

This issue may occur if any of the following conditions is true:

• A third-party program was used to hide the Recycle Bin.
• The TweakUI program was used to hide the Recycle Bin.
• The registry information for the Recycle Bin was deleted.
• A Group Policy setting was used to hide the Recycle Bin.
  
  Note Windows XP Home Edition does not support Group Policy.

Back to the top

RESOLUTION

To resolve this issue in Windows Vista, follow these steps:Click Start, and the...

To resolve this issue in Windows Vista, follow these steps:

1. Click Start, and then click Control Panel.
2. Click Appearance and Personalization, click Personalization, and then click Change desktop icons.
3. Click to select the Recycle Bin check box, and then click OK.

To resolve this issue in Windows XP, use one of the following methods.

Back to the top

Method 1: Use the program that removed the Recycle Bin to restore the Recycle Bin

If you used the TweakUI program to hide the Recycle Bin, follow these steps to restore the Recycle Bin to the desktop:

1. Click Start, and then click Run.
2. In the Open box, type regedit, and then click OK.
3. Locate the following registry key:
   HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel
4. In the right pane, right-click the following registry DWORD value, and then click Modify:
   {645FF040-5081-101B-9F08-00AA002F954E}
5. In the Value data box, type 0, and then click OK. (The TweakUI utility sets this value to 1 to hide the Recycle Bin icon.)
6. Quit Registry Editor.

Back to the top

Method 2: Edit the registry to restore the Recycle Bin

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756 (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows

Note This procedure does not work if the system administrator used a Group Policy setting to hide the Recycle Bin (or "All Icons") on the Desktop.

To edit the registry to make the Recycle Bin icon reappear on the desktop, follow these steps:

1. Click Start, and then click Run.
2. In the Open box, type regedit, and then click OK.
3. Locate the following registry key:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Desktop\NameSpace
4. Right-click the registry key that you located in step 3, point to New, and then click Key.
5. Type {645FF040-5081-101B-9F08-00AA002F954E}, and then press ENTER.
6. Click the new {645FF040-5081-101B-9F08-00AA002F954E} key that you created in step 5.
7. In the right pane, double-click the (Default) entry.
8. In the Edit String dialog box, type Recycle Bin in the Value data box, and then click OK.
9. Quit Registry Editor.

Back to the top

Method 3: Use the Group Policy Object Editor to restore the Recycle Bin

If the system administrator used a Group Policy setting to hide the Recycle Bin or "All Icons" on the Desktop, you may have to contact the system administrator to restore the Recycle Bin icon.

Note The following procedures works only on Windows XP Professional.

The system administrator can either use the Group Policy Object Editor (GPEDIT.msc) or manually remove the registry information (that was created through the Group Policy Object Editor) for the Recycle Bin to restore the Recycle Bin icon to the Desktop.

• To use the Group Policy Object Editor to restore the Recycle Bin:
  1. Click Start, click Run, type GPEDIT.MSC in the Open box, and then click OK.
  2. Under User Configuration, click Administrative Templates, and then double-click Desktop.
  3. Double-click Remove Recycle Bin icon from the desktop.
  4. Click the Setting tab, click Not Configured, and then click OK.
• To use Registry Editor to restore the Recycle Bin:
  1. Click Start, and then click Run .
  2. In the Open box, type regedit, and then click OK.
  3. Locate the following registry key:
     HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\NonEnum
  4. Click the registry key that you located in step 3, and then in the right pane, click the following registry DWORD value:
     {645FF040-5081-101B-9F08-00AA002F954E}
  5. On the Edit menu, click Delete, and then click Yes.
  6. Quit Registry Editor.
     
     The Recycle Bin icon reappears on the Desktop.

Back to the top

WORKAROUND

If you cannot restore the Recycle Bin by using the resolutions that are listed i...

If you cannot restore the Recycle Bin by using the resolutions that are listed in this article, work around this issue by creating a shortcut to the Recycle Bin:

1. Click Start, and then click My Computer.
2. On the Tools menu, click Folder Options.
3. Click the View tab, and then click to clear the Hide protected operating system files (Recommended) check box.
4. Click Yes when the warning message appears, and then click OK to close the Folder Options dialog box.
5. Click Folders on the toolbar.
   
   Note If Folders is not visible on the toolbar, point to Toolbars on the View menu, and then click Standard Buttons.
6. In the left pane, under Folders, locate the Recycle Bin folder, and then drag the Recycle Bin folder to the desktop.
7. On the Tools menu, click Folder Options.
8. Click the View tab, and then click to select the Hide protected operating system files (Recommended) check box. Click OK.

Note This procedure does not re-create the original icon. However, this procedure restores most of the features of the Recycle Bin, including the following:

• Delete a file by dragging it to the Recycle Bin icon on your Desktop.
• Retrieve a file that you deleted by double-clicking the Recycle Bin icon on your Desktop, right-clicking the file that you want to retrieve, and then clicking Restore.
• Empty the Recycle Bin by right-clicking the Recycle Bin icon on your Desktop, and then clicking Empty Recycle Bin.

When you use these step to work around the problem, you cannot right-click the Recycle Bin shortcut to access the Recycle Bin Properties. To set properties for the Recycle Bin, follow these steps:

1. Double-click the Recycle Bin shortcut on the Desktop. The Recycle Bin folder opens.
2. In the upper left corner of the Recycle Bin folder, right-click the Recycle Bin icon, and then click Properties.

Back to the top

---

APPLIES TO

• Microsoft Windows XP Home Edition
• Microsoft Windows XP Professional
• Windows Vista Enterprise
• Windows Vista Home Basic
• Windows Vista Home Premium
• Windows Vista Starter
• Windows Vista Ultimate

Back to the top

Keywords:

kbhowto kbprb KB810869

Back to the top

Provide feedback on this information

Did this information solve your problem?

Yes

No

I don't know

Was this information relevant?

Yes

No

What can we do to improve this information?

To protect your privacy, do not include contact information in your feedback.