ORA-01650: unable to extend rollback segmentname By num intablespace name

Source: Internet
Author: User
ORA-01650: Unable to extend rollback segment name By num intablespace name

Cause: Oracle error is caused by insufficient tablespace In the rollback segment This is also the most common Oracle error message for ORACLE data administrators. When a user is performing a very large data operation, resulting in insufficient existing rollback segments, the table space of the available rollback segments is full and cannot be allocated, the preceding error occurs.

Solution: Use" Alter tablespace tablespace_name add datafile filename size size_of_file "Command to add a tablespace to the specified data. You can add one or more tablespaces as needed. Of course, this is also related to the bare disk device on your host. If there is no additional space for the bare disk device on your host, we recommend that you do not increase the size of the tablespace In the rollback segment. You can use the following statements to first query the remaining tablespace space:

Select user_name, SQL _text from V $ open_cursor where user_name = '';

If the extra space is large, you can append a large rollback segment to the tablespace to avoid the above errors. You can also use the following statement to check the rollback segment competition:

Select class, count from V $ waitstat where calss in ('System undo header', 'System undo Block', 'undo header', 'undo Block'); and

Select sum (value) from V $ sysstat where name in ('db _ block_gets', 'consistents gets ');

If the value of any class in count/sum (value) is greater than 1%, you should consider adding a rollback segment.

The corresponding English is as follows:

Cause: failed to allocate extent from the rollback segment in tablespace

Action: Use the alter tablespace add datafile statement to add one or more files to the specified tablespace.

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.