Thursday, December 29, 2022

[DBT-50000] unable to check for available memory.

[DBT-50000] unable to check for available memory.


Are you installing Oracle Database on Windows machine?
You may come across the [DBT-50000] unable to check for available memory.
When you run installer using dbca.bat file, you many encounter DBT-50000 as shown in below screenshot.




This is due to a Bug 29686671

To over come this issue you should run the dbca.bat file with below option.
dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false

Open command prompt - > go to the bin directory and run below command
dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false



Hope this will helps




Thanks & Regards,
Chandan Tanwani
Oracle Performance Tuning Certified Expert

Friday, July 22, 2022

Oracle Community Yatra (OCYatra) 2022

 Oracle Community Yatra (OCYatra) 2022

The Oracle Users Group Evangelists of AIOUG (All India Oracle Users Group) in the region are organizing an “Oracle Community Yatra (OCYatra)” event in July 2022. This event is going to organize across six cities in India, i.e. Chennai, Bengaluru, Mumbai, Pune, Delhi & Hyderabad. 

This will be the Face-to-Face conference. This conference is designed for deep technical sessions, master classes, Fireside chats, keynotes and Oracle ACE Community. 

OC Yatra Dates & Locations 
23 July 2022, Saturday - Chennai
24 July 2022, Sunday   - Bengaluru
26 July 2022, Tuesday  - Mumbai
28 July 2022, Thursday- Pune
30 July 2022, Saturday - Delhi
31 July 2022, Sunday   - Hyderabad


I am happy to share that myself and Aishwarya Kala are speaking across five cities i.e. Bengaluru, Mumbai, Pune, Delhi and Hyderabad.

In this session we will cover, Oracle Optimizer over the years, it has evolved into a very complex being.  In this session, we will take a deep dive into the world of Optimizer Internals. We will begin with understanding how the optimizer works, what are the parameters that control its behavior, how they can help with optimizing a SQL Execution and their impact on performance. 

Along with this, we will also explore the various myths around these parameters and clarify how they work in reality!  

We will also take a look at the way in which the optimizer has evolved over time, the various new enhancements with the latest releases like 19c and 21c, and its behavior on-premises, on the cloud, including the Autonomous Databases.



Join us and let's learn about Oracle Optimizer Techniques and new Optimizer features of On-premise and over the Cloud.

OCYatra At A Glance [Also Register via this link]

OCYatra Speakers

OCYatra Agenda


Thanks & Regards,
Chandan Tanwani
Oracle Performance Tuning Certified Expert

Post Upgrade to 19c Performance Issue with Library Cache

Post Upgrade to 19c Performance Issue with Library Cache