In Oracle tablespaces and data files, Temp tablespaces and files are special. The temporary segment (tempsegment) corresponding to the Temp tablespace is automatically managed by Oracle.
In Oracle tablespaces and data files, Temp tablespaces and
In Oracle tablespaces and data files, Temp tablespaces and files are special. In addition to the temporary segment (Temp segment) corresponding to the temp tablespace, it is automatically managed by Oracle. The sparse file feature is also an
Tempfile. Temporaryfile
How your application needs a temporary file to store data, but does not need to be shared with other programs, creating temporary files with the Temporaryfile function is the best option. The other application is unable to
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
Critical and non-criticalNon-critical files are files that the database and most applications can continue to run without it. For example, if a database is missing a multiplexed redo log file, you can still use a different copy of the redo log file
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
I. Check Process(1) We can check the Database Alert LogExample:/U0/admin/SM/bdump/alert_sm.logThe temp tablespace error is not reported in the database. Generally, no error is reported. You can ignore the error because no temp tablespace is required.
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
Application of incremental backup in recovery phase, no longer restore phaseUnderstanding the Database Settings table:Sql>desc database_propertiesName Null? Type----------------------------------------- --------
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
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.