OutOfMemoryError:Java Heap Space on OEM 12c Agent

Sometimes we face issues like OEM agent 12c crashed and found the below error messages on gcagent.log[/agent_inst/sysman/log/gcagent.log]. Cause: When an OEM agent collects metrics data, it uses java memory. If it does not have access to the required amount of java memory which is specified in the configuration, the OEM agent may crash. Solution: 1- […]

Read More

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