Difference Between Local Listener and Remote Listener

LOCAL_LISTENER is a listener that is running on the same machine as this instance. REMOTE_LISTENER is a listener that is not running on the same machine as this instance. Local Listener and Remote Listener concept comes with ORACLE RAC where a single database has multiple instances. Consider an example of 2 Node RAC Database which […]

Read More

How Delete Statement Works

When Oracle receives sql/Delete query, it requires to run some pre-tasks before actually being able to really run the query. During parsing, Database validate the syntax of the statement whether the query is valid or not. Database validate the semantic of the statement. It checks whether a statement is meaningful or not. If syntax/Semantic check […]

Read More

How Update Statement Works

When Oracle receives sql/update query, it requires to run some pre-tasks before actually being able to really run the query. During parsing, Database validate the syntax of the statement whether the query is valid or not. Database validate the semantic of the statement. It checks whether a statement is meaningful or not. If syntax/Semantic check […]

Read More

How Insert Statement Works

When Oracle receives sql/insert query, it requires to run some pre-tasks before actually being able to really run the query.   During parsing, Database validate the syntax of the statement whether the query is valid or not.   Database validate the semantic of the statement. It checks whether a statement is meaningful or not.   […]

Read More

Oracle Cloud Platform Systems Management 2018 Associate (1Z0-930)

Hi Readers Finally, I’ve successfully passed 1Z0-930, Oracle Cloud Platform Systems Management 2018 Associate. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 70 questions related to Oracle Management Cloud. To earn this certification you need to get 70% marks. This was the result of the journey: Oracle Cloud […]

Read More

Upgrade Oracle DBA 11g or 12c to 12c R2 (1Z0-074)

Hi Readers Finally, I’ve successfully passed 1Z0-074, Upgrade Oracle DBA 11g or 12c to 12c R2. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 75 questions related to Oracle Database 12cR2 New Features. To earn this certification you need to get 63% marks. This was the result of […]

Read More

List of Publication

I am listing here 55 articles which I write and are published on the different Oracle Technology Network  (OTN), different Oracle User Group (OUG) and ToadWorld. OTN Spanish Oracle Cloud: Creación de Configuración Oracle RAC en Cloud Oracle Cloud: Creando base de datos en la nube en base a “backup” existente (Parte I) Oracle Cloud: […]

Read More

Oracle Autonomous Database CookBook

Written by Oracle Certified Master Skant Gupta and Oracle Certified Professional Mohit Sharma are diligently planned to direct the readers about the usage of Oracle Autonomous Database.  The primary target audience is Oracle DBAs and Oracle Cloud DBA’s. This book has been diligently planned for all levels of DBA experts. Coming right from the real-world […]

Read More

Oracle Exadata Database Machine 19.1.0 Documentation

Exadata System Software Release 19.1.0.0.0 is now generally available. This release lays the foundation for the Autonomous Database and improves every aspect of Exadata with 20+ features and enhancements. All new features and enhancements are available on all supported Exadata generations, protecting customer investment across all Exadata deployment models: on-premises, Cloud Service, and Cloud @ […]

Read More

Oracle Database 19c Now Available

The latest generation of the world’s #1 database, Oracle Database 19c, is now available on LiveSQL.oracle.com. Oracle Database 19c is a long term support release, with premier support planned through March 2023 and extended support through March 2026. For the latest Oracle Database 19c availability on other platforms, check out Document ID 742060.1 on My Oracle Support […]

Read More