Oracle temporary tablespace solution example

Source: Internet
Author: User
Today, my buddy told me that some modules in OA are invalid. After checking the system logs, it turns out that the temporary tablespace of the Oracle database is full, restart the database during lunch (this method is the easiest and not prone to errors ),

Today, my buddy told me that some modules in OA are invalid. After checking the system logs, it turns out that the temporary tablespace of the Oracle database is full, restart the database during lunch (this method is the easiest and not prone to errors ),

Today, my buddy told me that some modules in OA are invalid. When I checked the system logs on the Hong Kong server, it turned out that the temporary tablespace of the Oracle database was full, during lunch, I restarted the database (this method is the easiest and not prone to errors). I did not expect the temporary tablespace to be faulty. I will perform the following operations to restore it:

1. view the temporary tablespace size:

Select name, to_char (bytes/1024/1024) | 'M' from v $ tempfile;

The result shows that the temporary table size is 0 MB, as shown below:

NAMETO_CHAR (BYTES/1024/1024) | 'M'

/App/oracle/oradata/metenoa/temp01.dbf0M

2. Check the mounting status of the database file again:

Select file #, name, status, enabled from v $ tempfile;

Show STATUS as offline

Use the following statement:

Alter database tempfile '/app/oracle/oradata/metenoa/temp01.dbf' online;

Check the temporary table status as follows (ONLINE is normal ):

FILE # NAMESTATUSENABLED

1/app/oracle/oradata/metenoa/temp01.dbfONLINEREAD WRITE

Check the space size, which is displayed in numerical values as follows:

NAMETO_CHAR (BYTES/1024/1024) | 'M'

/App/oracle/oradata/metenoa/temp01.dbf351M

This article is from "Life is not limited, fighting is endless !" Blog, Hong Kong Server rental, please be sure to keep this source

, Website Space

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.