Re: dbshut script - why shutdown so much???

2003-04-04 Thread Ray Stell
On Thu, Apr 03, 2003 at 06:58:37PM -0800, Connor McDonald wrote: All this discussion on shutdown does motivate me to ask why is everyone shutting down so frequently? -- Here are my reasons this past year: oracle security patches sun kernel patches power issues static configuration change 8i

RE: dbshut script - why shutdown so much???

2003-04-04 Thread April Wells
Title: RE: dbshut script - why shutdown so much??? Your reasons beat ours, Ray. We just reboot the box every weekend because we do and we always have. It is AIX, too. We don't even reboot our Win 2K machines as often. April Wells Oracle DBA/ Oracle Apps DBA -Original Message- From

RE: dbshut script - why shutdown so much???

2003-04-04 Thread Darrell Landrum
I once read an article in an IT publication (several years ago) in which the author stated that if you are still rebooting your Unix servers routinely, your Unix admins don't know what they're doing. Yes, the language was that harsh. I thought this was ludicrous for 2 reasons: 1) The author

RE: dbshut script - why shutdown so much???

2003-04-04 Thread Stephane Paquette
All our unix servers (+-25) are AIX 4.3. We reboot only if there is a problem. Stephane -Original Message- Landrum Sent: Friday, April 04, 2003 9:29 AM To: Multiple recipients of list ORACLE-L I once read an article in an IT publication (several years ago) in which the author stated

Re: dbshut script - why shutdown so much???

2003-04-04 Thread bill thater
[EMAIL PROTECTED] wrote: Your reasons beat ours, Ray. We just reboot the box every weekend because we do and we always have. It is AIX, too. We don't even reboot our Win 2K machines as often. there's also run away processes from poorly written third party software, or internally written for

RE: dbshut script - why shutdown so much???

2003-04-04 Thread Jesse, Rich
Oh joy! The ABORT argument again! ;) Is there a way to flush table monitoring counts before the ABORT, either in 8i or 9i? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message-

RE: dbshut script - why shutdown so much???

2003-04-04 Thread Jeremiah Wilton
On Fri, 4 Apr 2003, Darrell Landrum wrote: I once read an article in an IT publication (several years ago) in which the author stated that if you are still rebooting your Unix servers routinely, your Unix admins don't know what they're doing. Yes, the language was that harsh. I thought this

RE: dbshut script - why shutdown so much???

2003-04-04 Thread Deshpande, Kirti
In 9i Release 2 : exec dbms_stats.flush_database_monitoring_info Nothing of the sort in earlier releases... - Kirti -Original Message- Sent: Friday, April 04, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Oh joy! The ABORT argument again! ;) Is there a way to flush

RE: dbshut script - why shutdown so much???

2003-04-04 Thread Jesse, Rich
One more foot in the grave of us diehard IMMEDIATE fans (nee anti-ABORT). Good to know that it's an option! Now if I can just get all of our various software vendors to support anything above 8.1.7.2.0... Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED]

Re: dbshut script - why shutdown so much???

2003-04-03 Thread Connor McDonald
All this discussion on shutdown does motivate me to ask why is everyone shutting down so frequently? Almost without exception my ideal for any oracle database is a) never shut it down b) if you really do need to shut it down, then use abort c) if you are not allowed to use abort, then use

Re: dbshut script - why shutdown so much???

2003-04-03 Thread Jared Still
I'll agree to that. I've had many discussions with our SAP BASIS admin about this. They have to shutdown SAP periodically, and she was always asking to bounce the database. I always ask 'Why?', and would proceed to explain why not. She finally quit asking. ;) Jared On Thursday 03 April