Sunday, September 11, 2022

Proposal for ORA-04030 incident/trace files Enhancement to list Plsql package Memory Usage

›
For "ORA-04030: out of process memory" incident/trace files, we would like to propose to list Plsql package (both spec and body) n...
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...