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 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 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, Read more…
Oracle delivers Oracle Database Innovation Releases In between Oracle Database Long Term Releases that include many enhancements and new capabilities which will also be included in the next Long-Term Release. Innovation Releases are designed to enable customers to continuously use Read more…