Space... confusion
Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)
DID happen... now trying desperately to find out WHY it happened. The
'problem' effected our biggest client. I need to find out what happened so
it doesn't happen again...
File system now at 92%, but will need to add dasd in the near future for
growth
one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level...
Anybody have any ideas how something that can't happen, did? Anyone ever
seen this kind of weirdness before?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H
end
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
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).
RE: Space... confusion
April: I'm just guessing here, but is it a journaling file system? Could the journal be eating up your available space? HTH, Mike -Original Message- Sent: Thursday, October 10, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Please forgive the cross postings, but I am hoping that someone in all of the sets of eyes that see this might have an idea I haven't thought of. *** Facts ** aix 4.3.3 oracle 9.0.1.3 new instance, up for 2 weeks locally managed tablespaces nothing with autoextend on file system at 7:01 am was at 98% 12:00 altered index tablespaces to nologging (but this did not change the file sizes... checked) 12:30 users (it is not a transactional instance... it is strictly reporting) started getting Ora-01114 errors corresponding (roughly) to when the file system hit 100% The only thing in the file system are database files Nothing could have changed at OS level in that time..to my knowledge ITAR open, not much progress (re... that can't happen) DID happen... now trying desperately to find out WHY it happened. The 'problem' effected our biggest client. I need to find out what happened so it doesn't happen again... File system now at 92%, but will need to add dasd in the near future for growth one interesting finding found in the digging 9i created files of 2000m are 2097168384 k at os level 8i created and upgraded to 9i files of 2000m are 2097156096 at os level... Anybody have any ideas how something that can't happen, did? Anyone ever seen this kind of weirdness before? April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).
RE: Space... confusion
Which files were being reported in the ORA-01114s? Could you provide more
info as to the exact architecture of the db files and file system. For
example, is it a single file system and ALL database files (including redo
logs/archived logs/temp files/...) are stored on it. Are the control
files/dump files also stored there?
-Original Message-
Sent: Thursday, October 10, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L
Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)
DID happen... now trying desperately to find out WHY it happened. The
'problem' effected our biggest client. I need to find out what happened so
it doesn't happen again...
File system now at 92%, but will need to add dasd in the near future for
growth
one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level...
Anybody have any ideas how something that can't happen, did? Anyone ever
seen this kind of weirdness before?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H
end
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fink, Dan
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).
RE: Space... confusion
Is journaling, but journal isn't in that file system, just on the raw part
of the volume group
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
-Original Message-
Sent: Thursday, October 10, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L
April:
I'm just guessing here, but is it a journaling file system?
Could the journal be eating up your available space?
HTH,
Mike
-Original Message-
Sent: Thursday, October 10, 2002 8:14 AM
To: Multiple recipients of list ORACLE-L
Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)
DID happen... now trying desperately to find out WHY it happened. The
'problem' effected our biggest client. I need to find out what happened so
it doesn't happen again...
File system now at 92%, but will need to add dasd in the near future for
growth
one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level...
Anybody have any ideas how something that can't happen, did? Anyone ever
seen this kind of weirdness before?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
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).
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H
end
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
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).
Re: Space... confusion
Are you using tempfiles ?
Just a hypothesis: Tempfiles are created sparse, so
you ask for 100M, but in reality only 1M might be
allocated. As people sort, you actually start needing
the 100M and kapow!
hth
connor
--- April Wells [EMAIL PROTECTED] wrote: Please
forgive the cross postings, but I am hoping
that someone in all of
the sets of eyes that see this might have an idea I
haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but
this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance...
it is strictly reporting)
started getting Ora-01114 errors corresponding
(roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that
time..to my
knowledge
ITAR open, not much progress (re... that can't
happen)
DID happen... now trying desperately to find out WHY
it happened. The
'problem' effected our biggest client. I need to
find out what happened so
it doesn't happen again...
File system now at 92%, but will need to add dasd in
the near future for
growth
one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os
level
8i created and upgraded to 9i files of 2000m are
2097156096 at os level...
Anybody have any ideas how something that can't
happen, did? Anyone ever
seen this kind of weirdness before?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new
ideas and action.
Otherwise you will rust out. _Anonymous
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B
@268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H
end
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: April Wells
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).
=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
Remember amateurs built the ark - Professionals built the Titanic
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
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).
RE: Space... confusion
April - This is what I hear you saying:
- The database was set up on a file system, and there was room to spare.
- The file system ran out of space.
- Don't know what occurred to take up space, there should have been
nothing.
- The situation is fixed now. HOW??
If the above is true, I think your best bet may be to attempt to reproduce
the problem. But first, carefully measure everything, using something like
Unix's du -k command. I think that is the only way you will ever pin it
down. If you are essentially back to operating again, then get a snapshot
now.
One thought that just occurred to me, is to check the timestamps. If
something changed in size, the timestamp may have changed. I don't believe
the Oracle datafiles are updated in a read-only situation. The control file
probably gets written to frequently.
-Original Message-
Sent: Thursday, October 10, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
Is journaling, but journal isn't in that file system, just on the raw part
of the volume group
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
-Original Message-
Sent: Thursday, October 10, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L
April:
I'm just guessing here, but is it a journaling file system?
Could the journal be eating up your available space?
HTH,
Mike
-Original Message-
Sent: Thursday, October 10, 2002 8:14 AM
To: Multiple recipients of list ORACLE-L
Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)
DID happen... now trying desperately to find out WHY it happened. The
'problem' effected our biggest client. I need to find out what happened so
it doesn't happen again...
File system now at 92%, but will need to add dasd in the near future for
growth
one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level...
Anybody have any ideas how something that can't happen, did? Anyone ever
seen this kind of weirdness before?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
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).
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H
end
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
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
Re: Space... confusion
Probably due to tempfiles in your TEMPORARY tablespace... Tempfiles are sparsely populated files (not certain if that is the correct term). That is, if you display them with the command ls -l, you'll see them apparently consuming the full amount of space you specified when you created them. However, if you get the chance, try to perform a df -k against the file-system in question before and after you ADD TEMPFILE and you'll see that the space consumed within the file-system doesn't change. Then, as sorting or global-temporary-table activity hits the TEMP tablespace, you'll see changes in df -k... In essence, there is a difference between the output displayed by ls -l and df -k, and the df command is correct. I'm not sure how the du command reacts to all this... Not really sure how to explain it, but I'm pretty that this is what you are experiencing. Rather annoying, isn't it? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 9:13 AM Please forgive the cross postings, but I am hoping that someone in all of the sets of eyes that see this might have an idea I haven't thought of. *** Facts ** aix 4.3.3 oracle 9.0.1.3 new instance, up for 2 weeks locally managed tablespaces nothing with autoextend on file system at 7:01 am was at 98% 12:00 altered index tablespaces to nologging (but this did not change the file sizes... checked) 12:30 users (it is not a transactional instance... it is strictly reporting) started getting Ora-01114 errors corresponding (roughly) to when the file system hit 100% The only thing in the file system are database files Nothing could have changed at OS level in that time..to my knowledge ITAR open, not much progress (re... that can't happen) DID happen... now trying desperately to find out WHY it happened. The 'problem' effected our biggest client. I need to find out what happened so it doesn't happen again... File system now at 92%, but will need to add dasd in the near future for growth one interesting finding found in the digging 9i created files of 2000m are 2097168384 k at os level 8i created and upgraded to 9i files of 2000m are 2097156096 at os level... Anybody have any ideas how something that can't happen, did? Anyone ever seen this kind of weirdness before? April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman 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).
RE: Space... confusion
Anything reported in the system logs?
Can you get the SAs to run the 'errpt' report to make sure there were no
disk related problems.
Do the permissions on the mount point directory keep others away?
Once I had a smart developer(and a newbie DBA), who pointed his vi
'directory' to one of the data files', since it had more empty space and was
set to 777 !!
- Kirti
-Original Message-
Sent: Thursday, October 10, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)
DID happen... now trying desperately to find out WHY it happened. The
'problem' effected our biggest client. I need to find out what happened so
it doesn't happen again...
File system now at 92%, but will need to add dasd in the near future for
growth
one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level...
Anybody have any ideas how something that can't happen, did? Anyone ever
seen this kind of weirdness before?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H
end
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
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).
RE: Space... confusion
Oh good... isn't that special...
du -k says they are 3401728 k... not 'quite' 4000 meg... that makes sense.
anywhere I can look this up to do more research (ie... is there a friendly
manual)?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
-Original Message-
Sent: Thursday, October 10, 2002 12:44 PM
To: Multiple recipients of list ORACLE-L
Probably due to tempfiles in your TEMPORARY tablespace...
Tempfiles are sparsely populated files (not certain if that is the correct
term). That is, if you display them with the command ls -l, you'll see
them apparently consuming the full amount of space you specified when you
created them. However, if you get the chance, try to perform a df -k
against the file-system in question before and after you ADD TEMPFILE and
you'll see that the space consumed within the file-system doesn't change.
Then, as sorting or global-temporary-table activity hits the TEMP
tablespace, you'll see changes in df -k...
In essence, there is a difference between the output displayed by ls -l
and df -k, and the df command is correct. I'm not sure how the du
command reacts to all this...
Not really sure how to explain it, but I'm pretty that this is what you are
experiencing. Rather annoying, isn't it?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 9:13 AM
Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance... it is strictly
reporting)
started getting Ora-01114 errors corresponding (roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that time..to my
knowledge
ITAR open, not much progress (re... that can't happen)
DID happen... now trying desperately to find out WHY it happened. The
'problem' effected our biggest client. I need to find out what happened
so
it doesn't happen again...
File system now at 92%, but will need to add dasd in the near future for
growth
one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os level
8i created and upgraded to 9i files of 2000m are 2097156096 at os level...
Anybody have any ideas how something that can't happen, did? Anyone ever
seen this kind of weirdness before?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
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).
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
RE: Space... confusion
At the OS level, the files are 4000 meg. If they are created sparse, would
it show at the OS level?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
-Original Message-
Sent: Thursday, October 10, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L
Are you using tempfiles ?
Just a hypothesis: Tempfiles are created sparse, so
you ask for 100M, but in reality only 1M might be
allocated. As people sort, you actually start needing
the 100M and kapow!
hth
connor
--- April Wells [EMAIL PROTECTED] wrote: Please
forgive the cross postings, but I am hoping
that someone in all of
the sets of eyes that see this might have an idea I
haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with autoextend on
file system at 7:01 am was at 98%
12:00 altered index tablespaces to nologging (but
this did not change the
file sizes... checked)
12:30 users (it is not a transactional instance...
it is strictly reporting)
started getting Ora-01114 errors corresponding
(roughly) to when the file
system hit 100%
The only thing in the file system are database files
Nothing could have changed at OS level in that
time..to my
knowledge
ITAR open, not much progress (re... that can't
happen)
DID happen... now trying desperately to find out WHY
it happened. The
'problem' effected our biggest client. I need to
find out what happened so
it doesn't happen again...
File system now at 92%, but will need to add dasd in
the near future for
growth
one interesting finding found in the digging
9i created files of 2000m are 2097168384 k at os
level
8i created and upgraded to 9i files of 2000m are
2097156096 at os level...
Anybody have any ideas how something that can't
happen, did? Anyone ever
seen this kind of weirdness before?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new
ideas and action.
Otherwise you will rust out. _Anonymous
begin 666 InterScan_Disclaimer.txt
MM 5AE(EN9F]R;6%T:6]N
M(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!SM
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T
M:4@:6YT96YD960@=7-EM
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
MM 2!PFEV:6QE9V5D(%N
M9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@M
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L
M;W-UF4L('5S92!OB!CM
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
MM ;B!T:4@:6YT96YD960@
MF5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B
MM@268@6]U(AA=F4@F5C96EV960@=AIR!M97
MM 86=E(EN(5RF]R+!P
M;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961IM
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!O
MF%T92!37-T96US+!)M
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
MM 96YS=7)E('1H870@86YY
M(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%SM
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A
M8V-E'0@;F\@;EA8FELM
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
MM ;V9T=V%R92!V:7)UV5S
M(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5RM
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI
M;F@86YY(%T=%C:UE +;G0N#0H-@T*#0H M
M %.$MM
M -- M
M P,%!3% 3%% 4(% /)#)!, ORACLE-L FAQ:M (440://777./2!!1.#
M/-M -- M
M A54(/2: A02), W%,,3M INET: !7%,,3@#3%$
M'%.#/-M M
M F!4 C)49 N%47/2+ S%26)#%3-- 858-538 (440://777.!4#)49.
M#/-M S!. D)%'/, C!,)/2.)!-- M!),).'
M (/34).' 3%26)#%3M M
M- -#P,I;;]I03U4DQ3!@!DC
MS0%4P#0233AP#0)3;023 #14TP1Q;0%#
MV@+4U)U4E8!@5 R53@SS0#CU!0)(8] $T ![4U)U4E1R0 3A 3K0
M %!0#14TP1Q0(KY.3 3@S%1!0 0#3A0 SSE 20+\
MH8[)3;+0 #T@%!0#@310#Q@#0233
MAP#4U 3U0%P3E % !DCS23@ .3U0#06;03
M$SP$Q3A %!0*);, SS303A !CT@#U!4@3@#2Q0$U0DPTB0B3AR3@+0
M
M '777;0 /../
M2 M#D/.!,$M !11!H\]==XU%$CSU
MUUSC
RE: Space... confusion
That is it EXACTLY... thank you.. it was created sparsely, du -ak gives what
df -k believes, but ls -al gives what Oracle thinks it is... Now if I can
just find the manual to research the logic behind why.
Okay... Oracle's answer was it can't happen, therefore it didn't happen and
it therefore won't happen again.
Thank you... so much.
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
+;G0N#0H-@T*#0H
end
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
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).
RE: Space... confusion
Title: RE: Space... confusion April, 2000M = 2097152000 2097168384 - 2097152000 = 16384 = 16K 2097156096 - 2097152000 = 4096 = 4K OS size equal to ORACLE size plus 1 FS block. Check FS blocksize. Alex. -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Subject: Space... confusion one interesting finding found in the digging 9i created files of 2000m are 2097168384 k at os level 8i created and upgraded to 9i files of 2000m are 2097156096 at os level...
