deleted file size didn't update the available O.S. disk space

Printable View

08-13-2004, 05:21 AM
reydp

deleted file size didn't update the available O.S. disk space

SOLARIS 8
ORACLE 8.1.6

I have this weird scenario,
I have drop a tablespace that is used by an RBS. I intend to recreate a bigger TABLESPACE for a bigger RBS.

After I drop the tablespace, I issue
the command in o.s.:
rm RBSbig01.dbf

the command was successful because it didn't feedback any error.
but to my surprise, the 500M size of that file didn't reflect the AVAILABLE size as i issue a
df -k

it was still the same before I remove the datafile.

Any experience of such kind guys, pls share, as again I am very much short of resource the only remaining file system that I can use is the one where ARCHiving resides?

Thanks in advance.
08-13-2004, 05:44 AM
pando

well I know in Tru64 or HP-UX it takes sometime to free the space at OS level however I am not aware of this behavious on Sun Solaris
08-13-2004, 06:04 AM
reydp

thanks for your response PANDO,
If I can only restart the server itself to accomdodate my needs then I could have done it now, to confirm also your explanation.
But the server is in 24X7, so may have to wait for a little while and hoping that HP-UX shares the same behaviour.
:o
08-13-2004, 08:08 AM
reydp

you got it right PANDO,
I've waited for at least an hour and now the avail size of the disk space was updated. THANKS alot.:D
08-13-2004, 08:10 AM
abhaysk

Quote:

Originally posted by reydp
I've waited for at least an hour and now the avail size of the disk space was updated.

This sucks aint it?? in this respect Windows is good :D
08-13-2004, 08:15 AM
DaPi

Quote:

Originally posted by abhaysk
This sucks aint it?? in this respect Windows is good :D

Hey Jeff! Did you see that? Hey Jeff, Jeff! DID YOU SEE THAT?
08-13-2004, 08:15 AM
reydp

Quote:

Originally posted by abhaysk
This sucks aint it?? in this respect Windows is good :D

In a way yes ;) ,
but I'm not sure if the behaviour is still the same with verion 9:)
And yet, who among us will prefer using Windows in return to UNIX?
:rolleyes:
08-13-2004, 08:20 AM
abhaysk

Quote:

Originally posted by reydp
And yet, who among us will prefer using Windows in return to UNIX?
:rolleyes:

dam our customers .. they do ;) ..

PS we have some DB servers 2 to 3 TB on Windows .. ( Jeff are you seeing this post? )
08-13-2004, 08:26 AM
reydp

Quote:

Originally posted by abhaysk
[B
PS we have some DB servers 2 to 3 TB on Windows .. ( Jeff are you seeing this post? ) [/B]

Nahhh...
maybe 10 year from now they could. :p
08-13-2004, 08:27 AM
marist89

Quote:

Originally posted by abhaysk
dam our customers .. they do ;) ..

PS we have some DB servers 2 to 3 TB on Windows .. ( Jeff are you seeing this post? )

You can pull a 34' camper with a Honda Civic. That doesn't make it the smart thing to do.
08-13-2004, 08:29 AM
marist89

Quote:

Originally posted by abhaysk
This sucks aint it?? in this respect Windows is good :D

In a lot of respects Windoz is good:
1. It has a pretty gui that a anybody with a HS diploma can administer.
2. Thinking, thinking, thinking

nope, I guess that's about it...
08-13-2004, 08:30 AM
gandolf989

Quote:

Originally posted by marist89
You can pull a 34' camper with a Honda Civic. That doesn't make it the smart thing to do.

Can I borrow your Honda Civic? :D
08-13-2004, 08:33 AM
marist89

Quote:

Originally posted by gandolf989
Can I borrow your Honda Civic? :D

sure, but the clutch may be a little loose...
08-13-2004, 09:14 AM
abhaysk

Quote:

Originally posted by marist89
In a lot of respects Windoz is good:
1. It has a pretty gui that a anybody with a HS diploma can administer.
2. Thinking, thinking, thinking

nope, I guess that's about it...

I hope my customers understand this .. :p

well there are some more good things..

2) registry
3) lock the file in use .. so you cannot delete unless released..
sometimes this sucks also..

Abhay.
08-13-2004, 09:34 AM
marist89

Quote:

Originally posted by abhaysk

2) registry

you consider that a good thing?

Quote:

3) lock the file in use .. so you cannot delete unless released..
sometimes this sucks also..

yes, you've got to love a filesystem that is so ancient that it has to put a lock on it's files so it can operate on them. I wrote a filesystem in college that did the same thing...
08-13-2004, 10:13 AM
abhaysk

Quote:

Originally posted by marist89
you consider that a good thing?

In some scenario, yes it is..

Quote:

Originally posted by marist89
yes, you've got to love a filesystem that is so ancient that it has to put a lock on it's files so it can operate on them. I wrote a filesystem in college that did the same thing...

Indeed this is lovable.. Jus think of the miscreant deleting Oracle Datafiles when DB is up and running..
08-13-2004, 10:28 AM
hacketta1

Quote:

Indeed this is lovable..

Unless your running Netbackup and have turned logging on and then off. Can't delete the logs without stopping the services, and sometimes even that doesn't work!
08-13-2004, 10:33 AM
marist89

Quote:

Originally posted by abhaysk

Indeed this is lovable.. Jus think of the miscreant deleting Oracle Datafiles when DB is up and running..

An OS where you have to worry about a miscreant coming in...priceless.
08-13-2004, 10:39 AM
abhaysk

Quote:

Originally posted by hacketta1
Unless your running Netbackup and have turned logging on and then off. Can't delete the logs without stopping the services, and sometimes even that doesn't work!

Thas why ..

Quote:

Originally posted by abhaysk
..
sometimes this sucks also..

Abhay.
08-13-2004, 10:57 AM
DaPi

Quote:

Originally posted by marist89
. . . a filesystem that is so ancient . . .

UNIX, hmmmm, 1969 or there abouts, wasn't it? . . . don't tell me they've changed something since then?

Nice quote from the Bell Labs site:
"Before Multics there was chaos, and afterwards, too"
08-13-2004, 11:21 AM
marist89

Quote:

Originally posted by DaPi
UNIX, hmmmm, 1969 or there abouts, wasn't it? . . . don't tell me they've changed something since then?

the difference between an OS that has evolved and a gui that is built on top of DOS.
08-13-2004, 11:59 AM
Axr2

To initial poster - try issuing a "sync" the next time it happens. It has worked for me in the past on 2.6.

----------

Maintenance Commands sync(1M)

NAME
sync - update the super block

SYNOPSIS
sync

DESCRIPTION
sync executes the sync system primitive. If the system is to
be stopped, sync must be called to insure file system
integrity. It will flush all previously unwritten system
buffers out to disk, thus assuring that all file modifica-
tions up to that point will be saved. See sync(2) for
details.
08-15-2004, 10:39 PM
reydp

Quote:

Originally posted by Axr2
To initial poster - try issuing a "sync" the next time it happens. It has worked for me in the past on 2.6.

----------

Maintenance Commands sync(1M)

NAME
sync - update the super block

SYNOPSIS
sync

DESCRIPTION
sync executes the sync system primitive. If the system is to
be stopped, sync must be called to insure file system
integrity. It will flush all previously unwritten system
buffers out to disk, thus assuring that all file modifica-
tions up to that point will be saved. See sync(2) for
details.

Thanks Axr2,
when it comes to a lesser size file, available free space is automatically updated. problem just occur when file with a bigger size involved.

But thanks anyway.:)

All times are GMT -4. The time now is 07:14 PM.