- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- tablespace 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
тАО12-24-2003 03:18 PM
тАО12-24-2003 03:18 PM
When I query dba_free_space to check bytes column, and I get
TABLESPACE_NAME BYTES
-------------------- ----------
SYSTEM 57344
SYSTEM 32768
SYSTEM 9854976
SYSTEM 52420608
TEMP 122880
TEMP 122880
TEMP 1843200
RBS1 1040384
TOOLS 1040384
OPC_TEMP 1024000
OPC_TEMP 1064960
and then I change the sql statement,
select tablespace_name,count(bytes)
from dba_free_spaces
group by tablespace_name
here the resultTABLESPACE_NAME COUNT(BYTES)
------------------------------ ------------
OPC_1 1
OPC_10 1
OPC_2 1
OPC_3 1
OPC_4 1
OPC_5 1
OPC_6 1
OPC_7 1
OPC_8 1
OPC_9 1
OPC_INDEX1 1
TABLESPACE_NAME COUNT(BYTES)
------------------------------ ------------
OPC_INDEX2 1
OPC_INDEX3 1
OPC_TEMP 2
RBS1 1
SYSTEM 4
TEMP 3
TOOLS 1
system ,temp,opc_temp got a value more than one, and metalink user says that it means tablespace get fragmentation.I am wondering why it is, and what is tablespace fragmentation
? I have an idea about "table fragmentation", but for tablespace, I really don't know.If you know about this , please give me some hints.
Thank you!!
steven chang
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-24-2003 03:27 PM
тАО12-24-2003 03:27 PM
SolutionEvery 3-6 months our DBA takes the databases offline and defragments them.
I personally have no idea what the procedure is though. That should be found by searching for defragment on metalink.oracle.com or technet.oracle.com
If you celebrate the holidays I hope they are good to you.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-24-2003 05:49 PM
тАО12-24-2003 05:49 PM
Re: tablespace fragmentation
steven chang
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-24-2003 06:14 PM
тАО12-24-2003 06:14 PM
Re: tablespace fragmentation
Start using Locally managed tablespaces (except for system tablespaces if before 9i) and say goodbye to fragmentation problem.
if you need further help, let us know
ho ho ho
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-25-2003 07:11 PM
тАО12-25-2003 07:11 PM
Re: tablespace fragmentation
Take a look at the following papers:
http://otn.oracle.com/deploy/availability/pdf/defrag.pdf
http://otn.oracle.com/deploy/availability/pdf/oow2000_same.pdf
Defragment is not necessary as most people think.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-25-2003 11:04 PM
тАО12-25-2003 11:04 PM
Re: tablespace fragmentation
http://www.orapub.com/cgi/genesis.cgi?p1=sub&p2=abs121
Tablespace freespace fragmentation is not a big issue. Check for row fragmentation.