Re: 90GB table on Windows 2000

"kc" <kc_news2000_at_yahoo.com> wrote in message news:a20fe1ab.0210121509.14a93df7_at_posting.google.com...
> Most Windows patches require reboots, even in 2000 and XP. Every
> reboot clears out the SGA, interrupts work, etc.

Assuming you are a 24/7 shop with no downtime even for planned maintenance. These places do exist but for most businesses not planning maintenance is arguably as big a no-no as not patching.

> This is cut and pasted from the one of the Windows
> Oracle servers I administer:

This is interesting see comments

>
> Successful Thursday, October 03, 2002 Q323255: Security Update
> (Windows 2000)
> Read more... Automatic update

Patch for HTML help vulnerability.

> Successful Sunday, September 29, 2002 Q324096: Security Update
> (Windows 2000)
> Read more... Automatic update

Patch for Front Page server extensions for Office!

> Successful Saturday, September 21, 2002 Microsoft Internet Explorer 6
> Service Pack 1 (Windows 2000)
> Read more... Web site

Fair comment.

> Successful Friday, September 20, 2002 Q324380: Security Update
> (Windows 2000)
> Read more... Automatic update

Patch for terminal services/remote desktop.

> Successful Friday, September 20, 2002 Q329077: Security Update
> Read more... Automatic update

Fair play. Java VM Patch.

> Successful Friday, August 30, 2002 Q323172: Security Update
> Read more... Automatic update

Patch for authenticode spoofing. Probably shouldn't be reading email or browsing the web on your db server.

> Successful Friday, August 23, 2002 Q326830: Security Update (Windows
> 2000)
> Read more... Automatic update

Patch for network shares on tcp ports 445 & 139.

> Successful Friday, August 23, 2002 Q323759: August, 2002 Cumulative
> Patch for Internet Explorer 5.5 SP2
> Read more... Automatic update

Fair enough. Why did IE get upgraded between August and September?

> Successful Saturday, August 17, 2002 Q326886: Security Update
> Read more... Automatic update

Privilege raising vulnerability for authenticated users. Could be avoided entirely by ensuring only DBA/SysAdmin gets to log onto production server interactively.

> Successful Wednesday, July 31, 2002 Q320920: Security Update (Windows
> Media Player 6.4)
> Read more... Automatic update

Media Player !

> Successful Thursday, July 11, 2002 Q318138: Security Update
> Read more... Automatic update

Patch for remote access phonebook!

etc

> That's a lot of reboots that aren't even due to system crashes.

Its also a lot of software that has no business being anywhere near a database server.

Yes windows does still require more reboots than it should. However it should also cope with patching at no more frequently than once a month for the services you actually use.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************