The ORA-03135 error is common when 1) Server unexpectedly terminated or was forced to terminate. or 2) Server timed out the connection. Solution–: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly insqlnet.ora file. In my Case i set these 2 parameters Read more…
When we Grant the Select privilege on a V$ view we will get an ora-02030 error. As ORA-02030 says, that we can only select from fixed tables/views, which means V$INSTANCE is not a table or view. We know that actual view created on the dynamic performance table that is V_$. The Read more…
The Oracle wait event model was originally introduced in Oracle7. Wait event information is gathered by the Oracle MMON background process, stored in intermediate x$ structures in a circular SGA buffer, and later transferred to Oracle10g dba_hist tables. Oracle 10g introduced the Active Session History (ASH) as part of the Diagnostics and Tuning Read more…
Oracle Database 19c, is the long term support release of the Oracle Database 12c family. It belongs to the family Oracle Database 12.2.0.X. 19c Long Term Release Premier Support (PS) ends April 30, 2024, Extended Support (ES) will be beginning May 01, 2024, through April 30, 2027 Error Correction / Patching is Read more…