Message-Id: <10535.109998@fatcity.com> From: Kader Ben Date: Wed, 21 Jun 2000 07:57:04 -0700 (PDT) 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 ------------------------------------------------------ __________________________________________________