SP2-0642: SQL*Plus Internal Error State 1075, Context 1:5:4294967295
(Doc ID 1185294.1)
Last updated on MAY 27, 2023
Applies to:
SQL*Plus - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]Information in this document applies to any platform.
When execute a query returning a large set of data with trace to gather statistics, it fails with error:
SP2-0642: SQL*Plus internal error state 1075, context 1:5:4294967295
Unsafe to proceed
Listed below are the complete details:
SQL> set autotrace traceonly
SQL> select * from <LARGE_TABLE>
2 /
21610958 rows selected.
Elapsed: 00:06:09.68
Execution Plan
----------------------------------------------------------
Plan hash value: 172085227
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Tim
e |
| 0 | SELECT STATEMENT | | 21M| 3457M| 154K (1)| 00:
30:59 |
| 1 | TABLE ACCESS FULL| <LARGE_TABLE>| 21M| 3457M| 154K (1)| 00:
30:59 |
.......
......
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
1975553 consistent gets
568174 physical reads
0 redo size
SP2-0642: SQL*Plus internal error state 1075, context 1:5:4294967295
Unsafe to proceed
15848550 bytes received via SQL*Net from client
1440732 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
21610958 rows processed
SQL> select * from <LARGE_TABLE>
2 /
21610958 rows selected.
Elapsed: 00:06:09.68
Execution Plan
----------------------------------------------------------
Plan hash value: 172085227
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Tim
e |
| 0 | SELECT STATEMENT | | 21M| 3457M| 154K (1)| 00:
30:59 |
| 1 | TABLE ACCESS FULL| <LARGE_TABLE>| 21M| 3457M| 154K (1)| 00:
30:59 |
.......
......
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
1975553 consistent gets
568174 physical reads
0 redo size
SP2-0642: SQL*Plus internal error state 1075, context 1:5:4294967295
Unsafe to proceed
15848550 bytes received via SQL*Net from client
1440732 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
21610958 rows processed
Changes
There is no change in environment.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |