|
Hi!
Try with 2 dots, you might get the same behviour.
Or put a space before every dot. Some old unix mailers considered dot in
beginning of the line as end of mail...
Tanel.
----- Original Message -----
Sent: Friday, September 19, 2003 6:24
PM
Subject: Fwd: Re: Tempfile
weirdness
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: [EMAIL PROTECTED]
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:
[EMAIL PROTECTED] (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
<[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community
Forum
X-Sender: Hemant K Chitale
<[EMAIL PROTECTED]>
Sender:
[EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
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:
[EMAIL PROTECTED] 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:
[EMAIL PROTECTED] (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).
|
