funny how my previous email seems to have been truncated where I put
three dots [ie , "."] to
signifiy 3 lines.
Resend :
For a critical database where I want to be SURE that the file system has
enough space for the
TempFile, I run a large
SELECT * FROM DBA_SOURCE
UNION
SELECT * FROM DBA_SOURCE
UNION
<a dot here>.
<another dot here>.
<and a third dot here, signifiying 3 lines>.
immediately after I startup the Instance [fortunately, the instance
startup is supposed to be
only once in 1 or 2 years but has practically been once in 3
months].
Hemant
At 01:54 PM 17-09-03 -0800, you wrote:
Any comments on the following??
When creating index, got
ORA-00603: ORACLE server session terminated by fatal error
apparently caused by
ksedmp: internal or fatal error
ORA-01114: IO error writing block to file 121 (block # 149)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 16384
Additional information: 49152
which I determined was caused by attempted write to temp tablespace using
a
tempfile. The tablespace was dropped and recreated, and all was well
again.
What I think MIGHT have happened is the tablespace created weeks ago,
but
not used. So it didn't grab any actual storage. In the mean time, some
of
the storage might have been used by something else, but storage was
released. Now tempfile goes to grab some space, but filesystem is
all
screwed up about what storage the tempfile should be grabbing.
Does this sound plausible?
Is there something else going on here?
Is this another one of those spiffy cool things in Oracle that are
just
something else to go wrong and make life a bitch?
Note that the index create blew up immediately, so the original
tempfile
never grabbed any space.
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: Stephen Lee
INET: Stephen.Lee@DTAG.Com
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California -- Mailing list and web hosting
services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@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).
Date: Thu, 18 Sep 2003 08:34:46
-0800
To: Multiple recipients of list ORACLE-L
<ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: Hemant K Chitale <hkchital@singnet.com.sg>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Organization: Fat City Network Services, San Diego, California
For a critical database where I want to be SURE that the file system has
enough space for the
TempFile, I run a large
SELECT * FROM DBA_SOURCE
UNION
SELECT * FROM DBA_SOURCE
UNION
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: hkchital@singnet.com.sg
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@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).
Received on Fri Sep 19 2003 - 10:24:40 CDT
