Shulou(Shulou.com)05/31 Report--

Editor to share with you how to solve the problem of ORA-1652 errors in the database. I hope you will get something after reading this article. Let's discuss it together.

[error] ORA-1652

Some behaviors in the 1.ORACLE database that involve sorting operations:

Create an index

DISTINCT operation

Sort-Merge join operation (if there is no index, this join method is usually used for such join plus sort operations)

CREATE PRIMARY KEY CONSTRAINT, ENABLE CONSTRAINT, CREATE TABLE AS SELECT

Temporary tablespaces are the same as rollback tablespaces, the allocated extents can be reused, and their utilization queries cannot query views such as dba_free_space like ordinary tablespaces, and the utilization rate of temporary tablespaces

V$SORT_USAG

V$TEMP_SPACE_HEADER

>'| | temp tablespaces | | tablespace_name''round (- (s.tot_used_blocks*3)''to_char (sysdate,yyyymmddhh34miss) > col DatafileName A30 SQLset lin SQLSelect + f.bytes_used) 1024 1024,) "total MB", round ((f.bytes_free-nvl (p.bytes_used, / / 23d). "DatafileName", round (nvl (p.bytes_used, / / 25 + f.bytes_used) 1024,) "total KB", round (f.bytes_free-nvl (p.bytes_used, / 270) 1024,) "Used KB", 0 "Fragmentation" from10 +) d.tablespace_name and f.p.+) file_id3) SQLFOR > * / "MB", SESS.SQL_ID, SQL_TEXT FROM3 = 4 = 5 BY BLOCKS > COL USENAME A10 SQLFOR > COL TABLESPACE A15 SQLFOR > A.USERNAME, A.SID, A.Seria, A.OSUSER, B.TABLESPACE, B.BLOCKS, C.SQL_TEXT FROM3 = 4 = 5 = 6 BY B.TABLESPACE, B.BLOCKS

In fact, when we find the ORA-1652 error in the warning log, the sorting operation is completed and the space is freed, in which case we can find the corresponding SQL in the following ways:

V$SQL_WORKAREA

SQLSELECT SQL_ID,LAST_TEMPSEG_SIZE WHERE SQL_ID'';SQLSELECT SQL_ID,DIRECT_WRITES0,EXECUTIONS) FROM V$SQL = 6r2k8sy8mtk25

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.