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
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 wo
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 1
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 y
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
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.
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 thin
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,
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 A
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/dum
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 th
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 autoexte
12 matches
Mail list logo
