Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error message SP2-0642

Status
Not open for further replies.

harwooddale

Programmer
Feb 7, 2003
40
GB
I have an sql that i am trying to improve the performance of.
I am running sqlplus and have set autotrace on to show me the explain plan and statistics.
In the statistics i get the following (worrying) error message:

Statistics
----------------------------------------------------------
0 recursive calls
17 db block gets
965 consistent gets
1149 physical reads
0 redo size
SP2-0642: SQL*Plus internal error state 1075, context 1:5:0
Unsafe to proceed

1096 bytes received via SQL*Net from client
16 SQL*Net roundtrips to/from client
1 sorts (memory)
1 sorts (disk)
96 rows processed

Does anyone know what it means and am i safe to proceed?
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top