> One way to do that is to 'resize' datafile when no one is using it. (alter
> database datafile '<full_file_name>' resize <whatever_size_you_want>;
> Other way is to drop the TEMP tablespace completely, remove the datafile
> at OS level, Recreate TEMP tablespace with whatever size datafile you
> want.
> I would do either of these activities when NO users are accessing the
> database (just to be safe..) May be open it in 'restricted mode'.
> After done, I would backup the controlfile to trace and let the users in.
> (Taking a database backup at this time is a decision you need to take,
> given that this is only a temp tablespace, I may let the normal backup
> schedule take care of the backup).
> HTH..
> - Kirti
>
> -----Original Message-----
> From: Kader Ben [SMTP:kaderb_at_yahoo.com]
> Sent: Wednesday, June 21, 2000 11:12 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-00600
>
> Hi listers,
> Since yesterday the udump trace file is growing
> too fast by the above error message. When I called the
> oracle customer support, they suspect that my temp
> tablespace with 2G is the source of the problem. So I
> want reduce this tablespace, could someone give the
> step by step to how to recreate the smaller one?
> TIA
>
> Ben
>
> -----------------
> Dump file
>
> /opt/Oracle/admin/infi/udump/infi_ora_29610.trc
> Oracle8 Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
> ORACLE_HOME = /opt/Oracle/product/8.0.5
> System name: SunOS
> ......
> Redo thread mounted by this instance: 1
> Oracle process number: 39
> Unix process pid: 29610, image: oracleinfi
>
> *** SESSION ID:(111.1571) 2000.06.20.13.16.50.000
> *** 2000.06.20.13.16.50.000
> ksedmp: internal or fatal error
> ORA-00600: internal error code, arguments: [17588],
> [21068724], [], [], [], [], [], []
> ORA-27069: skgfdisp: attempt to do I/O beyond the
> range of the file
> Additional information: 522925
> Additional information: 16
> Additional information: 522197
> Current SQL statement for this session:
> Select * From webfin_actu where APPROVED='OUI' AND
> TYPENEWS='int' AND DATENEWS <= '2000/06/20' ORDER BY
> DATENEWS DESC, TIMENEWS DESC
> ----- Call Stack Trace -----
> calling call entry
> argument values in hex
> location type point (?
> means dubious value)
> -------------------- -------- --------------------
> ----------------------------
> ksedmp()+148 CALL ksedst()+0 540
> ? 0 ? EFFFCC34 ?
>
> EFFFC6D8 ? EFFFC6BC ? 0 ?
> kgeriv()+196 PTR_CALL 00000000 3 ?
> 0 ? 0 ? 258 ? 1 ? 44B4 ?
> kgesiv()+96 CALL kgeriv()+0
> 1038C24 ? 107990C ? DAF1A0 ?
> 1 ?
> EFFFD250 ? 1030594 ?
> ----------------
> Alert log file
>
> Additional information: 524160
> Additional information: 16
> Additional information: 522197
> Tue Jun 20 13:44:54 2000
> Errors in file
> /opt/Oracle/admin/infi/udump/infi_ora_3678.trc:
> ORA-00600: internal error code, arguments: [17588],
> [21068724], [], [], [], [], [], []
> ORA-27069: skgfdisp: attempt to do I/O beyond the
> range of the file
> Additional information: 524160
> Additional information: 16
> Additional information: 522197
> ---------------------------
> Tablespaces
>
> /Oradata/dsk1/dbs/infi/infi-syst SYSTEM
> 157286400 AVAILABLE
> /Oradata/dsk1/dbs/infi/infi-rbs0 RBS
> 146800640 AVAILABLE
> /Oradata/dsk1/dbs/infi/infi-temp TEMP
> 2159886336 AVAILABLE
> /Oradata/dsk1/dbs/infi/infi-tool TOOLS
> 15728640 AVAILABLE
> /Oradata/dsk1/dbs/infi/infi-appe APPELLE
> 10485760 AVAILABLE
> /Oradata/dsk1/dbs/infi/infi-infi INFI_DAT
> 178257920 AVAILABLE
> /Oradata/dsk1/dbs/infi/infi-infi INFI_IDX
> 10485760 AVAILABLE
> /Oradata/dsk1/dbs/infi/infi-proj PROJ_DAT
> 10485760 AVAILABLE
> /Oradata/dsk1/dbs/infi/infi-proj PROJ_IDX
> 10485760 AVAILABLE
> /Oradata/dsk1/dbs/infi/infi-pers PERSO
> 83886080 AVAILABLE
> /Oradata/dsk1/dbs/infi/infi-infi INFI_DAT
> 314572800 AVAILABLE
> ------------------------------------------------------
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: Kader Ben
> INET: kaderb_at_yahoo.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 Wed Jun 21 2000 - 11:37:24 CDT
