Sunday, August 7, 2022

Oracle Global Temporary Table ORA-01555 and XML Data Size

›
(1)-Oracle Global Temporary Table ORA-01555 and Undo Retention       (2)-Oracle Global Temporary Table ORA-01555 and XML Data Size      ...

Oracle Global Temporary Table ORA-01555 and Undo Retention

›
(1)-Oracle Global Temporary Table ORA-01555 and Undo Retention       (2)-Oracle Global Temporary Table ORA-01555 and XML Data Size      ...
Monday, July 18, 2022

Plsql ORA-00600 by JDBC Call Exception Catch

›
When Plsql executions hit ORA-00600, the session can be disconnected or not disconnected. In this Blog, we will make tests to show both ORA...
Sunday, June 26, 2022

Tests of Oracle ORA-01866: the datetime class is invalid

›
In this Blog, we will make a few tetss of Oracle ORA-01866 in Named and Offset Time_Zone (TZ). Note 1 : Tested in Oracle 19.13, 19.10, 18...
Tuesday, May 24, 2022

How volatile is ORA-00600 [qernsRowP] ?

›
ORA-600 [qernsRowP] seems related to a parallel query when the execution plan includes SORT GROUP BY NOSORT. This Blog will demonstrate OR...

One Case of ORA-00036: Maximum Number Of Recursive SQL Levels (50) Exceeded

›
ORA-00036 is documented as: 00036, 00000, "maximum number of recursive SQL levels (%s) exceeded" // *Cause: An attempt was ma...
Monday, April 11, 2022

Oracle Write Consistency and ORA-30926: "unable to get a stable set of rows in the source tables"

›
(1)-Oracle Write Consistency and ORA-00600: [13030], [20]       (2)-Oracle Write Consistency and ORA-30926       We will discuss Oracle Wr...