- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Reorganize temporary segment ??
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
тАО06-19-2002 07:55 AM
тАО06-19-2002 07:55 AM
When I run the query "select segment_name, count(*) from user_extents group by segment_name;" I found that there is a strange output which is just a number showing in the segment_name field. Then I issue "select object_name, object_type from user_objects where object_name='The segment_name I found in the previous query';" I found that the object_type is temporary !! Just want to know what happened to my system?? How to remove the temporary segment ??
Please help,
Chris,
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2002 05:22 PM
тАО06-19-2002 05:22 PM
Re: Reorganize temporary segment ??
This will be cleaned up on a shutdown.
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2002 06:00 PM
тАО06-19-2002 06:00 PM
SolutionIf you see too many extents for this segments(>50), then you should change the next extent of the temporary tablepace holding that temporary segment.Otherwise the shutdown of database will take a lot of time becuase SMOn process needs to clean up these temporary segments before the DB can be shutdown.
Thanks
AR
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2002 11:35 PM
тАО06-19-2002 11:35 PM
Re: Reorganize temporary segment ??
Is that in the tablespace can be extended automatically in Oracle8i ? Cause the System default "Temp" tablespace of my machine grew up to 4GB something !!
I am afraid if the Temp tablespace will grow and may cause file system full in Unix level and that may halt the database. Is that something I can do to prevent this from happen ?
Thanks,
Chris,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2002 11:42 PM
тАО06-19-2002 11:42 PM
Re: Reorganize temporary segment ??
datafiles of a tablespace can only grow automatically if autoextend has been defined for this datafile.
I opt to prevent autoextend for temp and rollback segments: any crazy SQL statement might cause temp and/or rollback to grow beyond control.
FYI:
If the TEMPORARY TABLESPACE is of type TEMPORARY, the space is not released until the instance is shutdown. If the TEMPORARY TABLESPACE is of type PERMANENT, then cleanup is performed by SMON after completion of the process using it.
regards,
Thierry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-20-2002 01:36 AM
тАО06-20-2002 01:36 AM
Re: Reorganize temporary segment ??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-20-2002 11:15 AM
тАО06-20-2002 11:15 AM
Re: Reorganize temporary segment ??
I have script which monitors the free space in my tablespace and alerts me when it goes down below a certain threshold.This way i can closely monitor the segment growth in all the tablespaces.
You can closely monitor the temporary segment usage through following views.
v$sort_segment
v$sort_usage
v$sysstat-name in sorts(memory) and sorts(disk).
If you have lot of free memory, then you can increase the sort_area_size to reduce the number of sorts in disks.
For sort intensive operations like create index,analyze you can set a higher sort_area_size at session level to redice the disk level sort usage.
alter session set sort_area_size=25000000;
Thanks
AR
thanks
AR