Yesterday, the system submitted approval flow has been reported "system busy", to view the background, found to be "ORA-01652: unable to extend the temp segment by 128 (in the tablespace temp)", this indicates that the temporary table space is
Set LoadRunner Load Machine temp file directory recently in run stabilityTest3 X 24 hours, found that the load machine generated logs are running records and so on more than 100 g! C disk space is not enough, but the D disk has more than 700 g
The latest error message "unable to extend temp segment by 8192 in tablespace..." was prompted during rebuild index. This is a common error. When creating an index, you need to use the user's default temporary tablespace for sorting and generating
The MySQL temp table is divided into temporary tables used by the system and temporary tables used by the user.The temporary table used by the system means that MySQL relies on temporary tables to complete the process when executing certain SQL
To view this type of files, you need to set to show hidden files. The specific settings are as follows:Open the Control Panel (classic view)-> Folder Options-> View-> advanced settings, and deselect the "Hide protected operating system files
Temporary tablespace is a temporary tablespace in Oracle. The temporary tablespace is mainly used to provide temporary computing space for database operations such as sorting, index management, and view access, after the computation is completed,
I. Temporary table space contraction
1.1 Description
About Oracle's temporary tablespace, a blog has been collated before:
Oracle Temp temporary table space
http://blog.csdn.net/tianlesoftware/article/details/4697417
The following operations can
Temporary tablespace is a special structure in the Oracle architecture. Generally, the database user only needs to set the corresponding Temporary tablespace (to the user) and temporary segment allocation
Temporary tablespace is a special structure
Applies To:Oracle database-enterprise edition-version 8.1.5.0 and laterInformation in this document applies to any platform.GOALHow to release Temp LOB Segment that have been created explicitly or implicitly by Oracle for intermediate stages of
In an Oracle database, order by or group by, index creation and re-creation, distinct operations, Union & intersect & Minus Sort-merge joins, Analyze operations, Exceptions , and so on, can produce a lot of temporary data. If you have a table of
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.