Re: Patches

Mladen,

You prompted me for a question:

You said " ... you couldn't afford not to install patches...".

I am wondering how often one should install new patches - just the patch sets, or somehow individual patches. In the case of the later, how do you get info when there are new patches. What I used to do most of the time is to install patches only when I have a certain problem and support suggests a patch install.

Opinions, experience ?

Thanks.

Djordje

-----Original Message-----
From: Gogala, Mladen <MGogala_at_oxhp.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Wednesday, July 19, 2000 7:59 PM
Subject: RE: Ora 1652

>Obviously, this error tells you that Oracle cannot extend segment. Oracle
>can fail to extend a segment only because of the lack of the necessary
space
>in the tablespace. A common wisdom (and OFA, which is anything but the
>common wisdom)
>tells you to separate different object types into the different
tablespaces.
>Tablespace system should be used for DICTIONARY TRANSACTIONS ONLY. If you
>see somebody to use the tablespace SYSTEM as the temporary tablespace (see
>CREATE LUSER command options) please fell free to shoot the DBA. It would
>also
>be advisable to put the rollback segments into their separate tablespace
and
>(I know I'm asking too much now!) to separate tables and indexes not only
to
>the
>separate disks but to the separate controllers as well. When it comes to
the
>system safety, words like RAID-5, EMC, Legato Networker and DLT7000 robot
>and RMAN
>come into my mind. Running a well designed database with 95% uptime is an
>expensive proposition.
>If you were an internet company, like let's say E-Bay, then you couldn't
>afford
>not to install patches, not to have a hot standby system and not have even
a
>proper backup and keep your systems down for a week, could you?
>
>-----Original Message-----
>Sent: Wednesday, July 19, 2000 5:06 PM
>To: Multiple recipients of list ORACLE-L
>
>
>When I checked yesterday's alert logs, I found the following error:
>
>ORA-01652 unable to extend temp segment by (num) in tablespace SYSTEM.
>
>I've forgotten what the actual number was. The recommended action is to
add
>a datafile. However, when I checked the existing datafile, it is less than
>50% full, with 20 MB remaining, and 11 MB in the next available extent.
>
>Does anyone have any idea what is causing this? For now, I plan to see if
>the error occurs again, and then add another datafile if necessary. The
>error occurred during business hours (ie. when the database was in use) and
>we also have developers working on an update, although they are supposed to
>be working on the development database.
>
>Thanks.
>
>- Kristen Cameron
>Indian and Northern Affairs Canada
>Yellowknife, NT
>
>--
>Author: Kristen Cameron
> INET: cameronkgd_at_inac.gc.ca
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
Received on Thu Jul 20 2000 - 23:46:39 CDT