- Community Home
- >
- Servers and Operating Systems
- >
- Operating System - HP-UX
- >
- General
- >
- Re: Table space drop not seeing new size
-
- Forums
-
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
- HPE Blog, Austria, Germany & Switzerland
- Blog HPE, France
- HPE Blog, Italy
- HPE Blog, Japan
- HPE Blog, Middle East
- HPE Blog, Russia
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
-
Blogs
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Blog, Latin America
- HPE Blog, Middle East
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
-
Information
- Community
- Welcome
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Tips and Tricks
- Resources
- Announcements
- Email us
- Feedback
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Aruba Airheads Community
- Enterprise.nxt
- HPE Dev Community
- Cloud28+ Community
- Marketplace
-
Forums
-
Blogs
-
Information
-
English
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-04-2011 11:32 PM
05-04-2011 11:32 PM
Table space drop not seeing new size
The dba has dropped his table spaces with delete files. The files are no longer there and when i do a du i see the smaller size but bdf is showing the old size.
I am on a rx 6600 with enterprise eva.
hp ux 11.31 september 2010 relese
any suggestions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-04-2011 11:35 PM
05-04-2011 11:35 PM
Re: Table space drop not seeing new size
Shibin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-04-2011 11:51 PM
05-04-2011 11:51 PM
Re: Table space drop not seeing new size
It seems to have come right now there seems to be a delay. not sure why.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-05-2011 12:03 AM
05-05-2011 12:03 AM
Re: Table space drop not seeing new size
/dev/vg03/lvol1 835584000 820548225 14096160 98% /oradata1
/home/oracle bdf
/dev/vg03/lvol1 835584000 718836265 109451123 87% /oradata1
I dropped datafile around 8:30 and only saw new space round 9;30
F
rom oracle I ran the following cmd:
drop tablespace users including contents and datafiles;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-05-2011 12:09 PM
05-05-2011 12:09 PM
Re: Table space drop not seeing new size
I've seen similar behaviour with Oracle/Unix.
This is a good reason to do your UNIX system management outside of Oracle. Oracle likes to think they can do stuff better than the other vendors ( ASM, EXADATA, others ), but they are often wrong. If you've bought into ASM and that product actually uses files on a filesystem, you'll have to ask Oracle whats up. If this is not ASM, remove you own files.
Or, after you do the drop tablespace ..., wait just a few minutes, then go to the command line on UNIX and issue:
sync;sync;sync;sync
... and see if that does anything for you.
BTW, if Oracle removes but does not unlink a datafile, DU will NOT see it and therefore not report it, however bdf still knows the space is not available as free yet.
If you want to experiment with this in a test database, do the drop tablespace, then after it completes, do a shutdown abort on your Oracle Instance. Chances are, this will remove the delay!!!
-klb
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-05-2011 06:42 PM
05-05-2011 06:42 PM
Re: Table space drop not seeing new size
Shibin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-06-2011 01:30 PM - last edited on 07-11-2011 08:45 AM by Kevin_Paul
05-06-2011 01:30 PM - last edited on 07-11-2011 08:45 AM by Kevin_Paul
Re: Table space drop not seeing new size
Hi,
What may help is forcing a checkpoint or a logswitch in oracle, because this forces the oracle processes to initiate their pending writes (yes, you may think of this as a "sync" inside oracle :-)
Here is an old thread about this topic.
http://h30499.www3.hp.com/t5/System-Administration/Unnamed-inode-when-droping-tablespace/m-p/3746935#M257063
Best regards
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-06-2011 03:25 PM
05-06-2011 03:25 PM
Re: Table space drop not seeing new size
Agree there.
alter system checkpoint;
would be less destructive than:
shutdown abort;
...and would actually do the same thing in this context.
-klb
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-07-2011 03:42 AM
05-07-2011 03:42 AM
Re: Table space drop not seeing new size
Volker
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2021 Hewlett Packard Enterprise Development LP