- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Database Fragmentation
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- 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
- Report Inappropriate Content
тАО07-12-2004 11:23 PM
тАО07-12-2004 11:23 PM
Database Fragmentation
Before proceeding, we want first to clarify if fragmentation issues are happening or not.
So what we need is any sript that helps on discovering tables and tablespaces fragmentation and then how to recreate objects with the corect clauses to avoid it.
Thanks for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 11:42 PM
тАО07-12-2004 11:42 PM
Re: Database Fragmentation
http://www.think-forward.com/sql_scripts.htm
http://www.think-forward.com/sql/ts_free_frag.htm
http://www.orsweb.com/master-list/p-master-list.html
for scripts
For how to avoid
http://www.orsweb.com/downloads/sql/space_management/
Admin processes
Steve Steel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2004 12:56 AM
тАО07-13-2004 12:56 AM
Re: Database Fragmentation
two important things you may wish to consider for the operation you are trying to do:
1. Upgrade to 8.1.7.4.
2. Start using or convert all your Dictionary managed tablespaces (DMT) to Locally managed tablespaces (LMT) (which will allow you to NEVER do such a thing again in the future!!)
if you need any further assistance, please let us know.
best regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2004 01:48 AM
тАО07-13-2004 01:48 AM
Re: Database Fragmentation
Tablespaces:
Don't use autoextend because you'll lose the control of extents.
Coalesce the tablespaces:
select 'alter tablespace '||tablespace_name||' coalesce;'
from dba_free_space_coalesced
where percent_extents_coalesced < 50 and
tablespace_name not in ('SYSTEM','SYS')
Segments (tables and indexes):
First you may want to see the major problematic segments:
SELECT COUNT(*), segment_name
FROM DBA_EXTENTS
GROUP BY segment_name
ORDER BY 1 DESC
For the problematic extents you must redefine (increase) the storage values...
Tables:
ALTER TABLE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2004 01:53 AM
тАО07-13-2004 01:53 AM
Re: Database Fragmentation
Don't change anything on the SYS ans SYSTEM users:
SELECT COUNT(*), segment_name
FROM DBA_EXTENTS
where owner not in ('SYS','SYSTEM')
GROUP BY segment_name
ORDER BY 1 DESC